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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Krishnan_V47
Helper I
Helper I

To get all files from a sharepoint folder using Web Connector

Hi All,

 

I have access to a sharepoint folder and I am able to load all the files from the folder using 'SharePoint Folder' connector in Power BI.

 

I want to know if we can load all the files from the same folder using 'Web' connector. I know we can be able to load a single excel file, wanted to know if we can load all files from a folder. If yes, is there any link or list of steps that needs to be followed to get the files.

 

Thank you.

3 REPLIES 3
christinepayton
Super User
Super User

If the files all have the same structure, then yes, you can load them all at once using the SharePoint folder connector. Filter on the "Path" column to select only the folder you want to pull after connecting at the site level, then use the double-arrow icon in the the Content column header to expand all the files in one query. 

 

If all of the files have a different structure, then you'd have to connect to them individually. 

Can we load all the files from a folder using 'Web' connector?

It's probably technically possible, but not realistically feasible. To do that, you'd have to essentially run the same API query that the SP Folder connector is using on the back end and feed it credentials through parameters - there's no reason to go through that trouble when the SP folder connector works fine. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors