Forum Discussion
Power query Sharepoint delayed update
I really hope you can help.
I created a link to a sharepoint folder (Power Query) in an Excel file and everything works perfect the first time.
I then upload a new file to the folder on sharepoint, but when I then use Get Data-Sharepoint folder (from the same Excel file - let's say its a month later and I need the new file imported into Power Query) , the folder list shows the original files and does not include the new uploaded file. If I change a file name for example, it does not update either.
If you don't see new files only in preview window as on your screenshot, that's most probably cache. Click on Transform data and Refresh. Or Load and Refresh. And/or clear cache in Query options
- Thank you so much. Solved!
Carlos_Marino How did you resolve??
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.
Chris Botha , glad to help
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
