Dataflow refresh error

[Anonymous]

Dataflow fails to refresh with following error:

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.).

We have an on-prem Sql Server with the Gateway. We experienced same issue with the Power BI Desktop and Gateway but where able to address them using the workarounds found online (https://learn.microsoft.com/en-us/power-query/connectors/sql-server#limitations)

Unfortuantely, I couldn't find any workaround for the dataflows.

[Anonymous]

Hi @Anonymous ,

Thanks to @lbendlin  for your guidance.

The link document provide the steps for the error.

If the documentation is helpful, you can accept it as a solution to help the other members find it more quickly.

Best Regards,

Wisdom Wu

[lbendlin]

You need to install a relatively recent gateway (210.14 or newer) and then configure it to skip the certificate check.

[Anonymous]

How should we configure it? I would appreciate some kind of simple guide.

[lbendlin · Accepted solution]

Power Query SQL Server connector - Power Query | Microsoft Learn