Make relationship between tables in Power BI

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.