Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Power BI Dataset Refresh Error – The key didn’t match any rows in the table

Hello, I just encountered this error while trying Dataflows for the first time and this blog post is the only resource that helped me.


[Solved] Power BI Dataset Refresh Error – The key didn’t match any rows in the table | Data Awarenes...


The refresh worked in the desktop but always returned an error in the service: "The key didn’t match any rows in the table."


There are many posts in the community that talk about Excel files regarding this error and the solutions doesn't work for our case.

The solution that helped was to re-enter the datasource credentials , this way the Report/Dataset refreshes without error.


Leaving this post here so it appears if somebody searches in the community.


Community Support
Community Support

Hi, @PabloVR 


This error occurs when there is a duplicate data in the table. To resolve the issue, remove the duplicated data[1]. If you are unable to find the duplicated data, you can try filtering the table for the value in the field mentioned in the error message. Another option would be to look into the datasource directly for the duplicated data in the primary key field.


For reference:

Solved: Salesforce dataset won't refresh - key didn't matc... - Microsoft Fabric Community

Solved: Scheduled update not working - Microsoft Fabric Community


Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors