cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DaveCope Frequent Visitor
Frequent Visitor

D365 Entity Store Relationships

Hi

 

I am working with a new client and for the first time I need to create some embedded reports using Power BI within D365 Finance & Operations. 

 

I have sucesfully linked the Entity Store to Power BI desktop but I am having trouble figuring out which entities I need to include in my report and how they are all related. Is there any documentation anywhere that shows a data / relationship model of the standard entities?

 

I've tried to use some of the pre-built content / apps but can't seem to find where to download the pbix file from to able to utilise the model setup in there?

 

I have not workd with D365 before so apologies if I have missed something obvious

 

Any help would be much appreciated


Dave

4 REPLIES 4
Community Support Team
Community Support Team

Re: D365 Entity Store Relationships

Hi @DaveCope,

 

Here is a document to help you understand data model.

 


 I've tried to use some of the pre-built content / apps but can't seem to find where to download the pbix file from to able to utilise the model setup in there?


For content/apps, we can view reports inside them on service, while it is not supported to download correponding .pbix file.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DaveCope Frequent Visitor
Frequent Visitor

Re: D365 Entity Store Relationships

Hi @v-yulgu-msft thanks for the reply and link

 

Whilst there is no way to download the .pbix file is there any way we can see the underlying entities and relationships used to create the report? I am finding it really hard to get to grips with which entites contain the data I need to build the reporting requirements of the user

 

Thanks


Dave

Highlighted
Matteoaba Frequent Visitor
Frequent Visitor

Re: D365 Entity Store Relationships

Hi @DaveCope,

you can download power bi content pack PBIX files from https://lcs.dynamics.com, under shared asset library, power bi report model.

 

Matteo

DaveCope Frequent Visitor
Frequent Visitor

Re: D365 Entity Store Relationships

Hi Matteo

 

I have never been into the LCS before, so apologies for my ignorance, but when I login in I see the following with no content showing??

 

Capture.JPG