Creating a dataflow using gen1 and odbc while connecting to hive database

[ssewanyanaherbe]

Unknown error from external service: DMTS_PublishDatasourceToClusterErrorCode (Session ID: 0ffdf039-b53f-4386-9643-2ed58c1dcba6, Region: europe)

I am using treasure data presto odbc drive to create a dataflow using gen1.My odbc testing is ok and the connection shows online on service.

However, when i try creating the dataflow i get the above error, anyone to provide a connection string that would enable me access the data in hive. note my odbc connection has ssl enables since i cannot have access to the database without them.

[v-prasare]

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?
If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[ssewanyanaherbe]

Hey Kindly not the issue hasn't been solved to date

[v-prasare]

Hi @ssewanyanaherbe,

If your getting blocked here, please consider raising a support ticket for further assistance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth

[GilbertQ]

Hi @ssewanyanaherbe 

One further point I have often seen being an issue when using SSL certificates is that you will also need to have the SSL certificate installed on the gateway server for it to communicate successfully with your ODBC data source. If you can confirm that has been done.

[Herbert38]

i even tried the option of using the connection string = odbc name but still failing

[ssewanyanaherbe]

SSL certificates are installed on the server as well, even the desktop version that allows connection is run from the server
May be if can provide me with connection string you use while connecting for comparision

[Lodha_Jaydeep]

Hi @ssewanyanaherbe,

Thanks for reaching fabric community. I can certainly understand how frustrating it is when your ODBC connection tests perfectly fine locally, but fails the moment you try to publish a Dataflow. That specific error code (DMTS_PublishDatasourceToClusterErrorCode) usually indicates a "handshake" issue between the Power BI Service and your Gateway cluster.

Since you are using a specialized Treasure Data Presto driver with SSL enabled, I would recommend checking these three areas:

• Try a DSN-less Connection String: Sometimes the Power BI Service struggles to resolve a local DSN name defined on the Gateway. Try using the full connection string directly in the Power Query source step. It should look something like this: Driver={Treasure Data Presto ODBC Driver};Host=[Host];Port=[Port];AuthenticationType=[Auth];SSL=1;

• Gateway Service Account Permissions: Since SSL is mandatory for your database, ensure that the Windows Service Account running your On-premises Data Gateway has the necessary permissions to access the SSL certificates on that machine. A connection can work for you locally but fail for the Gateway Service if it doesn't have the same certificate access.

• Update the Gateway: With the recent March 2026 updates, there have been some refinements in how Dataflows communicate with ODBC drivers. Ensuring your Gateway is on the latest version can often resolve these "Unknown errors" from external services.

One quick question: Have you had a chance to try this via Dataflow Gen2? It often provides more granular logs for ODBC connections and might give us a clearer picture of where the handshake is failing.

I hope this helps get your Hive data flowing! Please let us know if the connection string change works for you.