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?
amitchandak
Super User
Super UserSelect cmd_national_code from bridge table. and try.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
No that did not work. Here's a link to the file.
https://www.dropbox.com/s/l75tln43a96rl9s/BridgingTable.pbix?dl=0