cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
229
Views
0
Helpful
4
Replies
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

Everyone's tags (4)
4 REPLIES 4
Highlighted
VIP Rising star

Re: ODBC connection successful on power Bi but no data

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
Beginner

Re: ODBC connection successful on power Bi but no data

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
VIP Rising star

Re: ODBC connection successful on power Bi but no data

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
Beginner

Re: ODBC connection successful on power Bi but no data

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

CreatePlease to create content