Allow direct access to the subfolder of the OndeDrive for Business or Personal OneDrive.
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.
It's crazy that this is not implemented yet, not everyone has databases setup and therefor this is a clear need.
Srini Viswanathan commented
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.
Yossi Fisch commented
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
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.
Tom Roberts commented
I like Raymonds comment - that would be great.
Raymond Boone commented
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.