Forum Discussion

murugesh0035's avatar
murugesh0035
New Member
8 years ago

On Premise Data Source Connectivity Issue between SharePoint ( MFA ) to Power BI

My SharePoint site enabled ADFS authentication , we can say Multi Factor Authentication enabled site. the problem now we successfully connected On Premise gateway but when we are trying to add Data Source we are getting the below error message. Please help me on this issue if anyone knows about it. thanks. 

 

Unable to connect: We encountered an error while trying to connect to https://testsite.ae/. Details: "We could not register this data source for all gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Activity ID:487fa066-1d5d-46e2-82a9-0d3b95128f2c
Request ID:825dba67-823d-3055-3370-b21cd757fcc5
Cluster URI:https://wabi-north-europe-redirect.analysis.windows.net
Status code:400
Error Code:DMTS_PublishDatasourceToClusterErrorCode
Time:Wed Feb 07 2018 09:30:35 GMT+0400 (Arabian Standard Time)
Version:13.0.4294.135
powerbi:Invalid connection credentials.
Underlying error code:-2147467259
Underlying error message:The credentials provided for the SharePoint source are invalid. (Source at https://testsite.ae)
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:SharePoint
Microsoft.Data.Mashup.CredentialError.DataSourcePath:https://testsite.ae
Microsoft.Data.Mashup.CredentialError.Reason:AccessForbidden
Microsoft.Data.Mashup.MashupSecurityException.DataSources:[{"kind":"SharePoint","path":"https://testsite.ae"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:AccessForbidden

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    murugesh0035,

    What authentication type do you use to connect to on-premises SharePoint, Windows or OAuth authentication? And are you able to access SharePoint site on the machine that installing gateway?

    Regards,

    Lydia