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 (6)
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.
RE: Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
I like Raymonds comment - that would be great.
RE: Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
It would be nice if it just worked like the Power BI service so your OneDrive Business and Personal drives could be selected as a source for the file.