Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 list of unique 'National Code's. The visual (a Table) that contains info from both tables errors. Can anyone tell me what I am missing here? Here's screenshots of a moc example:
Solved! Go to Solution.
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?
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?
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
Select 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
I am not using any measure, just the 'CMD_National Title' from the 'CourseMasterData' and the 'LB_Info'from the 'LearningBankData1' as per the screen shot. The error is shown in the screen shot also.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |