cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
1178
Views
0
Helpful
5
Replies
Highlighted
Beginner

ODBC connection successful on power Bi but no data

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

 

odbc.JPG

 

uccxdsn.JPG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted

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

View solution in original post

Highlighted

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

View solution in original post

5 REPLIES 5
Highlighted
VIP Collaborator

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.
Highlighted

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.

Highlighted

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.
Highlighted

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

View solution in original post

Highlighted

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

View solution in original post

Content for Community-Ad