cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Connect 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?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Connect 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...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Connect Power BI Desktop to file folder on OneDrive for Business

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

13 REPLIES 13
Highlighted
Microsoft
Microsoft

Re: Connect Power BI Desktop to file folder on OneDrive for Business

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate I
Advocate I

Re: Connect Power BI Desktop to file folder on OneDrive for Business

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?

Highlighted
Microsoft
Microsoft

Re: Connect 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...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Connect Power BI Desktop to file folder on OneDrive for Business

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Advocate I
Advocate I

Re: Connect Power BI Desktop to file folder on OneDrive for Business

Wow @v-yuezhe-msft; thanks Lydia!

This is very important to small business solutions developers. I'll try this solution now in this morning, and return to confirm.

 

 

Highlighted
Advocate I
Advocate I

Re: Connect Power BI Desktop to file folder on OneDrive for Business

Highlighted
Advocate I
Advocate I

Re: Connect Power BI Desktop to file folder on OneDrive for Business

The solution proposed by @v-yuezhe-msft 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!

Highlighted
Advocate I
Advocate I

Re: Connect Power BI Desktop to file folder on OneDrive for Business

I think my solution is basically what you just outlined, connecting to SharePoint and expanding restrincting the folder using the Query Editor.

Highlighted
Advocate I
Advocate I

Re: Connect Power BI Desktop to file folder on OneDrive for Business

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: 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32923258-allow-direct-access-to-t...

Thank you!

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors