Forum Discussion
ODBC Connection Error - Driver Error
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
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.