- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Expression Error: The key didn't match any rows in the table
I am pulling data from Power BI dataflow into excel spread sheet and doing some minor power query operations. Some people are getting this error when they try to access the excel spreadsheet containing data from dataflow. How do I fix this?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ALL,
Firstly GilbertQ thank you for your solution!
And @afaro ,After such a long period of time, has the problem you are experiencing been resolved, if you are experiencing errors like The key didn't match any rows in the table, it could be attributed to the following:
1. Missing or mismatched key values:
If you use a column as a join key in a Power Query (for example, when merging between tables), but some of the values in that column don't exist or don't have matching rows in the target table.
If you encounter this problem you can check to make sure that all referenced columns (such as the key column used for the join) have matching values in all the related tables.
2. Inconsistent data in the source table:
If you extract data from a Power BI data stream and some rows or columns of that data stream do not load properly as expected (for example, some columns or data are missing).
3. Inconsistent data types:
If the data type of a column does not match what is expected (for example, a column was originally of numeric type, but some of the rows in this column become text type)
You can rule out one by one according to your actual situation. I hope my suggestions will help you with your problem!
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ALL,
Firstly GilbertQ thank you for your solution!
And @afaro ,After such a long period of time, has the problem you are experiencing been resolved, if you are experiencing errors like The key didn't match any rows in the table, it could be attributed to the following:
1. Missing or mismatched key values:
If you use a column as a join key in a Power Query (for example, when merging between tables), but some of the values in that column don't exist or don't have matching rows in the target table.
If you encounter this problem you can check to make sure that all referenced columns (such as the key column used for the join) have matching values in all the related tables.
2. Inconsistent data in the source table:
If you extract data from a Power BI data stream and some rows or columns of that data stream do not load properly as expected (for example, some columns or data are missing).
3. Inconsistent data types:
If the data type of a column does not match what is expected (for example, a column was originally of numeric type, but some of the rows in this column become text type)
You can rule out one by one according to your actual situation. I hope my suggestions will help you with your problem!
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The reason was the workspace access is necessary to see workflow data imported into excel. Just having access to the excel isn't enough.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @afaro
Can you please send more information with regards to the error to help us try and fix your issue?

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Join our Community Sticker Challenge 2025
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

User | Count |
---|---|
49 | |
27 | |
20 | |
19 | |
18 |
User | Count |
---|---|
52 | |
50 | |
25 | |
24 | |
22 |