The Key didn’t match any rows in the table – PowerBI

By | May 12, 2019

When you get the below error it usually has nothing to do with primary keys or rows. In fact the majority of the time it is because you used a excel sheet as the source for PowerBI and then changes the name of the Query within the PowerQuery window. Normally the Name of the Query and the sheet are the same. However after the names have been changed the mismatch results in a failure to apply the changes when exiting from PowerQuery.

Solution is to make sure the Sheet Names are already correct when using the Excel sheet as the source. Or to Disable Load if you already have some data within PowerBI.

    

Category: Databases

About admin

This post was written by Jayanth Kurup. A Microsoft SQL Server Consultant and Trainer based out of Bangalore, India. Jayanth has been working on MS SQL Server for over 15 years. He is a performance tuning and Business Intelligence expert. Having worked with companies like Microsoft, DELL, Wells Fargo, Thomson Reuters and many other fortune 100 companies. Some other technologies Jayanth works on include Microsoft Azure, PowerBI, Python and AWS. When he isn’t consulting or training, Jayanth like to travel, paint and read. He is also very active in social causes and the founder of Enabled Business Solutions. Visit his company by clicking the link in the menu or email him directly.