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
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
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.

Top Solution Authors