Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
JuanManzanera
New Member

Can't connect to a sharepoint folder

Hi Power BI community,

 

I'm trying to connect to a sharepoint folder but I got this error message:

JuanManzanera_0-1727899929253.png

I'm copying the URL from this option (in Spanish), and then removed the characters after the folder name (i.e. ?csf=1&web=......)

JuanManzanera_1-1727900004869.png

 

I need to connect and merge multiple csv files within that folder instead of connecting to each file and then manually merge these in Power Query (I can connect to each individual file btw but no to the folder).

 

Any suggestions to solve this problem?

1 ACCEPTED SOLUTION

When you look at the file list, scroll to the very right. It has a FolderPath column.

View solution in original post

6 REPLIES 6
lbendlin
Super User
Super User

I'm copying the URL from this option (in Spanish), and then removed the characters after the folder name (i.e. ?csf=1&web=......)

That is insufficient. You need to connect to the plain site URL, not to any folder .

Thanks for your comment @lbendlin. This is the URL structure that I'm copying and pasting in Power BI Desktop:

https://[company_name].sharepoint.com/:f:/r/sites/[Folder_1] /Shared%20Documents/[Folder_2]/[Folder_3]/[Folder_that_I_need_to_connect]?csf=1&web=1&e=SjeDwt

I removed the characters in bold in the URL above to connect properly to Power BI.

I entered my credentials when requested but getting the error explained in the initial comment above.

The correct site URL is

 

https://[company_name].sharepoint.com/sites/[Folder_1

Great! This worked perfectly, thanks! I do have a follow-up question. In my data model, I use multiple reports—one for sales with X files per company, another for AR with X files per company, and another for customers with X files per company. Based on this, I created three folders in SharePoint (one for Sales, one for AR, and one for Customer files), thinking I could connect to each folder and combine the files for each report. Is there a way to do this? When I connect as you suggested, all the reports appear as if they were in the same folder, as follows:

JuanManzanera_1-1727988474719.png

The reason I'm asking is that I can connect to individual folders when they're saved locally, but I'd like to know if this is possible when working in SharePoint.

Thanks!

When you look at the file list, scroll to the very right. It has a FolderPath column.

Great! This should work. Thanks!!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.