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

[Bhartman30]

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. 

[v-juanli-msft]

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.

https://community.powerbi.com/t5/Integrations-with-Files-and/Expression-Error-The-key-did-not-match-...

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

Best Regards

maggie