Hello,
I’m trying to connect my PowerBI Desktop-Client to our Starburst (Trino) service.
I get this error:
Unable to connect
We encountered an error while trying to connect.
Details: “The field ‘OdbcErrors’ of the record wasn’t found.”
Any ideas on that?
I tried the default Starburst connect without secured by Entra ID.
Second question:
I also want to try this ODBC driver (Starburst | ODBC driver V3 series)
Is there a way to use it without the need to install it with admin-rights?
Do you have any log files you could share? Or excerpts from the log files about this error?
Sorry no, there is no further logfile information. Do you have any specific logfile in mind?
Another question would be: Do you know whether the ODBC Starburst driver is free to use and is the driver able to connect to e.g. stackable trino, too?
From the log:
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {“Start”:“2025-09-02T09:21:02.4057591Z”,“Action”:“FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>”,“HostProcessId”:“19788”,“ProductVersion”:“2.144.1027.0 (25.06)+68a8b7d57a8dc2260d254189dc51b0bd804f76ff”,“ActivityId”:“1608e7a2-4c17-47b1-8429-f914b3b7dd00”,“Process”:“Microsoft.Mashup.Container.NetFX45”,“Pid”:43096,“Tid”:1,“Duration”:“00:00:00.0918997”}
ObjectCacheSessions/Metadata/CacheStats/Access {“Start”:“2025-09-02T09:26:59.5342713Z”,“Action”:“ObjectCacheSessions/Metadata/CacheStats/Access”,“hits”:“9”,“requests”:“10”,“hitrate”:“0,9”,“ProductVersion”:“2.144.1027.0 (25.06)+68a8b7d57a8dc2260d254189dc51b0bd804f76ff”,“ActivityId”:“00000000-0000-0000-0000-000000000000”,“Process”:“Microsoft.Mashup.Container.NetFX45”,“Pid”:43096,“Tid”:1,“Duration”:“00:00:00.0003233”}
SimpleDocumentEvaluator/GetResult/Compile {“Start”:“2025-09-02T09:26:59.5755245Z”,“Action”:“SimpleDocumentEvaluator/GetResult/Compile”,“HostProcessId”:“19788”,“PartitionKey”:“Section1/Query1/Source”,“Expression”:“let\r\n _t = Section1!Query1\r\nin\r\n if _t is table then Table.FirstN(_t, 1000) meta Value.Metadata(_t)\r\n else if _t is list then List.FirstN(_t, 1000) meta Value.Metadata(_t)\r\n else _t”,“ProductVersion”:“2.144.1027.0 (25.06)+68a8b7d57a8dc2260d254189dc51b0bd804f76ff”,“ActivityId”:“33ec2326-29b9-4016-813a-8be806634a0b”,“Process”:“Microsoft.Mashup.Container.NetFX45”,“Pid”:43096,“Tid”:1,“Duration”:“00:00:00.0325378”}
SimpleDocumentEvaluator/GetResult/Evaluate {“Start”:“2025-09-02T09:26:59.6084151Z”,“Action”:“SimpleDocumentEvaluator/GetResult/Evaluate”,“HostProcessId”:“19788”,“PartitionKey”:“Section1/Query1/Source”,“NativeImages”:“mscorlib,Microsoft.Mashup.Shims,Microsoft.Mashup.EventSource,Microsoft.Mashup.Document,Microsoft.Mashup.Client.Models,Microsoft.Practices.Unity,Microsoft.Mashup.DocumentServices,Microsoft.InformationProtection,Microsoft.Mashup.OAuth”,“ProductVersion”:“2.144.1027.0 (25.06)+68a8b7d57a8dc2260d254189dc51b0bd804f76ff”,“ActivityId”:“33ec2326-29b9-4016-813a-8be806634a0b”,“Process”:“Microsoft.Mashup.Container.NetFX45”,“Pid”:43096,“Tid”:1,“Duration”:“00:00:00.0221346”}
SimpleDocumentEvaluator/GetResult {“Start”:“2025-09-02T09:26:59.5754348Z”,“Action”:“SimpleDocumentEvaluator/GetResult”,“HostProcessId”:“19788”,“PartitionKey”:“Section1/Query1/Source”,“Exception”:“Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [Expression.Error] The field ‘OdbcErrors’ of the record wasn’t found.\r\nStackTrace:\n at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass3_0.b__0(EvaluationResult2`1 result)\r\n\r\n[ DataSourceKind = "StarburstPresto", DataSourcePath = "{""Host"":""starburst-dih-dqe-etu.apps.dso-ekad-test01.rz.bankenit.de"",""Port"":443}", ClientLibraryName = "Starburst ODBC Driver" ]\r\n”,“ProductVersion”:“2.144.1027.0 (25.06)+68a8b7d57a8dc2260d254189dc51b0bd804f76ff”,“ActivityId”:“33ec2326-29b9-4016-813a-8be806634a0b”,“Process”:“Microsoft.Mashup.Container.NetFX45”,“Pid”:43096,“Tid”:1,“Duration”:“00:00:00.0568180”}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource> {“Start”:“2025-09-02T09:26:59.5739990Z”,“Action”:“FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Evaluator.Interface.IPreviewValueSource>”,“HostProcessId”:“19788”,“ProductVersion”:“2.144.1027.0 (25.06)+68a8b7d57a8dc2260d254189dc51b0bd804f76ff”,“ActivityId”:“33ec2326-29b9-4016-813a-8be806634a0b”,“Process”:“Microsoft.Mashup.Container.NetFX45”,“Pid”:43096,“Tid”:1,“Duration”:“00:00:00.0583082”}
Hi @Xenobiologist ,
As from the error trace can you confirm what version of starburst driver is installed currently on your machine. can you please check in ODBC 64 bit.
for the second part of the question , The Starburst ODBC driver v2/v3 is provided free of cost by Starburst. You should be able to install it without any licensing fees or additional costs.
Second question:
I also want to try this ODBC driver (Starburst | ODBC driver V3 series)
Is there a way to use it without the need to install it with admin-rights?
regarding the above the Starburst ODBC driver can be installed without admin rights. Yes, it is possible to install the driver in a per-user context without requiring administrative privileges. However, this installation will only be available for the current user session rather than system-wide. Per-user installations without admin rights are feasible but limited to the user profile and session.
Sorry, I mixed some topics in my thread that might confused you.
To clear things up:
1) Using Starburst driver in PowerBI Desktop Client
Unable to connect
We encountered an error while trying to connect.
Details: “The field ‘OdbcErrors’ of the record wasn’t found.”
This error occurs when I try to use the “Standard” Starburst driver coming with PowerBI Desktop Client. There is no additional installation on my machine for using that driver.
2) Using Custom Connector Trino in PowerBI Desktop Client and PBI Gateway
This works on the client site, but gets a weird timeout message when using on the PowerBI service site (Gateway) on app.powerbi.com
Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.
Details: ENTW-PBI: Timeout expired. The timeout period elapsed prior to completion of the operation. Please have this information handy if you choose to create a support ticket. Session Id: 2ad8329c-36de-4e72-8e6f-0036e5b484a8 RequestId: ab4c6c4d-6401-41e6-9427-e368b105579e Cluster URI: https://api.powerbi.com Status code: 400 Time: Tue Aug 26 2025 14:34:41 GMT+0200 (Mitteleuropäische Sommerzeit)
3) Starburst ODBC driver
This driver works in PowerBI Desktop Client (Windows server machine where the Gateway is installed).
This published connection also works in the PBI Gateway! 
The next step is to test it on my local working machine with the PBI Desktop client. I do NOT have the rights to install it, so that is why I ask for the non-install here. In addition to that I’m waiting for our software team to install it via our software distribution system.
Please follow our official doc Starburst | Microsoft Power BI.
You must install ODBC driver first.
Depending on your system security set up, you might be able to install ODBC driver as long as you can edit local machine settings in registry table. But this is not what we want to explore. For simplicity, just install it with system admin right.
