Forum Discussion
Helper ISharepoint folder connector returns blank page
Hello, everyone.
Is there any option, I should turn on or off on sharepoint site, to retrieve folder contents via "Sharepoint folder" connector.
Currently I load all files via seperate functions written manually, but it doesn't update in Power BI add-in in SSRS. I am the admin of sharepoint site where all files located, so I think it's not due to a lack of access.
Also, tried to turn on/off web view of excel files. (...?Web=1)
17 Replies
- TomMartens
Super User
Hey logantbw,
first you have to point your queries to your Excel files in the sharepoint folder.
Determine the web path of the Excel files and remove the ?web=1
Then you also have to set a refresh schedule, following the instructions of this article:
https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh
Hopefully, this provides what you are looking for.
Regards,
Tom
logantbwHello TomMartens
Targeting excel files seperatly is not an option. Data will be being added every month.
"Determine the web path of the Excel files and remove the ?web=1" - There is an option in sharepoint that removes ?web=1 from folder contents. Told about it in initial post. This didn't help
- Daviejoe
Memorable Member
Hi logantbw
I don't think TomMartens meant you would target the excel files directly, you'd point your query towards the folder where they are stored, so once you've achieved this you will pull in any new data that's added to the existing files or, if you're appending new files, they'd be appended to your data set.
Source = SharePoint.Files("https://companyname.sharepoint.com/sites/O365_FolderLocation", [ApiVersion = 15]),
#"Filtered Rows" = Table.SelectRows(Source, each ([Folder Path] = "https://companyname.sharepoint.com/sites/O365_folderlocation/Shared Documents/etc")),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Content", "Name"})So something like the above
