Access Dataverse choice labels directly from Azure Synapse Link for Dataverse

  • Article

Important

This content is archived and is not being updated. For the latest documentation, go to What is Microsoft Dataverse?. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically May 9, 2022 -

Business value

Easily read the user-friendly version from Dataverse choices text label data using Azure Synapse Link for Dataverse.

Feature details

Previously, Azure Synapse Link for Dataverse wrote an integer label rather than the text label for columns that use Microsoft Dataverse choices (option sets) to maintain consistency during edits. This approach required users to take extra steps to access the integer-to-text label mapping that is stored in the Microsoft.Athena.TrickleFeedService/table-EntityMetadata.json file to make it available with their Dataverse data.

Now, Azure Synapse Link for Dataverse customers have access to a separate table containing their Dataverse choices integer-to-text label mapping that can be easily joined with the raw Dataverse data to expose the text label for each Dataverse choice column. This helps citizen developers and data engineers alike to easily read the user-friendly version of their Dataverse data.

See also

Access choice labels directly from Azure Synapse Link for Dataverse (docs)