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

    Maxwell Morin 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

    Dilip Sahu 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

    Brett Trevethan 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

    Miguel Miguel.Llopis 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?