Issue with Refresh

[Anonymous]

Hi All,

I am looking for some help with error: 'The key didn't match any rows in the table' while refreshing a dataset. I also don't see the Refresh Preview Button. Can someone advise please? Thanks.

[Anonymous · Accepted solution]

@Anonymous You're probably getting this error because your Power Query query is trying to connect to a table or worksheet or something in your data source that has been deleted or been renamed.

Also, Refresh Preview button is available in Power Query only.

[Anonymous · Accepted solution]

@Anonymous You're probably getting this error because your Power Query query is trying to connect to a table or worksheet or something in your data source that has been deleted or been renamed.

Also, Refresh Preview button is available in Power Query only.

[Anonymous]

Thanks for the response Nikhil.

You are right. I chose an incorrect path before the refresh and am unable to get that pop-up to select the path now. Could you let me know how I can get that again to get this working?

Thanks again!

[Anonymous · Accepted solution]

@Anonymous In power query, go to source, in the applied steps sections which is in the right and from there you can change the path.

[Anonymous]

Hi,

I continue to get this error even though the path is correct. What could be causing this?

Thanks