Reply
Frequent Visitor
Posts: 3
Registered: ‎04-17-2017

powwrbi can not connect (login) to sharepoint

Hi

I instaled on-premises data gateway and confige powebi and workcorrectly until last day. I restart my sharepoint and gateway server and now powebi can not connect to my sharepoint, the error is:

Unable to connect: We encountered an error while trying to connect to http://****/. Details: "Invalid connection credentials."Show details

New Contributor
Posts: 592
Registered: ‎02-28-2017

Re: powwrbi can not connect (login) to sharepoint

Is this SharePoint Online?  Our company has both SharePoint Online and an SharePoint 2013 On Premise.  I'm able to connect to the on-premise one without hassles but i get the same error trying to get connected to SharePoint Online.  I'm presently leaving it with our internal SharePoint team incase its a setting we have turned off or on thats blocking this.  I'd be curious if there is another reason.

Frequent Visitor
Posts: 3
Registered: ‎04-17-2017

Re: powwrbi can not connect (login) to sharepoint

[ Edited ]

We use sharepoint 2013, I checked excel but my excel can not connect to sharepoint. I use windows authenticate (domain\useraname) for connecting. I didn't have any peroblem until last week.

Highlighted
New Contributor
Posts: 592
Registered: ‎02-28-2017

Re: powwrbi can not connect (login) to sharepoint

Might be worth checking with your SharePoint team.  I set a 2013 one up this afternoon and it worked flawlessly.

Double check things like permissions.  What credentials is your Power BI authenticating with and does that folder/file still have access granted for that.  Remember to check your On Premise data gateway too, as it could have different credentials loaded into it.

Could be something as silly as someone doing a clean up of privileges and thinking the one you use wasn't needed anymore.

Frequent Visitor
Posts: 3
Registered: ‎04-17-2017

Re: powwrbi can not connect (login) to sharepoint

We chacked configuration but dont find any problem.

I chenge "data source file" to web and it connect to sharepoint, but the new problem is "Use a data getway" and "scheduled refresh" are off.

image.png

 

 

New Contributor
Posts: 592
Registered: ‎02-28-2017

Re: powwrbi can not connect (login) to sharepoint

This indicates to me that at least one 'data source' in your Power BI project cannot be found in your list of data sources in your gateway.