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.
I've installed on-premise data gateway and i'm trying to add a data source with SAP Business Warehouse but I get the error details as below
The same source has been verified in power bi desktop, the only different is that a language option setting in powerbi desktop and none in data source setting in power bi web
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
Cluster URI: https://wabi-south-east-asia-redirect.analysis.windows.net
Status code: 400
Error Code: DMTS_PublishDatasourceToClusterErrorCode
Time: Tue Feb 26 2019 15:25:36 GMT+0800 (台北標準時間)
Version: 13.0.8482.125
my_laptop_win10_2: Invalid connection credentials.
Underlying error code: -2147467259
Underlying error message: The credentials provided for the SapBusinessWarehouse source are invalid. (Source at 172.20.97.66/00/100)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: SapBusinessWarehouse
Microsoft.Data.Mashup.CredentialError.DataSourcePath: 172.20.97.66/00/100
Microsoft.Data.Mashup.CredentialError.Reason: AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SapBusinessWarehouse","path":"172.20.97.66/00/100"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessUnauthorized
@Anonymous ,
Which machine do you install on-premises gateway? Are you able to access SAP data source from the gateway machine? You can install SAP client in the gateway machine to test the connection.
In addition, what is your gateway version?
Regards,
Lydia
I install the on-premise gateway on my laptop and I can access the SAP data source.
I have the SAP client, SAP Connector for Microsoft .NET 3.0 on my laptop too.
The connection between SAP BW and Power BI desktop works fine.
My on-premise gateway in version 3000.0.265
@Anonymous ,
Please export gateway log following the guide in this article.
Reagrds,
Lydia
I got the same error messages in logs,
PowerBI Desktop settings
Manage Data Gateway section in Power BI Web
Hi @Anonymous @v-yuezhe-msft were you able to resolve this one? as I have experienced the same error
thanks Ed
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.