Forum Discussion
Importing a Lookup Field
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.
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.
Thank you for this - it seems like a likely solution, but I will need our IT department to implement.
