Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Issue with Refresh

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? Tha...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
    Anonymous
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi,

       

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

       

      Thanks