Forum Discussion
Advocate IVConnect Power BI Desktop to file folder on OneDrive for Business
hugoventurini,
There is an idea about this issue, please vote it up.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19061959-enable-connectivity-to-a-one-drive-folder
Regards,
Lydiahugoventurini,
In the latest version of Power BI Desktop(December update), please enter the following URL in SharePoint Folder connector, this way, you can connect to OneDrive for Business folder in Power BI Desktop.
https://mydomain-my.sharepoint.com/personal/user_mydomain_com
Regards,
Lydia
Advocate II think my solution is basically what you just outlined, connecting to SharePoint and expanding restrincting the folder using the Query Editor.
Advocate IVAnyway, I left a suggestion to improve this feature so that it allows us to connect directly to the subfolders. If you deem it interesting, like me, I ask you the kindness to vote:
hugoventurini Thanks very much for proposing this feature, i have voted it up Hugo. I am attempting to do to the same thing, which is to iterate through a OneDrive for Business FOLDER (and not just a single file). Is there any new/updated approach to do this now? As you mentioned, it is more difficult to edit and filter to specific files from the root , but rather there should be a way to connect directly to a folder.
- yossifisch
Anonymous As explained here, just switch SharePoint.Files to SharePoint.Contents and you'll be able to navigate to your specific folder without filtering. This solution is simple, fast and effective, it just requires you to make that minor change in the formula bar as this is not an available option in Get Data.