Skip to main content

Data Factory

New

Dataverse / Dynamics Connector in Fabric Pipelines Not Returning Lookup Fields

Vote (1) Share
Lasith Assalaarachchi's profile image

Lasith Assalaarachchi on 23 Jan 2025 20:44:57

When connecting to a Microsoft Dynamics CRM through the Dataverse connection in Power BI, we get certain details about lookup fields. For instance, for the record creation user, you get the username and the useryominame in addition to the GUID. However, when connecting to the same table through Fabric Data Pipeline, lookup tables only return the GUID. The related columns are returned, but are empty.


If we can get parity between the Fabric connection and the Power BI connection for Dynamics/Dataverse where Fabric connection will also return the content on those related fields (for lookup fields), that would be great.


Thanks!