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

[adunn]

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.

[Greg_Deckler]

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

[adunn]

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]

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