Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Activity ID: | eb54ed56-3c24-4470-845b-fdf3801923c8 |
Request ID: | cac039b3-4480-e99f-1504-c3131f2772ed |
Cluster URI: | https://wabi-south-east-asia-redirect.analysis.windows.net |
Status code: | 400 |
Error Code: | DM_GWPipeline_Gateway_InvalidConnectionCredentials |
Time: | Tue Apr 18 2017 00:44:14 |
Version: | 13.0.1700.1783 |
Underlying error code: | -2147467259 |
Underlying error message: | The credentials provided for the SharePoint source are invalid. (Source at http://****/.) |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.CredentialError.DataSourceKind: | SharePoint |
Microsoft.Data.Mashup.CredentialError.DataSourcePath: | http://****/ |
Microsoft.Data.Mashup.CredentialError.Reason: | AccessUnauthorized |
Microsoft.Data.Mashup.MashupSecurityException.DataSources: | [{"kind":"SharePoint","path":"http://****/"}] |
Microsoft.Data.Mashup.MashupSecurityException.Reason: | AccessUnauthorized |
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.
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.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.