Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
4 years ago
Solved

Make relationship between tables in Power BI

Hello,

 

I would like to ask how make a relationship between tables if there is no column to to connect it. I mean two tables have very different columns.

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Analitika ,

     

    As far as I know, we always select the related keycolumn in two tables to create relationships. After we have created a relationship between two tables, we can create visuals by columns from another table. Power BI will filter the column from another table by the logic based on related columns.

    So if there is no column to connect them, though you can create a relathipcreating a relationship makes no sense. I suggest you to add a keycolumn like Index or other columns in two tables and then create a relationship by keycolumns.

    Here are some offical blogs about relationship in Power BI. I hope they could help you solve your problem.

    For reference: 

    Model relationships in Power BI Desktop

    Create and manage relationships in Power BI Desktop

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Hariharan_R's avatar
    Hariharan_R
    Solution Sage
    4 years ago

    Hi,

      Your scenario will not fit into proper Power BI data model and relationship. If you still need to join those two tables then in Power query layer, you can join them together and take the result into Power BI report.

     

    Thanks

    Hari

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Analitika ,

     

    As far as I know, we always select the related keycolumn in two tables to create relationships. After we have created a relationship between two tables, we can create visuals by columns from another table. Power BI will filter the column from another table by the logic based on related columns.

    So if there is no column to connect them, though you can create a relathipcreating a relationship makes no sense. I suggest you to add a keycolumn like Index or other columns in two tables and then create a relationship by keycolumns.

    Here are some offical blogs about relationship in Power BI. I hope they could help you solve your problem.

    For reference: 

    Model relationships in Power BI Desktop

    Create and manage relationships in Power BI Desktop

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.