Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 Pow...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

shunsho's avatar
shunsho
Frequent Visitor
8 years ago

Thank you! works for me!