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.
After updating the Enterprise Gateway to latest version June Release 2 we are unable to connect to our SAP BW from PBI Service via Gateway to SAP BW. We can use desktop version on the gateway server to connect to SAP BW but when trying to set the data source up on PBI service we get below error. Other sources like SQL Server, Hana DB etc is working fine. THe credntials are correct and issue happens for different users.
PBI-Gateway-v2: | Invalid connection credentials. |
Underlying error code: | -2147467259 |
Underlying error message: | The credentials provided for the SapBusinessWarehouse source are invalid. (Source at ##########.) |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.CredentialError.DataSourceKind: | SapBusinessWarehouse |
Microsoft.Data.Mashup.CredentialError.DataSourcePath: | ######### |
Microsoft.Data.Mashup.CredentialError.Reason: | AccessUnauthorized |
Microsoft.Data.Mashup.MashupSecurityException.DataSources: | [{"kind":"SapBusinessWarehouse","path":"########"}] |
Microsoft.Data.Mashup.MashupSecurityException.Reason: | AccessUnauthorized |
Solved! Go to Solution.
Hi, this can be closed as I commented on a post with a similar problem and already received the fix for this.
Tick the box for skip connection test... thats it.
Hi, this can be closed as I commented on a post with a similar problem and already received the fix for this.
Tick the box for skip connection test... thats it.
Hi @Anonymous ,
Thanks for your kindly sharing. Others facing similar problem might benefit a lot from your sharing resolution.
Best regards,
Yuliana Gu
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.