Connect to SQL Datasource using Gateway connection

[Anonymous]

Hello everyone! I'm getting the error below when trying to connect to a SQL database via Gateway in PBI Service:

I have a gateway connection, and I'm getting the error below when trying to connect to a SQL database via Dataflow in PBI Service.

"We were unable to connect to the data source using an encrypted connection. To use an unencrypted connection, uncheck "Use encrypted connection" and try again."

But there is no option "Use encrypted connection".

I'm using: Workspace > New > Dataflow > Define new tables (Add new tables) > SQL Server database.

Is there a Gateway error or an access error? I have all access needed to get this working, but I don't know what must be done to solve this error.

I appreciate any help.

[v-zhangti]

Hi, @Anonymous 

You can try to exclude the gateway error. First make sure the gateway version is up to date.

You can refer to the following document, hope it can help you.

https://docs.microsoft.com/power-bi/connect-data/service-gateway-onprem-tshoot 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @collinq,

I've checked that, but there is no option "Use encrypted connection".

I've found that option on MySQL database Dataflow, as you can see below, but I need to use SQL since I have a SQL server.

Workspace > New > Dataflow > Define new tables (Add new tables) > MySQL database.

[collinq]

Hey @Anonymous ,

What is under the advanced options drop down?  Is the Encrypted option hiding in there perhaps?