Power BI relationships dataflow CDM

[haassiej]

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 the CDM folders:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/entity-store-data-...

Then I create a dataflow in the Power BI service on this folder:

https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-add-cdm-folder#create-a-...

Afther this step I connect to my dataflow in Power BI desktop:

https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-create-use

But the relationships defined in the model.json are not correct handled in Power BI desktop. Does someone know how I can fix this?

The model.json relationships are generated well by Dynamics. (See: https://docs.microsoft.com/en-us/common-data-model/model-json#relationships)

Model.json relationships:

Power BI desktop relationships:

[dafrAdifo]

Any news here? I have the exact same problem. 

Thanks in advance

[price1d]

Still no movement 3 years later?

[v-jayw-msft]

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]

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