Forum Discussion
Bridging Table not working as expected
I have two tables that I need to show data from. They both have a 'National Code' that is not unique in either table. I am trying to use a bridging table consisting of one column with a comprehensive...
Hi Anonymous ,
It’s prompted that can’t display the data coz power bi can’t determine the relationship between these two tables.
Why don’t you try to set the relationship bwteen CourseMasterData with LearningBankData1 directly?
v-frfei-msft
Community Support
Community SupportHi Anonymous ,
It’s prompted that can’t display the data coz power bi can’t determine the relationship between these two tables.
Why don’t you try to set the relationship bwteen CourseMasterData with LearningBankData1 directly?
Thanks Frank,
Yes this works thanks. I was using an older version of PBI which did not have the many to many cardinality. I have now got the new version and the many to many works just fine. Thanks