Make relationship between tables in Power BI

[Analitika]

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.

[Anonymous · Accepted solution]

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.

[Hariharan_R]

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