Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a DSN set up on the machine and I am able to use the DSN to connect via SQL server...the connection allows me to see the tables of the informix DB
With power BI I am using the ODBC option and I connect (using the DSN ) to the server but I am not able to list any tables.
I do not have access to the remote server hosting the informix DB so I need to get this ODBC connection operational
I have run a trace and I have found the following error in one of the "Microsoft.Mashup.Container..."log files
Hi pthawkes,
Are you trying to connect to sql server data source via odbc driver? If anything is misunderstood, please tell me.
>>ERROR [IM001] [Informix][Informix ODBC Driver]Driver does not support this function.\r\nStackTrace:\n
What is the version of odbc driver and desktop are you using? Would you please try to update it to the latest version? You can check it in the screenshot below:
Use win+R and type ODBCAD32 in it
Where did you create DSN? Please create DSN in System DSN. Here is the similar thread for your reference: https://community.powerbi.com/t5/Power-Query/Personal-Gateway-X-On-Premises-Gateway/m-p/70945#M5526
Best Regards,
Dedmon Dai
Hi Dedmon
Thanks for your response:
No, I am trying to connect to a remote informix database. What I was saying was that I have successully created a linked server in our sql enviroment using a SYSTEM DSN created earlier. I have now downloaded power Bi desktop to the SQL environment and I am trying to use the same SYSTEM DSN to connect power bi to this remote informix instance. The connection is successful - but I do not get a table listing so that I am able to start querying the tables.
Below is the ODBC Driver I am using to make the connection:
IBM Informix ODBC Driver (64 bit) Version 4.50.00.17629
Hi pthawkes,
I recommend you update the power bi desktop and the ODBC driver to the latest version. You can get the latest version of ODBC driver from https://www.ciscounitytools.com/Applications/CxN/InformixODBC/InformixODBC.html.
Would you please confirm if the user you map to in the linked server is the same as you used when you connect power bi desktop to informix.
As a workaround, would you please try to use datasource connection provided by power bi desktop:
Best Regards,
Dedmon Dai
Thanks Dedmon
I was trying to avoid using the power bi connector and just use the existing DSN connectivity I already had in place. I have given up trying to make it work and have decided to use the SQL Server Linked server via SSRS to generate the reports I need.
Otherwise thanks for taking the time to help out.
Hi pthawkes,
If you have any other questions please let me know.
Best Regards,
Dedmon Dai
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |