Forum Discussion
Helper IFile & Data source location recommendation
Hello WLou
we have a similar situation in our company. You have to differenciate if the person using the report need only to watch it or if they need also to update it.
If they only need to watch it, it doesn't matter were you stored the file, as long as the people that have to refresh the data have access. If you everyone also needs to refresh it, choose the infrastructure available in your company (shared folder, sharepoint). This is more a decision of your admin because of authorizations issues for every platform.
Hope this helps
Jimmy
Not sure why .Files would work and .Contents would not. Are you using SharePoint online or is it on prem? Your URL seems to indicate online, but you only have one namespace after the .com. I have to have two - /sites/SiteName
You cannot browse at the sites level.
Other than that you might need to contact your IT department about permissions. I know they can disable SharePoint browsing in Power Query, but was unaware they could let SharePoint.Files work and block SharePoint.Contents.
Helper IThank you all for your contribtes, it defenitely clearify things
edhans one more question, https://xxxxxx.sharepoint.com/xxxxx/ is the link I use to connect, and if I add another level of folder after site it errors
and even I succeed to add another folder which narrows down the search, it still contains 50 odd subfolders after that
If I ask IT to set up a folder at higher leverl woudl it help?
Regards,
Wendy
Community ChampionWLou you don't add folders in the main URL.
- Connect to a SharePoint site folder as you normally do.
- When the connection is done and the Source line will say something like this: = SharePoint.Files("https://xxxxxx.sharepoint.com/sites/SiteName", [ApiVersion = 15])
- Change it to say this: SharePoint.Contents("https://xxxxxx.sharepoint.com/sites/SiteName", [ApiVersion = 15])
- Now you will see instead of a list of every single file and folder on the site, you'll just see top level folders.
- Click on the green "Table" link next to Shared Documents
- Now just keep clicking on the Table links next to the folders as you navigate to where this stuff is.
- Once there, filter by file or whatever, then do the Combine operation.
- WLou
Sorry to be a pain, just changed Files to Contents in query editor and its giving me "Expression.Error: Access to the resource is forbidden." does it means there a certain file that has been locked away?
FROM
let
Source = SharePoint.Files("https://xxxxxx.sharepoint.com/xxx/", [ApiVersion = 15])
in
SourceTO
let
Source = SharePoint.Contents("https://xxxxx.sharepoint.com/xxx/", [ApiVersion = 15])
in
Source- edhans
Not sure why .Files would work and .Contents would not. Are you using SharePoint online or is it on prem? Your URL seems to indicate online, but you only have one namespace after the .com. I have to have two - /sites/SiteName
You cannot browse at the sites level.
Other than that you might need to contact your IT department about permissions. I know they can disable SharePoint browsing in Power Query, but was unaware they could let SharePoint.Files work and block SharePoint.Contents.