Forum Discussion
Creating New Connection ODBC
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)
2 Replies
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
Should I use the login used in powerbi gateway or should I use the login creds used for ODBC?
