How to backup the hidden tables in dataverse

Question

I have an "activity party" table in Dataverse It's related to the "activity pointer" table, but couldn't able to back up the "activity party" table because it's a hidden table. so how can we back up the records of the activity party table?

Answer 1

Dataverse tables like "activity party" can be accessed via the Web API. Even if they are hidden in the interface, their data can be queried and exported using the API.

• Use the Web API endpoint for your environment to query the "activity party" table data. Here's an example endpoint: https://your-org.crm.dynamics.com/api/data/v9.1/activityparties.
• Once you access the API, retrieve the data in a structured format like JSON.
• Export the structured data to a secure storage location or file.

Azure Data Factory can also be used to backup Dataverse tables, even if they are hidden.

• Create a pipeline in Azure Data Factory.
• Use the Common Data Service (current environment) connector to connect to your Dataverse environment.
• Set up a copy activity in the pipeline to copy data from the "activity party" table to your destination (e.g., Azure Blob Storage, Azure SQL Data Warehouse, etc.).
• Execute the pipeline and backup the data.

If you're using Azure Synapse Analytics, you can leverage the power of Power Query and serverless SQL pool to get the data from Dataverse and then save it to the desired format/location.

• Connect to Dataverse from Azure Synapse using Power Query.
• Query the "activity party" table and load the data into Azure Synapse.
• From there, you can backup or save the data as per your requirements.

Check this link it may help : https://forwardforever.com/how-to-restore-dataverse-records-accidentally-deleted/

Answer 2

Hello @Janaarth Veluswamy Please let us know if you need to add more info so that we better assist you!

Please let us know if we can close this thread.

Another way to backup the "activity party" table in Dataverse is to use the Export to Excel feature. This feature allows you to export the data from the table to an Excel file, which can then be saved as a backup.

To use this feature, follow these steps:

1. "Export to Excel"
2. Save the exported file to a secure storage location.

This method is quick and easy, but it may not be suitable for large datasets or frequent backups. In that case, you may want to consider using one of the other methods mentioned earlier.