Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    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?

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
6 years ago
What is the measure you created that is generating the error. Can you please share the measure and the error it is generating
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.