Dataverse Modeling

[JKlein]

Hi,

I am trying to create a basic data model based on the 'Opportunity' and 'Goal' entities from Dataverse. However, I am wondering what the best approach and best practices are for creating relationships in Power Bi from Dataverse. Each relational table has natural IDs that can be used for connections (e.g., 'Client' with 'Opportunity' using AccountID/OpportunityID), but the question is, should they be used, or should I create separate index keys?

I would really appreciate your help.

[VijayP · Accepted solution]

@JKlein 

You can just use the keys available in Dataverse and no need to create additional columns native power bi.

Actually that will cause more burden to Power BI Engine