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.
Hi Guys,
I did look for but i couln't find the awnser here.
I have to connect my power bi to informix database, power bi uses DRDA.
I don't have access to informix database to allow DRDA port is there anyway that I could set this up on my Power BI?
Thank you
Fab
Solved! Go to Solution.
Not yet, my action was to raise a ticked with IBM to enable the drda port.
For now my solution it's been using ODBC connector.
Hi @Anonymous ,
In the past I linked to an Informix table using an ODBC conection, so not directly to the Informix database but having a link trough OBDC, also because of limitations on connections.
Are you abble to have an ODBC conenction?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix
Yes, I'm trying to use the odbc connector too, however when connected I can't see any tables.
It just shows me "dns=ODBC" and nothing else.
Fabricio
Good morning I also have the same problem, someone has been able to solve it? Thank you.
Hi @Anonymous ,
There are a few similar threads about this issue.
https://community.powerbi.com/t5/Desktop/ODBC-connection-to-Informix-no-tables/td-p/962691
(Though the user resolved it using the SQL Server Linked server via SSRS eventually, you could reference the answer of @v-deddai1-msft to have a try. Maybe it works for you.)
https://community.powerbi.com/t5/Desktop/Connecting-to-Informix/td-p/53829
https://community.cisco.com/t5/unified-communications/microsoft-powerbi-with-cuic/td-p/3018267
Hi @Anonymous ,
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.
Not yet, my action was to raise a ticked with IBM to enable the drda port.
For now my solution it's been using ODBC connector.
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |