Forum Discussion

Deleted's avatar
Deleted
Jul 03, 2018

Power query Sharepoint delayed update

I am currently using power query to import excel files via get sharepoint. Files are in individual libraries. However some excel files are not found by power query. The excel files are found when i g...
BI & Data Analytics
Need Help
Chris Botha's avatar
Chris Botha
Copper Contributor
Jul 16, 2020

SergeiBaklan 

I cannot thank you more than enough!!!

You just saved my life.  I have been asking everywhere for the last two weeks and no one either replied or had an answer.

Thank you so so much.

 

  • hcbreakey93's avatar
    hcbreakey93
    Copper Contributor
    Feb 09, 2021

    SergeiBaklan  Chris Botha  - I am having the exact same issue but unfortunately clearing the cache has not worked. Similarly I have tried clearing all permissions in the data source settings and re-setting them up. Any other ideas on how to resolve this?

     

    Thanks

    Hugo

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Feb 09, 2021

      hcbreakey93 

      It was at least two issues discussed - access to libraries and refresh of library content after long period of inactivity. Which one is yours?

      • hcbreakey93's avatar
        hcbreakey93
        Copper Contributor
        Feb 09, 2021

        Thanks for the quick reply SergeiBaklan. The issue I'm having is that even after refreshing the queries, clearing the cache and refreshing the permissions to the sharepoint site, the query is not recognising the new files that have been loaded into the sharepoint folder.

         

        Please see attached screenshot.

         

         

Resources