Forum Discussion
Solved
Importing a Lookup Field
I am attempting to build a Power BI report using data from Microsoft Dynamics CRM. I have built many reports using SQL to import the data. My problem is that I need to import the pricelevelid field f...
Hi bmjacques,
Thank you for posting your query in the Microsoft Fabric Community Forum.
To bring the lookup name into Power BI, please use the Dataverse connector instead of SQL.
With the Dataverse connector, Power BI automatically provides both the lookup GUID and the readable display name without any extra steps.Official documentation:
- https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tabs=Dataverse
- https://learn.microsoft.com/en-us/power-query/connectors/dataverse
Best regards,
Ganesh Singamshetty.
