04-17-2017 02:14 PM
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
|Time:||Tue Apr 18 2017 00:44:14|
|Underlying error code:||-2147467259|
|Underlying error message:||The credentials provided for the SharePoint source are invalid. (Source at http://****/.)|
04-17-2017 10:15 PM
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.
04-18-2017 10:01 PM - edited 04-18-2017 10:11 PM
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.
04-18-2017 10:21 PM
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.
04-19-2017 01:56 AM
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.