Hi,
Hoping someone can help me with a problem. I have a dashboard that connects to a remote database (we have no control over this database/server, we can only access the data). I had some issues refreshing the data on my laptop where I was getting an error about the certificate being untrusted, but got around this by adding PBI_SQL_TRUSTED_SERVERS: database_address to my accounts environment variables (I did not add them to my computers system environment variables).
However, when I try to refresh the semantic model online, I get the below error.
Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10478"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"20"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"reigategrammardb.isamshosting.cloud, 29347;iSAMS_ReigateGrammar"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)"}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2146893019"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.State","detail":{"type":1,"value":"0"}}],"exceptionCulprit":1}}} Table: Staff.
Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID fa5a13f1-d2c6-49f7-872a-99bfa96991b1
Request ID e0ea06cd-6d4f-518a-cb48-180448960167
Time 2024-11-19 11:16:08Z
How can I stop this from happening? Do I need to add the PBI_SQL_TRUSTED_SERVERS: database_address to my system variables?
