Broken table visual when migrating a report from import mode to live connection

[Anonymous]

I have a report with imported data, consisting of one table C holding customer data, and two fact tables T1 and T2. There is a both sided relationship between each C and T1 and C and T2 on a unique customer Id.

I added a table visual displaying the customer Id from C, one column from T1 and one column from T2. This works fine.

Now I recreated the same data model in SSAS Tabular and created the same visual within a Power BI report with a live connection to SSAS. Now the tile is broken with the error message

"Can't display the data because Power BI can't determine the relationship between two or more fields."

The relationships are the same in both models. What's going on here?

[v-shex-msft]

Hi @Anonymous,

Based on error message, it seems like power bi can't analysis the existed column relationships. Can you please share more detailed informations about this issue?

Regards,

Xiaoxin Sheng

[yolanda_meng]

We are having the same issue here, the relationship exists in the SSAS Model but get the error msg in Power BI.