Forum Discussion
dominik_ioz
10 years agoRegular Visitor
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...
dominik_ioz
10 years agoRegular Visitor
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?
Rémi
10 years agoResolver III
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 ?