Refresh Error: The key didn't match any rows in the table.

[Sarahdb425]

I've recently received a ton of the following refresh errors "The key didn't match any rows in the table."

When I open the report in the desktop app, it refreshes just fine. I've republished the report to the workspace, recieving confirmation that it went through, but then still receive the refresh error in the web app and the autonotifications. Any thoughts on what might be causing this?

Thank you

[v-robertq-msft · Accepted solution]

Hi, @Sarahdb425 

Have you done some transforming column operations in the Power query like Piovit/Unpiovit columns? Because I also experienced this kind of error when I did some Piovit/Unpiovit column operations in the Power query and published the report to service to refresh the data.

For more detail, you can refer to this isse case:

https://community.powerbi.com/t5/Issues/Refresh-error-in-Power-BI-Service-for-pivoted-table/idi-p/17...

Best Regards,

Community Support Team _Robert Qin

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

[PhilipTreacy]

Hi @Sarahdb425 

Where's the data source?  Is the service accessing it via a gateway?

Check these for possible causes of your issue

https://community.powerbi.com/t5/Service/On-premises-gateway-refresh-The-key-didn-t-match-any-rows-i...

https://community.powerbi.com/t5/Desktop/Gateway-refresh-error-The-key-didn-t-match-any-rows-in-the-...

Regards

Phil

[Sarahdb425]

Thanks, @PhilipTreacy There is no gateway because all of the data sources are in the cloud. 

[Sarahdb425]

This is the screenshot of the error. 

but I am able to refresh and republish via desktop app no problem.  

But if i push a manual refresh via the web app, i get the error again. I don't get it.