Dataflow and Report refreshes successfully, but Dataset encounters errors.

jennifer0515 

According to research:the key not found exception is normally due to an out of sync schema, like the one on the server vs the one cached locally.

There are two solutions:

• Power BI Desktop:

Click "Refresh Preview" for each query in Query Editor, then save and republish it to Power BI Service.

• Power BI Service:

Retype all of the data source credentials in "Dataset Settings" on Power BI Service.

This is the related document, you can view this content:

https://dataap.org/blog/2020/05/04/solved-power-bi-dataset-refresh-error-the-key-didnt-match-any-rows-in-the-table/

https://community.powerbi.com/t5/Power-Query/Expression-Error-The-key-did-not-match-any-rows-in-the-table/td-p/9824

https://community.powerbi.com/t5/Service/Refresh-Error-quot-The-key-didn-t-match-any-rows-in-the-table/td-p/561172

Best Regards,

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