ODBC connection successful on power Bi but no data

[ravi.kumar1]

My ODBC system DSN test is successful and am able to make a successful connection using Power Bi but it doesn't load any data. Please see below screenshot

[Mike_Brezicky]

I cant speak much for Power Bi, but the ODBC connection just opens access to the database. I wouldnt expect it to load any data without requesting it. For any systems, wallboards, web apps, etc. that I have ever linked into via ODBC, I had always required additional queries or data replication to actually pull the data. My current SQL server does this by using a stored procedure to pull the informix table over every few minutes.

[ravi.kumar1]

i found this. This guy having the same trouble.

I think it is a bit issue, my machine is 64 bit and the driver and Power BI is 32 bit, not sure.

[Mike_Brezicky]

On Windows 10 / Server, you can run the app - Odbcad32.exe - which will open the 32 bit version of the ODBC tool. If you think that its 64 vs 32 bit issue, try adding the source there and see if that helps.

[ravi.kumar1 · Accepted solution]

yes, that's what i have used. ODBC 32 , ODBC 64 doesn't even show informix driver so it was never an option

[ravi.kumar1 · Accepted solution]

it worked after i download the latest driver from IBM's website

[David.J.Doyle]

Hey Ravi - do you have a link to the latest driver you downloaded from IBM's website - I thought I did download the latest but we are running into the exact issue you referenced in your original post.  Thank you.

[David.J.Doyle]

Disregard - I found it on the IBM website - you have to create an account to be able to download the latest versions. I downloaded the 32 bit and it is working now: Here is the url https://www.ibm.com/resources/mrs/assets/DownloadList?source=ifxdl&lang=en_US

I am adding a screenshot of the download we used: