Problem

Microsoft Power BI reports the following error.

We encountered an error while trying to connect. Details: Teradata: [.NET Provider for Teradata] [115027] Session initialization error: unable to execute HELP SESSION.

The Hyper-Q error log (error_log-DATE_TIME.csv) records an event similar to the following message.

"2022-11-09 09:26:29.299","<0.3860.4>","149","","0","gen_fsm","612","DTM1018","ERROR","State machine <0.3860.4> terminating. Reason: {sds_event,""DTM3032"",{sds_msg,3032,sds_msg_sev_fatal,""Data encryption not supported"",""Data encryption not supported""},tdc_parcel_utils,472,undefined,""Data encryption not supported"",undefined}. Last event: [{sds_comm_msg,mk_td,mt_start,{[{class,1},{encrypt_flag,...},{...}|...],<<3,129,...>>}}]. State: waiting_for_message. Data: td_pxc_state.",""

To learn more about the Hyper-Q log files, see Hyper-Q Monitoring for Azure Synapse in the Datometry for Microsoft Azure documentation.

Cause

By default, all data requested and transmitted by Microsoft Power BI is encrypted in transit using HTTPS to connect from the data source to Microsoft Power BI. A secure connection is established with the data provider, and only once that connection is established will data traverse the network.

However, in certain circumstances the data source you are trying to access does not support encryption, as indicated by the Hyper-Q DTM1018 error log message Data encryption not supported.

Solution

Disable encrypted connections in Microsoft Power BI.

To disable encrypted connections:

1. Select File -> Options and Settings -> Data Source Settings.
2. Choose the current data source and click Edit.
3. Uncheck Encrypt Connections.

For more information on disabling encrypted connections in Microsoft Power BI, refer to the Microsoft Power BI documentation.