crm and power bi

[userxoxo]

hi guys, I am a super beginner 

and I am working on extracting data from dynamics 365 CRM entities and making power bi dashboards 

but when I extract the entities I don't know what is exactly the relationships 

[negi007]

@userxoxo you can import data/tables into powerbi and then can define relationship between tables. once relationship is defined, then you can create your measure and reports. to be able to create correct relationship between tables, you need to have the basic understanding of the data else you will have issues in your calculation. If your dataset is not too big then it should not be two difficult to understand it to create correct relationship between tables. FYI creating relationship between tables is one of the primary taks one has to do before moving to report creation etc.

few links that can help you on this

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

https://www.youtube.com/watch?v=Pi02NKw6GPc