Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Refresh Error - "The key didn't match any rows in the table"

We received this error starting around 2:30 pm ET today when the datasets refreshed in the service: "The key didn't match any rows in the table".


The datasets refresh successfully in the desktop but not in the service. This may be a coincidence, but it also was the same time I added my first Dataflow. 

Community Support
Community Support

Hi @Bhartman30

it also was the same time I added my first Dataflow

what is your dataflow?

The error message told that the key didn't match any rows in the table,I afraid that there is something wrong in your flow's configuration.

Please check your flow to see if you have some configuration wrong in the flow


Additionally, there is a similar thread disscussing about this issue and many users get their issues sloved with the help of it.

Please read and  check for your scenario.


If you have any question, please don't hesitate to ask me.


Best Regards


Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.


Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors