Reply
afaro
Helper III
Helper III

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? 

1 ACCEPTED SOLUTION
v-xingshen-msft
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
v-xingshen-msft
Community Support
Community Support

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.

The reason was the workspace access is necessary to see workflow data imported into excel. Just having access to the excel isn't enough.

GilbertQ
Super User
Super User

Hi @afaro 

 

Can you please send more information with regards to the error to help us try and fix your issue?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)