Power query Sharepoint delayed update

%3CLINGO-SUB%20id%3D%22lingo-sub-211558%22%20slang%3D%22en-US%22%3EPower%20query%20Sharepoint%20delayed%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-211558%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20using%20power%20query%20to%20import%20excel%20files%20via%20get%20sharepoint.%20Files%20are%20in%20individual%20libraries.%20However%20some%20excel%20files%20are%20not%20found%20by%20power%20query.%20The%20excel%20files%20are%20found%20when%20i%20go%20straight%20to%20the%20sharepoint%20website%20but%20not%20when%20i%20open%20the%20library%20through%20power%20query.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-211558%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-211651%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20Sharepoint%20delayed%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-211651%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Anthony%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20use%20root%20URL%20of%20your%20Sharepoint%20site%3F%20If%20so%2C%20it%20shall%20work%2C%20for%20SPO%20it%20looks%20like%3C%2FP%3E%0A%3CPRE%3E%3D%20SharePoint.Files(%22https%3A%2F%2Fcontoso.sharepoint.com%2Fteams%2Fmyteam%22%2C%20%5BApiVersion%20%3D%2015%5D)%3C%2FPRE%3E%0A%3CP%3E(that's%20for%20Teams%20site%2C%20but%20doesn't%20matter)%3C%2FP%3E%0A%3CP%3Eand%20as%20next%20step%20you%20shall%20filter%20on%20library%20you%20need.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527700%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20Sharepoint%20delayed%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527700%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20hope%20you%20can%20help.%3C%2FP%3E%3CP%3EI%20created%20a%20link%20to%20a%20sharepoint%20folder%20(Power%20Query)%20in%20an%20Excel%20file%20and%20everything%20works%20perfect%20the%20first%20time.%3C%2FP%3E%3CP%3EI%20then%20upload%20a%20new%20file%20to%20the%20folder%20on%20sharepoint%2C%20but%20when%20I%20then%20use%20Get%20Data-Sharepoint%20folder%20(from%20the%20same%20Excel%20file%20-%20let's%20say%20its%20a%20month%20later%20and%20I%20need%20the%20new%26nbsp%3B%20file%20imported%20into%20Power%20Query)%20%2C%20the%20folder%20list%20shows%20the%20original%20files%20and%20does%20not%20include%20the%20new%20uploaded%20file.%26nbsp%3B%20If%20I%20change%20a%20file%20name%20for%20example%2C%20it%20does%20not%20update%20either.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527752%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20Sharepoint%20delayed%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527752%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111655%22%20target%3D%22_blank%22%3E%40Chris%20Botha%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20don't%20see%20new%20files%20only%20in%20preview%20window%20as%20on%20your%20screenshot%2C%20that's%20most%20probably%20cache.%20Click%20on%20Transform%20data%20and%20Refresh.%20Or%20Load%20and%20Refresh.%20And%2For%20clear%20cache%20in%20Query%20options%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20607px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205923iD3572A496658133B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527799%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20Sharepoint%20delayed%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527799%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20thank%20you%20more%20than%20enough!!!%3C%2FP%3E%3CP%3EYou%20just%20saved%20my%20life.%26nbsp%3B%20I%20have%20been%20asking%20everywhere%20for%20the%20last%20two%20weeks%20and%20no%20one%20either%20replied%20or%20had%20an%20answer.%3C%2FP%3E%3CP%3EThank%20you%20so%20so%20much.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1530118%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20Sharepoint%20delayed%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1530118%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111655%22%20target%3D%22_blank%22%3E%40Chris%20Botha%3C%2FA%3E%26nbsp%3B%2C%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

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 go straight to the sharepoint website but not when i open the library through power query.

9 Replies

Hi Anthony,

 

Do you use root URL of your Sharepoint site? If so, it shall work, for SPO it looks like

= SharePoint.Files("https://contoso.sharepoint.com/teams/myteam", [ApiVersion = 15])

(that's for Teams site, but doesn't matter)

and as next step you shall filter on library you need.

 

@Sergei Baklan 

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.

@Chris Botha 

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

image.png

 

@Sergei Baklan 

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

@Sergei Baklan  @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

@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?

Thanks for the quick reply @Sergei Baklan. 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.

 

hcbreakey93_0-1612913518079.png

 

@hcbreakey93 

Thank you. And what is another condition after the and? Perhaps you may share entire formula.

image.png