cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pgk Regular Visitor
Regular Visitor

Issues connecting to sharepoint - Power BI and Excel

Hi,

 

Hoping to get some help with an issue I am facing. I am trying to connect to a sharepoint site through Power Query in excel as I need a conslidated dataset in Excel format. However, I get a message saying "We couldn't authenticate with the credentials provided. Please try again". This is even after I have entered by credentials when prompted

 

When I try the same link through Power BI desktop, I have no problems at all - everything seems to be working fine. Thinking it could be something to do with access limitations for the sharepoint site, I tested connecting to another site through Excel and didn't have any problems with it

 

What could be the problem here? Hoping to get some input from the community if anyone else has faced similar issues

 

Thank you

 

 

9 REPLIES 9
Ross73312 Super Contributor
Super Contributor

Re: Issues connecting to sharepoint - Power BI and Excel

When you entered the credentials, did you have the option to pick what level of SharePoint these credentials were being applied to?  A common thing i've noticed is something the UI tries to apply the credentials to the base level of SharePoint, rather down at the site level.  Naturally you are going to have security access to your site, but unlikely to have the correct access for the full SharePoint.

 

The box i'm talking about will be at the bottom, as a drop down.  When you select it you'll see options like:

 

Try selecting the right level in here and see if that works


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


pgk Regular Visitor
Regular Visitor

Re: Issues connecting to sharepoint - Power BI and Excel

@Ross73312

 

I entered the credentials as prompted but it didn't ask for any privacy levels. This is a an organisational sharepoint site and I used my work login. I did check the privacy levels as well

 

And yes, I did check all the possible privacy levels that were listed. My issue is, when I try the same steps from the query editor in Power BI, it work perfectly. I haven't had issues connecting to my company's sharepoint site in the past

Ross73312 Super Contributor
Super Contributor

Re: Issues connecting to sharepoint - Power BI and Excel

So when you signed in, did you do so from "Organisational Account"?  Did it look like this screen?

 

Capture.PNG 

 

The drop down i'm refrerring to is the one labeled "Select which level to apply these settings to"


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


pgk Regular Visitor
Regular Visitor

Re: Issues connecting to sharepoint - Power BI and Excel

Yes, thats what I did. And I tried all the different levels and still nothing. Could it be something to do with access restrictions to the site? If so, it works when I try it in Power BI

Ross73312 Super Contributor
Super Contributor

Re: Issues connecting to sharepoint - Power BI and Excel

I honestly have no idea.  The fact it works in Power BI made me think that perhaps the steps followed in both programs had differed slightly and that was causing your problem.  SharePoint, in my experience, is tricky to get working and there are many paths you can take to get the data, but not all of them work.  I know in the past i've connected to SharePoint and had something working, only to later do it again for another project and have it fail.  I could have sworn I followed the same steps but when i looked at the generated Power Query code, it looked completely different.

 

I've not used Excel Power Query as much as I have Power BI, so it is entirelly possible its a quirk with that particular program that I'm simply not experienced enough with to have tripped over and had to solve.  Perhaps the Power Query code comparision might hint at some differences to check.  Perhaps Excel is using a different API number or something minor that is enough for SharePoint to block one but accept the other.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


pgk Regular Visitor
Regular Visitor

Re: Issues connecting to sharepoint - Power BI and Excel

hmm, this is weird. The weird thing is that a second sharepoint site loads perfectly in Excel Power query

 

I'll try it from my home machine and see if I get the same problem. Thanks for your help anyways Ross

 

 

Michal Frequent Visitor
Frequent Visitor

Re: Issues connecting to sharepoint - Power BI and Excel

I have similar problem and I do not have a clue what else I should do ... Please help

there is error message that it’s not possible to authenticate with my credentials…

Pic. 1: I need to sign in

Pic. 2: I’m already signed in

Pic. 3: I need to choose the level to which are the settings supposed to be applied

Pic. 4: And then the error message


1.PNGPic 12.PNGPic 23.PNGPic 34.PNGPic 4

alexrobe Frequent Visitor
Frequent Visitor

Re: Issues connecting to sharepoint - Power BI and Excel

Hi Michal!

Have you already found a solution for your issue? I'd be glad to hear it, as I am currently in a similar situation where i cannot authenticate and get stuck on a blank https://preview.powerbi.com/views/oauthredirect.html?code=AQABAAIAAACEfexXxjam  etc. page...

Thanks!

tyl Frequent Visitor
Frequent Visitor

Re: Issues connecting to sharepoint - Power BI and Excel

Hi Michal,

 

Did you managed to resolve the error in the end? I'm encountering the same error now and still no idea what to do.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 58 members 1,229 guests
Please welcome our newest community members: