Forum Discussion

Pp110784's avatar
Pp110784
Icon for Helper II rankHelper II
2 years ago
Solved

Not able to join data from 2 tables in my report

I have an existing Power BI report which is pulling data from 1 table (let's say table A). I have made quite a few modifications to the data to create that report. So I've added a lot of measures and...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Pp110784 ,

Based on my testing, please try the following methods again:

1.Create the simple tables.

2.Create the relationship between the two tables.

3.Drag the plan name and plan service providers into the table visual. The result is shown below.

Besides, try to check the relationship and column data.

You can also view the following documents to learn more information.

Many-to-many relationship guidance - Power BI | Microsoft Learn

Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,

Wisdom Wu

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

  • Pp110784's avatar
    Pp110784
    Icon for Helper II rankHelper II
    2 years ago

    That's what I'm doing now. It's not working. If you can let me know what might be the probable causes of the error ' The key didn't match any rows in the table.', that will help. Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Pp110784 ,

      Based on the error description, try to review the relationship. Besides, review the query process.

      You can view the following document to learn more information.

      Solved: how to resolve Power BI error - the key didn't mat... - Microsoft Fabric Community

       

      Best Regards,

      Wisdom Wu

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

      • Pp110784's avatar
        Pp110784
        Icon for Helper II rankHelper II
        2 years ago

        My problem was similar to this. Somehow the first query that I had used in my report to pull data was not working properly. It was not referencing the table with it's name, instead as 'Query1'. So I had to edit the query and pull the data again. This time I saw the table was being referenced with it's table name. Then I joined the 2nd table with it and it worked fine. Had to re do my report because of it, but at least we won't face any issues in the future because of this.