cancel
Showing results for 
Search instead for 
Did you mean: 

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

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
Comments
v-robertq-msft
Community Support

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