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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Syndicate_Admin
Administrator
Administrator

Excel power query can connect to share point file, but not to share point folder

Hello all,

 

I want to use power query with a share point folder, to transform multiple files into one data source.

Unfortunately, I am not able to "authenticate" to the folder, but to a single file.

I googled my butt off, but all tips with connections don't change anything and since I can access one of the files in said folder, I assume it doesn't have anything to do with the actual authentication?!

What I am trying:

 

1. get share point url in web browser via info "copy path"

2. open workbook in excel desktop app

3. go to: data > get & transform data > from web > past share point path

 

From here on I am stuck. I am getting always the same error message regardless the authentication method:

“We couldn’t authenticate with the credentials provided. Please try again.”

Same credentials work if I use the path directly to one of the files within that folder.

So please tell me what I am doing wrong.

 

Thanks in advance!

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

Thank you. 

Unfortunately, I do not have the share point option within the get data menu.

Quick google search told me that I am on a 365 business subscription, but the menu is only available with enterprise. Is there any other way to connect to the folder? As I mention, I was able to use from web to connect to a single file in that share point folder without issues.

 

@Syndicate_Admin  This solution is for power bi data connectivity. Thank You!!

Mahesh0016
Super User
Super User

@Syndicate_Admin  Please Refer Below Link 
https://youtu.be/-XE7HEZbQiY 

@Syndicate_Admin  I hope this helps you!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors
Top Kudoed Authors