Forum Discussion

haassiej's avatar
haassiej
Helper I
6 years ago

Power BI relationships dataflow CDM

Hi all,   I've some issues with working with the CDM, dataflows and the relationships defined in the model.json.   The first step is getting the data from Dynamics to my Azure Data Lake gen 2 in ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi haassiej ,

 

Sorry, I couldn't find where "the relationships defined in the model.json are not correct handled in Power BI desktop", can you give me a hint?

 

Best Regards,

Jay

haassiej's avatar
haassiej
Helper I
6 years ago

In the model.json file, relationships are written between certain entities from Dynamics (the Common Data Model (CDM)). So you would expect that if you connect Power BI to your "model.json" file, the relationships will be included in Power BI.

 

That does not happen now, so you have to manually establish all relationships yourself. In my case more then 60 relations.

 

In the example of the relationships in model.json you see a relationship of:

AssetTransactionSummaryEntity: TransDate
to
FixedAssetTransactionDate: Date_

 

Power BI does not recognize this relationship described in the JSON. Power BI itself searches for relationships and comes up with the relationship "ROW_UniqueKey" to "Row_UniqueKey"

 

So it doesn't read the relationships from the generated model.json