cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dominik_ioz Frequent Visitor
Frequent 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 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

3 REPLIES 3
Rémi Member
Member

Re: Building relations between Acccount & Opportunities using Dynamics CRM Online

Hi,

 

You have the customer of your opportunity into the column CustomerId.

 

dominik_ioz Frequent Visitor
Frequent Visitor

Re: Building relations between Acccount & Opportunities using Dynamics CRM Online

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 Member
Member

Re: Building relations between Acccount & Opportunities using Dynamics CRM Online

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 ?

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)