Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Getting Data from 32-Bit ODBC in 64-Bit Power BI

I am trying to access an SQL Anywhere server using an ODBC driver. I have created a 64-bit link to the database that I can see and access through Power BI. However, when I try to load any table from the database into Power BI, I get this error:

It will not allow me to add any of these tables into Power BI as a result. I'm guessing that because the SQL server is a 32-bit application, that it is giving me this error. My colleagues were able to get this connection to work without this error, so I'm uncertain what the problem on my end could be.

 

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous I believe you will need to use the 32-bit version of the Power BI Desktop instead of the 64-bit client.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      That does seem to work. I was certain a colleague of mine had looked into this database with 64-bit Power BI. For now I guess I will try the 32-bit and hope that it suffices.

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        6 years ago

        Anonymous , I think the driver should same like 32-bit ODBC driver. power typically requires the same bit driver.