Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
Several tables store Azure Synapse Link profile information. For low latency sync enabled tables, use the Azure Synapse Link profile entity state table to monitor the sync state of all tables.
| Table name | Description | Table reference |
|---|---|---|
| Azure Synapse Link profile entity state | This table represents the sync state of each Azure Synapse Link table in Azure Data Lake Storage. This table is updated for all low latency sync enabled tables. | synapselinkprofileentitystate |
To monitor the health of your Azure Synapse Link, use the following columns in the Azure Synapse Link profile entity state table:
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 Azure Synapse Link external table state (synapselinkexternaltablestate) table applies only to Delta Lake and bring your own data lake (BYOL) profiles. It isn't updated for low latency sync enabled tables. For low latency sync enabled tables, use synapselinkprofileentitystate.
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 |