Forum Discussion
Building relations between Acccount & Opportunities using Dynamics CRM Online
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 Opportuni...
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 ?