Getting error when refreshing data.

[cpate03]

Good afternoon, 

I was hoping someone may be able to help me. I keep getting the following error when I attempt to refresh my dataset. The data is the exact same as what is in my PowerBI report. I save the new data to the same file, but when I attempt to refresh the data to update my charts/graphs the error occurs and I don't know how to fix it. Can you help? Below is the error I keep getting. 

Thanks in advance for any help! 

[Anonymous · Accepted solution]

Thanks for the reply from PijushRoy , please allow me to provide another insight: 
Hi  @cpate03 ,

You can try the following actions:

Go into the data source setting and clear all permissions - then recapture them.

Solved: The key didn't match any rows in the table - SQL D... - Microsoft Fabric Community

This is a link similar to the error message and the problem is solved in Power Query by following the steps below:

1. Select Edit Queries from the menu to open the Query Editor
2. Use the left hand menu to select one of the queries having the issue (will have the triangular warning sign)
3. On the applied steps menu at the right select the source step.
4. In the top menu bar, select Refresh Preview.

Solved: Expression.Error: The key did not match any rows i... - Microsoft Fabric Community

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

Power Query error 'The key didn't match any rows in the table.' when combining | Microsoft Community...

Solved: Expression Error.: The key didn't match any rows i... - Microsoft Fabric Community

excel - how to resolve Power BI error - the key didn't match any rows in the table - Stack Overflow

Best Regards,

Liu Yang

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

[PijushRoy]

Hi @cpate03 

Please check data model and relationship
There may be one or more table in the data model, but there is no data.
Download the PBIX file from service and check all tables