Forum Discussion

JKlein's avatar
JKlein
New Member
2 years ago
Solved

Dataverse Modeling

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.

  • 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

1 Reply

  • VijayP's avatar
    VijayP
    Community Champion

    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