This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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)
Should I use the login used in powerbi gateway or should I use the login creds used for ODBC?
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
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 10 | |
| 8 | |
| 7 | |
| 7 | |
| 7 |
| User | Count |
|---|---|
| 49 | |
| 27 | |
| 21 | |
| 20 | |
| 20 |