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
hugoventurini,
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 IVThe solution proposed by Anonymous works, however with a serious caveat: you can only connect to the root folder of OneDrive, not to subfolders, which would be the correct and ideal. To restrict the query it is necessary to open the Query Editor and filter through the column that shows the path to the subfolder, which is what works, however, is inefficient. The ideal solution would be to allow connection to one or more subfolders within the OneDrive root folder, depending on the context of the project you are working on. Even so I am very happy, because it represents a breakthrough. I'll point it out as solved, but making clear here the need for an enhancement that allows access to subfolders. I will also test the solution proposed by yossifisch, whom I also thank for the help.
You're all amazing, thank you!
yossifischAdvocate I
I think my solution is basically what you just outlined, connecting to SharePoint and expanding restrincting the folder using the Query Editor.
- hugoventurini
Anyway, 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.