Issues while implementing BW SSO on PowerBI service

[Anonymous]

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

[v-yuta-msft]

@Anonymous ,

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.

 

Regards,

Jimmy Tao

[joel_gibby_csc]

Experiencing the same error "The given credential is missing a required property. Data source kind: SapBusinessWarehouse. Authentication kind: Windows. Property name: SNCLibrary" When connecting from a dataflow.

Datasets appear to refresh fine.