Dataset refresh error

eddmund95 · ‎06-20-2022

Processing error: The key didn't match any rows in the table.
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: c49dae0f-0ba9-4d9c-9c57-1f4263143ffe
Request ID: 3f3b808d-b2e4-2939-b132-a47543b5f65d
Time: 2022-06-20 07:04:44Z

Here is the error message i faced when i was trying to refresh my PBI Datasets. C

Hariharan_R · ‎06-20-2022

Hi,

There are different reasons for this error message, You need to open this file in Power BI Desktop and check the error message in Power query (Transform data). Most of the time it refers that you are adding something which is missing in the source.

Example - You are referring a sheet which may not be available.

Ref - https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-...

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin