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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thanks 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Anonymous,

      Yes. Power BI gateway only accepts 64-bit drivers for data sources.

      Thanks,
      Lydia Zhang

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        I have the gateway setup successfully, however I had to use a personal gateway as opposed to an on-premises gateway as it couldn't connect or find an on-premises gateway.

         

        I've read that ODBC isn't supported for Live/Direct and i'm not sure whether that affects the compatability, but should it be possible to use an ODBC dataset with on-premises gateway?

         

        I'm not sure what i'd gain from using on-premesis as opposed to personal when it comes to ODBC.

         

  • shunsho's avatar
    shunsho
    Frequent Visitor
    8 years ago

    Thank you! works for me!