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 Greg
Not sure if its worth getting for only few files to be shared?
The reason of having excel files is the drill down function of the pivot table, where PBI can only down to certain level
I'm planning to have majority of the reports done via PBI and distribute to the wider audiance so I guess no need to worry where to store the data?
Regards,
Wendy
Community ChampionHello 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