Power BI
Needs VotesAllow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
Hugo Venturini on 12 Jan 2018 04:23:54
Through the ability to connect to a Sharepoint Folder, we can connect Power BI to the OneDrive for Business root folder. This is excellent and very important, but insufficient. Most projects require that files be organized in subfolders, to which direct access is not allowed. There are ways to do this, but they are not efficient. I suggest that the solution be enhanced to allow direct access to the subfolders located in the root folder of OneDrive For Business or even Personal OneDrive, just as you can with folders and their subfolders located in Drive C on the desktop or laptop. This would be very important for anyone developing solutions for small and medium-sized businesses.
- Comments (12)
RE: Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
I agree with Mr. Venturini
RE: Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
I agree with Mr. Venturini.
RE: Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
I agree with Mr. Venturini
RE: Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
I agree with Mr. Venturini
RE: Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
I agree with Mr. Venturini
RE: Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
Yes! When connecting to SharePoint sites that contain lots of data, it is incredibly slow when Power Query needs to access metadata for all those files & subfolders and then you have to filter down to the specific file you want. It would be much easier if we could directly connect to a particular subfolder or file stored on SharePoint without the intermediate navigation steps in query editor.
RE: Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
It's crazy that this is not implemented yet, not everyone has databases setup and therefor this is a clear need.
RE: Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
Completely agree with Hugo, it is relatively easy to connect to a single file on OneDrive but iterating through a folder is a basic function that should be able to do on Power BI Desktop or through the service.
RE: Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
For OneDrive for Business, you can edit the query from SharePoint.Files to SharePoint.Contents. This will allow you to navigate to a specific folder without using filters which is extremely slow.
Kudos to commenter Shawn on Excelerator BI: https://exceleratorbi.com.au/consolidate-multiple-excel-files-in-sharepoint-using-powerquery/#comment-287
RE: Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
Totally agree. It is often necessary to connect directly to a file folder on Business One Drive and not thru copies of files on your computer. Gateways are not thus required.