6
Hi,
I'm creating a Power BI report which queries Dynamics CRM using an oData URL. I was able to retrieve various entities like account, opportunities and leads. Within each of these entities are lookup fields. For example, the Accounts has a lookup field named "Relationship Type".
I was wondering if there is an entity in the CRM that stores the lookup fields? (in the account table, it displays a number, which is probably used to lookup the actual value of the entity).
Sincerely,
Jason
Hi,
I would recommend you to use Common Data service connector which gives you the lookup field name value in the same table.
docs.microsoft.com/.../data-platform-powerbi-connector
Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: xrmdynamicscrm.wordpress.com/
Hi Hason Yeung,
Lookup is giving you a GUID, if you need its name, then you need to retrieve a relationship table with its primary name column.
Let me know if I can provide any additional details.
Thanks
Regards,
Abdul Wahab
Share
Report
All responses (
Answers (
