Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Cognos TM1 as a data source

    Vote (748) Share
    Ron Pooters's profile image

    Ron Pooters on 21 Apr 2015 00:56:18

    Would be great to have Cognos TM1 cubes as a data source for PowerQuery/Power BI Designer.

    Comments (111)
    Ron Pooters's profile image Profile Picture

    charlie on 16 Aug 2020 04:11:42

    RE: Cognos TM1 as a data source

    I see lots of security issues TM1 will have but itll always be good to have

    Ron Pooters's profile image Profile Picture

    Power BI User on 16 Aug 2020 04:11:38

    RE: Cognos TM1 as a data source

    we all should go out for a drink one day this is achieved. so eager to see this is happening tomorrow!

    Ron Pooters's profile image Profile Picture

    Deepak Shahdadpuri on 16 Aug 2020 04:11:17

    RE: Cognos TM1 as a data source

    Great idea, expecting a positive response as always.

    Ron Pooters's profile image Profile Picture

    Paul Southerland on 16 Aug 2020 04:11:00

    RE: Cognos TM1 as a data source

    This is needed for Power BI to provide self-service functionality for organizations that had previously committed to TM1 for corporate data warehouse solutions

    Ron Pooters's profile image Profile Picture

    Luis Lucchini on 16 Aug 2020 04:10:02

    RE: Cognos TM1 as a data source

    Please, please guys please.

    Ron Pooters's profile image Profile Picture

    Deepanshu on 16 Aug 2020 04:09:35

    RE: Cognos TM1 as a data source

    Yes. This is very much needed. I have come across many customers asking for this.

    Ron Pooters's profile image Profile Picture

    Ricardo Montero on 16 Aug 2020 04:09:06

    RE: Cognos TM1 as a data source

    ASAP Please!

    Ron Pooters's profile image Profile Picture

    Jialiang Wang on 16 Aug 2020 04:09:01

    RE: Cognos TM1 as a data source

    For those who are encountering similar difficulties connecting IBM PA/TM1 cubes to PowerBI, you might like to give TMVGate a try.
    TMVGate was specifically built to allow users to connect their data in Planning Analytics/TM1 to industry leading BI tools like PowerBI.

    It has a lightweight server based architecture and does not require any software or driver on the client workstation, making it ideal for widespread deployment.

    TMVGate returns Cube view (private or public) and Dimension Hierarchies data in real time streaming in either the JSON, XML, HTML or CSV (TXT or Pipe) format via a simple HTTP or HTTPS call.
    The various data streaming formats have been validated with the visualization tools mentioned, without the need for any additional scripting.

    You can watch the demo videos on our Youtube channel here:
    https://www.youtube.com/channel/UC95AcZmT7jByvMfWDCIWbWw

    Please send us an email if you'd like a free TMVGate trial we'll get back to you in as soon as possible. Most of our clients don't even require half of the free trial time to get their required results.
    Email: info@itlinkbiz.com or visit our website at https://www.itlinkbizs.com

    Ron Pooters's profile image Profile Picture

    Ben on 16 Aug 2020 04:08:47

    RE: Cognos TM1 as a data source

    Any update on this? We have plenty of clients using TM1 for their heavy lifting analytics and would love to create outputs in PBI

    Ron Pooters's profile image Profile Picture

    Staeven on 16 Aug 2020 04:08:47

    RE: Cognos TM1 as a data source

    We are in the process of implementing an on premise IBM Cognos Planning Analytics solution.
    Our primary delivery mechanism for delivery reports is Power BI (On premise).
    We really need to connect to a TM1 datasource.