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? Thanks.

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.

4 Replies

  • 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.