Forum Discussion
ODBC Connection Error - Driver Error
I've been trying to connect an ODBC database to the gateway in Power BI service.
I've been successful in connecting to this in Power BI Desktop, i've tried to replicate this process using the Power BI Service gateway.
It is returning an error complaining about locating the ODBC driver, I have confirmed I referenced the driver name correctly as seen in Power BI desktop:
Attempts in Power BI Gateway, windows authentication is used on power bi desktop to connect to the data source so i've used the same credentials:
This error is returned:
I have confirmed the DSN and driver name in ODBC Data Source Admin.
Hi Anonymous,
The error is caused by that you create User DSN in ODBC administrator. Please create a System DSN to points to your data source in in ODBC administrator, then add the ODBC data source under gateway. When adding a ODBC data source under gateway, make sure you enter the same connection string as that you get in Power BI Desktop. For more details, please review this similar thread: http://community.powerbi.com/t5/Integrations-with-Files-and/Personal-Gateway-X-On-Premises-Gateway/m-p/70945#M5526 .
Thanks,
Lydia Zhang
12 Replies
Hi Anonymous,
The error is caused by that you create User DSN in ODBC administrator. Please create a System DSN to points to your data source in in ODBC administrator, then add the ODBC data source under gateway. When adding a ODBC data source under gateway, make sure you enter the same connection string as that you get in Power BI Desktop. For more details, please review this similar thread: http://community.powerbi.com/t5/Integrations-with-Files-and/Personal-Gateway-X-On-Premises-Gateway/m-p/70945#M5526 .
Thanks,
Lydia ZhangThanks for that, I suppose Power BI only accepts 64-bit drivers for data sources?
I had to create a 64-bit DSN and use the 64-bit driver 'Microsoft Access dBASE Driver' where I was trying to use a 32-bit driver 'Microsoft dBase Driver' with a 32-bit DSN which gave mismatch between Driver and Application error, this can be seen in:
http://community.powerbi.com/t5/Integrations-with-Files-and/Gateway-Error-ODBC/m-p/157887#M9516
Thank you! works for me!
Hi, a late reply but I hope to help someone when including this information which is a fix for the issue I was having in my previous post here...
I'd like to add that I discovered the reason it wouldn't let me select On-premises gateway before, it was because I had a few CSV files included as part of the published report, these CSVs also need to be added to the Gateway as a File, pointing to the CSV.
Once I had done this, it was possible to select an On-premises gateway.
