Data Factory
NewDataverse / Dynamics Connector in Fabric Pipelines Not Returning Lookup Fields
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!