Forum Discussion
Helper IINot able to join data from 2 tables in my report
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.
Helper IIThat'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!
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
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.