Forum Discussion
Advocate IVConnect Power BI Desktop to file folder on OneDrive for Business
Hello;
I need to connect the Power Bi desktop to a file folder in OneDrive for Business, similarly to a file folder located in the c directory of any computer, and then write the data extraction routine using the " Excel.Workbook ", for example. Has anyone had any experience like this? It's possible?
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
17 Replies
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- hugoventurini
The 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
Wow Anonymous; thanks Lydia!
This is very important to small business solutions developers. I'll try this solution now in this morning, and return to confirm. Thank you Lydia, but I have a problem with my user name. It seams that because my user name is [email protected] it does not work. We tried with other colleages who had no peroid in the user and it work...Any solution to that? Thanks again,
María
- yossifisch
Replace the period with an underscore, firstname_lastname_domain_cl
See this page for details: https://docs.microsoft.com/en-us/onedrive/list-onedrive-urls
- yossifisch
hugoventurini,
There is no built-in connector for OneDrive for business folder in Power BI, it is not possible to directly connect to the source.
To work around the issue in your scenario, you can sync the OneDrive for Business files to local folder of your computer, then use Folder connector in Power BI Desktop to get data from the local folder.
Regards,
Lydia- hugoventurini
Thanks very much for your attention. I already use this solution described, but it is not ideal because it does not allow another user to update and republish the report. Is there any prospect of having this connection in the future?
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,
Lydia
- yossifisch
Check out my updated response here: https://community.powerbi.com/t5/Integrations-with-Files-and/Need-to-load-all-Excel-files-in-a-given-OneDrive-folder/m-p/702472#M23521
This is a much faster and intuitive solution.
