cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jmdhazard
New Member

Connection with web folder

Hi all.

 

I appreciate you can help me with the following query. I know that from Power BI Desktop you can configure a local folder as a source or data source. My question is if there is any way to connect a web folder (hosted in the cloud, Google Drive, OneDrive, Dropbox, etc.) well sea with Power BI Desktop or from the Power BI service and that as with the option of The local folder can read all the files contained in the folder.

 

Thank you

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft
Microsoft

@jmdhazard ,

To OneDrive for Business folder in Power BI Desktop, please enter the following URL in SharePoint Folder connector.

https://mydomain-my.sharepoint.com/personal/user_mydomain_com

To connect to SharePoint online folder, please enter root URL of your SharePoint site in SharePoint Folder connector of Power BI Desktop.

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

3 REPLIES 3
v-yuezhe-msft
Microsoft
Microsoft

@jmdhazard ,

To OneDrive for Business folder in Power BI Desktop, please enter the following URL in SharePoint Folder connector.

https://mydomain-my.sharepoint.com/personal/user_mydomain_com

To connect to SharePoint online folder, please enter root URL of your SharePoint site in SharePoint Folder connector of Power BI Desktop.

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

tjd
Impactful Individual
Impactful Individual

What if we don't want to use the SharePoint connector (too slow) but rather the One Drive connector (i.e., Web.Contents) to connect to a folder in order to combine files on input?

Anonymous
Not applicable

Hi Jmdhazard,

 

You can connect to Shareport folder (onedrive). If it's pesonal one drive replace "sites" with "personal"

 

https://mycompany.sharepoint.com/sites/folder

 

Sharepoint Folder setup

 

//Rasty

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Kudoed Authors