cancel
Showing results for 
Search instead for 
Did you mean: 

Issues while implementing BW SSO on PowerBI service

Hi Team,

 

We have implemented SSO from BW message server to PowerBI in which our PowerBI desktop is working fine but problem occurs when we publish the report to PowerBI service. When opening report it give error " Data source connection failed". 

 

Initially we have created connections under gateway with "Skip test" option checked and defining SNC partner name string. Connections created successfully but not working for reports. Once we uncheck this option and then try, it gives below error:

 

Unable to connect: We encountered an error while trying to connect to . Details: ""Hide details

Activity ID:abce0a4f-a547-4437-bf87-1cd2d71654f0
Request ID:6b530cbc-0261-613c-e801-3c3e2295a8a6
Cluster URI:https://wabi-north-europe-f-primary-redirect.analysis.windows.net/
Status code:400
Error Code:DMTS_UpdateClusterDatasourceCredentialsErrorCode
Time:Wed Sep 23 2020 09:24:59 GMT+0200 (Romance Daylight Time)
Service version:13.0.14296.74
Client version:2009.1.02987-train
PowerBI_SSOTest:Unable to connect to the data source undefined.
Underlying error code:-2147467259
Underlying error message:The given credential is missing a required property. Data source kind: SapBusinessWarehouse. Authentication kind: Windows. Property name: SNCLibrary
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259

 

 

 

We have defined SAPCRYPTOLIB libraries in environment variable. Could you please help us in checking what went wrong

 

Thanks in advance.

Regards,

Akanksha

Status: New
Comments
Community Support

@AAkanksha ,

 

Have you checked the credentials and make sure power bi desktop has been updated to the latest version? If everything is ok, I would suggest you create a support ticket here for further analysis.

Support Ticket.gif 

Regards,

Jimmy Tao