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.
Hello bmjacques,
Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.
Thank you.