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
Solved! Go to Solution.
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.
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.
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: