Creating New Connection ODBC

[GreaseM0nkey]

I have an on-premise Gateway installed in a server and created the dashboards in my laptop.  When I published the dashboard it is looking for a connection and tried to add to the gateway. 

But when trying to key in the log in credetials, it comes out with an error.

NGH-VP Gateway: ODBC: ERROR [HY000] [DataDirect][ODBC Hybrid driver]Insufficient information to connect to the data source. ERROR [01S00] [DataDirect][ODBC Hybrid driver]Invalid attribute in connection string: Trusted_Connection. ERROR [HY000] [DataDirect][ODBC Hybrid driver]Insufficient information to connect to the data source. ERROR [01S00] [DataDirect][ODBC Hybrid driver]Invalid attribute in connection string: Trusted_Connection. Please have this information handy if you choose to create a support ticket. Session Id: 0bb51bd6-7364-403a-8ce3-44a44a47b684 RequestId: c9b126cd-7334-4344-8edb-b897853c3bb1 Cluster URI: https://api.powerbi.com Status code: 400 Time: Tue Nov 12 2024 06:27:10 GMT+0800 (Philippine Standard Time)

[GreaseM0nkey]

Should I use the login used in powerbi gateway or should I use the login creds used for ODBC?

[Anonymous]

Hi @GreaseM0nkey ,

Based on the error message 'Invalid attribute in connection string: Trusted_Connection,' it seems that your data source may not support Windows authentication. Could you consider using an alternative authentication method?

Best Regards,

Bof