Receive Azure Synapse Link for Dataverse notifications in Power Apps
The state of your Azure Synapse Link for Dataverse is stored in a Microsoft Dataverse table with real-time updates. You can customize a notification using Power Automate flows or Power BI to stay on top of the state of your Azure Synapse Link for Dataverse activity instead of manually checking the Azure Synapse Link for Dataverse profile page in Power Apps (make.powerapps.com).
The Azure Synapse Link for Dataverse profile and its synchronization status are stored in six system-generated read-only tables within Dataverse. These tables are designed to refresh and update in real time, ensuring that the information contained within them remains accurate and up to date at all times.
How notification works with Azure Synapse Link for Dataverse
To customize a notification, monitor the data changes in a Dataverse table related to the synchronization status of Azure Synapse Link. By tracking these changes, you can export the updated data for visualization using Power BI or set up an automated cloud flow that activates whenever there's a change in the Azure Synapse Link for Dataverse state. This is achieved by reading the row change from any of the Azure Synapse Link state tables.
Connector to use for a Power Automate flow
We recommend users have the appropriate Power Platform licensing to use Power Automate to customize the trigger function. Use the Dataverse connector, which triggers a flow when a row is added, modified, or deleted in the selected Dataverse table. More information: Trigger flows when a row is added, modified, or deleted - Power Automate
Several options are available for using Power Automate to send notifications. Here are some examples.
| Action | Connector reference |
|---|---|
| Send a Teams instant message | Microsoft Teams |
| Send a text message to mobile device | Azure Communication Services SMS |
| Send an email to one or more recipients | Mail Office 365 Outlook |
| Send a notification to Power Apps or Power BI | Power Apps Notification Power BI |
Dataverse tables and columns used to track state
There are tables that store all Azure Synapse Link profile information. The two main tables listed below provide all sync state information for your Azure Synapse Link profile.
| Table name | Description | Table reference |
|---|---|---|
| Azure Synapse Link external table state | This table has data only if you have Delta Lake profile. This table represents external nonpartitioned tables state in connected Synapse workspace. One record per synced entity including metadata table like option set. |
synapselinkexternaltablestate |
| Azure Synapse Link profile table state | This table represents the sync state of the Azure Synapse Link entity in Azure Data Lake storage. One record per synced entity excluding metadata table such as option set. |
synapselinkprofileentitystate |
Here are some useful columns for monitoring the health of your Azure Synapse Link in each table:
EntityNameandSynapseWorkspaceNamecan be used as the primary identification of the selected table. Synapse workspace name is the same as Azure Synapse Link profile name shown in Power Apps.LastSynchronizedOnreturns the date and time when the latest round of the Delta Lake conversion was successfully completed for each table.RecordCountreturns the total number of records in the Delta Lake profile, minus soft-delete records for each table.TableStateis marked as created if the link to the data lake and Delta Lake conversion is active and error-free.
A soft-delete in the Azure Synapse Link external table state table is performed: LastSyncState and TableState are marked as deleted for removed tables.
Azure Synapse Link profile entity state tables:
EntityNameand profile can be used as the primary identification of the selected table. The profile is the same as the Azure Synapse Link profile name shown in Power Apps.InitialSyncProcessCompletedTimeandInitialSyncStatereturn the initial sync completion status, which includes both metadata and raw data. The initial sync state marks as Completed once the initial sync completes.LakeRecordCountreturns the total records exported to Data Lake in CSV format.LastSyncedDataTimereturns the date and time when the latest round of the data lake file updated or created successfully for each table.SyncStateshows as InProgress if the link to data lake is active and error-free.
Note
LakeRecordCount is different from Dataverse record count for the following reasons:
- Sync latency.
- Append-only mode captures transactions and appends one additional row for each CUD operation.
The remaining four tables provide additional details for Azure Synapse Link setup information:
| Table name | Description | Table reference |
|---|---|---|
| Azure Synapse database | This table captures linked Azure Data Lake storage and Synapse workspace and setup metadata information (one record per Azure Synapse Link profile). | synapsedatabase |
| Azure Synapse Link profile | This table captures Azure Synapse Link profile information (one record per Azure Synapse Link profile). A soft-delete in this table is performed: ProfileState is marked as deleted for deleted profile. |
synapselinkprofile |
| Azure Synapse Link profile entity | This table captures entity metadata within the connected Azure Synapse Link profile (one record per synced table). | synapselinkprofileentity |
| Azure Synapse Link schedule | This table captures Azure Synapse Link profile information for incremental folder update or delta lake conversion time interval (one record per Azure Synapse Link profile). | RecurrenceInterval |
See also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for