Interesting SSL error

[TylerFCG]

Hi community,

@JamesDrydenFCG and myself have come across an error when querying data from databricks Azure using SQL queries.

The context is we are building a dashboard which replicates an inhouse feature known as lakehouse moitoring from databricks and we are querying 2 tables within databricks. The dashboard runs fine on my powerbi desktop, however when we connect to our VPN gateway we get an error, which is posted below. Its important to note this does not seem to be an infrastructre issue as we can see all the SQL queries are being run in the databricks SQL query log. We are building custom queries which are being "Imported" around these two tables and so some SQL query results are larger than others. The reason I bring this up is, when I query two SQL queries which are small in size, there is no error, however when I query a 3rd SQl query which brings a larger amount of data fromdatabricks as a table into powerbi dashboard I get the following error.

The 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":"ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: '[Microsoft][Hardy] (134) File da6f5760-d75e-4dde-b435-af87c40d430d: A retriable error occurred while attempting to download a result file from the cloud store but the retry limit had been exceeded. Error Detail: File da6f5760-d75e-4dde-b435-af87c40d430d: An error had occurred while attempting to download the result file.The error is: [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2.. Since the connection has been configured to consider all result file download as retriable errors, we will attempt to retry the download.'.", "code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":"type":1,"value":"-2147467259", "code":"Microsoft.Data.Mashup.ErrorCode","detail":"type":1,"value":null, "code":"Microsoft.Data.Mashup.ValueError.Reason","detail":"type":1,"value":"DataSource.Error"],"exceptionCulprit":1 Table: categorical_profile_over_time.

I have played around with the different queries and when I bring in a 3rd table which is small the VPN gatewat refreshes correctly, when I change that back to a larger table I get the error above.

Any help is greatly appreciated.

[v-csrikanth · Accepted solution]

Hi @TylerFCG 
Thank you for being part of the Microsoft Fabric Community.
The message indicates that SSL cannot be enabled when connecting to a server that does not have SSL enabled. If the server has SSL enabled, ensure that the minimum required SSL protocol (TLS 1.2 or later) is correctly configured.
Enable/Check SSL Configuration:
Make sure that SSL is enabled on your Databricks cluster.

• If it is disabled, try modifying your Power BI connection settings:
  • Go to Data source settings in Power BI.
  • Check Encryption settings and match them with Databricks requirements.
  • Try explicitly disabling SSL in the connection string if necessary.

Use DirectQuery Instead of Import Mode

• Since Import Mode pulls large result sets into Power BI, switching to DirectQuery can reduce the load by querying Databricks on demand.
  • In Power BI, go to Transform Data → Change data source mode to DirectQuery.

If the above information helps you, please give us a Kudos and marked the reply Accept as a Solution.

Thanks,
Cheri Srikanth

[v-csrikanth]

Hi @TylerFCG 
As i wantes to follow up on last response and just wanted to check whether the solution provided has worked for you.If yes, please accept as solution to help others benefit.

Thanks 
Cheri Srikanth

[v-csrikanth]

Hi @TylerFCG 
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

[Poojara_D12 · Accepted solution]

Hi @TylerFCG 

The error you are encountering in Power BI when connecting through a VPN gateway to Databricks appears to be related to data size, query execution time, and SSL/TLS configuration. Since smaller queries work fine while larger ones fail, it suggests that Power BI is struggling to handle the retrieval of large datasets from Databricks. The error message indicates that Power BI encounters a retriable error while attempting to download result files from Databricks' cloud store, and after multiple retries, it fails. This could be due to timeout limits, network constraints, or gateway processing limitations. Additionally, the error mentions an SSL/TLS mismatch, meaning that either the VPN gateway, Power BI, or Databricks may not be aligned on the required security protocols (TLS 1.2 or higher). To resolve this, you can try optimizing your queries to reduce the data size being imported, increasing timeout settings in Power BI and Databricks, verifying SSL/TLS configurations, and checking Databricks' query logs for failures. Another potential solution is switching from Import mode to DirectQuery mode, as this would allow Power BI to query Databricks dynamically without loading large datasets into memory. Lastly, testing outside the VPN may help determine if the issue is related to the network configuration rather than Power BI or Databricks itself.

[v-csrikanth · Accepted solution]

Hi @TylerFCG 
Thank you for being part of the Microsoft Fabric Community.
The message indicates that SSL cannot be enabled when connecting to a server that does not have SSL enabled. If the server has SSL enabled, ensure that the minimum required SSL protocol (TLS 1.2 or later) is correctly configured.
Enable/Check SSL Configuration:
Make sure that SSL is enabled on your Databricks cluster.

• If it is disabled, try modifying your Power BI connection settings:
  • Go to Data source settings in Power BI.
  • Check Encryption settings and match them with Databricks requirements.
  • Try explicitly disabling SSL in the connection string if necessary.

Use DirectQuery Instead of Import Mode

• Since Import Mode pulls large result sets into Power BI, switching to DirectQuery can reduce the load by querying Databricks on demand.
  • In Power BI, go to Transform Data → Change data source mode to DirectQuery.

If the above information helps you, please give us a Kudos and marked the reply Accept as a Solution.

Thanks,
Cheri Srikanth

[v-csrikanth]

Hi @TylerFCG 
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.

Thank you, 
Cheri Srikanth.

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .