Forum Discussion

dilkushpatel's avatar
dilkushpatel
Helper III
7 years ago
Solved

Power BI Relationship Not working

Hi,

 

I have two tables which has ColumnX and in both table it is not unique

So I created calculated table with distinct value of ColumnX and created 2 way relationship with both tables

 

however when i add columns from those 2 tables in Power BI tablix it is not able to find relationship between this two table?

 

Shouldn;t it find it based on relationships I created?

 

Thanks,

Dilkush

Need Help
Show and Tell
Tips and Tricks
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

     

    can you please make a screenshot from the relationship view of your data model.

     

    I assume that you either referring to the table or matrix view by mentioning "Power BI tablix"?

     

    Regards,

    Tom

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago

    Hey,

     

    can you please make a screenshot from the relationship view of your data model.

     

    I assume that you either referring to the table or matrix view by mentioning "Power BI tablix"?

     

    Regards,

    Tom

    • dilkushpatel's avatar
      dilkushpatel
      Helper III
      7 years ago

       

      Looks like it is working now!!!

      may be temporary glitch!!!

       

      Thanks for quick response