Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I am using PowerBI Desktop to connect to my Dynamics CRM Online data. So far so good. When importing tables I do not find keys which would allow to connect my AccountSet and OpportunitySet tables. The relationship between an opportunity and an account is an n:1 by default. So I am facing the problem that I do not find the foreign key to connect those table in PowerBI.
Anyone an idea how I could connect the tables?
Thank you!
Dom
Hi,
You have the customer of your opportunity into the column CustomerId.
Hi, thanks for your reply. Somekind like that was also my expectation, now I see a more precise issue, thanks!
Unfortunately I don't get this colum using the the CRM connector in PowerBI.
The available data preview shows more columns, but the load procedure seems to skip it. How can I force PowerBI to get me all columns?
Hi
Power BI get all the data directly.
Are you sure to not find the column? This column is a Record column, it means that you have to develop it for getting the value.
At the end of the table, you have a list of columns with value Record or Table ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.