web
You’re offline. This is a read only version of the page.
close
Skip to main content

    Power BI

    Under Review

    Add support for accessing Informix DBs

    Vote (15) Share
    Brett Trevethan's profile image

    Brett Trevethan on 17 Mar 2015 07:56:46

    Would like to be able to access IBM Informix Data Sources

    Comments (4)
    Brett Trevethan's profile image Profile Picture

    8af774e6 9667-41d9-9427-14ab36a9c448 on 05 Jul 2020 22:14:14

    RE: Add support for accessing Informix DBs

    I have IBM Informix setup through ODBC (V.4.10.00.16157) and in Power BI Desktop when I try to pull from ODBC it will give an error.

    DataSource.Error: ODBC: SUCCESS_WITH_INFO [01004] [Informix][Informix ODBC Driver]Data truncated.

    So I can not pull in any tables/columns for our UCCX 9.0.2 server. Any ideas?

    Brett Trevethan's profile image Profile Picture

    b3a26833 078d-474d-8e8e-0bb36b439ccb on 05 Jul 2020 22:02:59

    RE: Add support for accessing Informix DBs

    NO I am unable to access informix

    Brett Trevethan's profile image Profile Picture

    703fff01 0bb8-4580-90ac-1720c8024774 on 05 Jul 2020 21:58:58

    RE: Add support for accessing Informix DBs

    Hi Miguel

    I did try this. I was specifically talking about Power Query. Its ok for me but using just an ODBC data source can be a bit much for some business users/analysts.

    Cheers

    Brett

    Brett Trevethan's profile image Profile Picture

    e2e6b84b 990f-4200-af5e-4fabe907209c on 05 Jul 2020 21:58:57

    RE: Add support for accessing Informix DBs

    Thanks for the feedback, Brett - Currently you can access Informix using the Power BI Designer or Power Query, via ODBC data source.

    Did you try this approach? Any show-stoppers that you found with it?