Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Every Table and Linked Entity in Data Flow Showing "The Key didn't match any rows in the table"

Submitted by Anonymous on ‎09-14-2021 02:01 PM

I work in a Dev, Test, Prod environment within Power BI. I have the same dataflows in my dev, test, and prod environment. I also have them split into ingest and transform data flows. All of my ingest dataflows are loading fine and my transform dev and test dataflows are working fine. 

 

However, every single Linked Entity and table in my Prod Transform Dataflow has a "The key didn't match any rows in the table" error. I have 39 errors. 

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-robertq-msft
Community Support
Community Support
‎09-14-2021 07:32 PM

Hi,

As far as I’m concerned, this kind of error message is often related to the table name change in the data source, you can try to go to the Power Query editor online to find the query with error and open the Advanced editor to change the table name to be the same with the table name in the data source.

 

Best Regards,

Community Support Team _Robert Qin

Idea Statuses