Skip to main content

    Power BI

    Needs Votes

    Cognos TM1 as a data source

    Vote (576) 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 (97)
    Ron Pooters's profile image Profile Picture

    541dc091 8ce8-4f28-af2e-4abf16ef5830 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

    ec1d155c 7bc9-42d8-9147-25e66de6f9ff 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

    33acc2f4 b496-46a6-a97b-12bd62deb150 on 16 Aug 2020 04:09:06

    RE: Cognos TM1 as a data source

    ASAP Please!

    Ron Pooters's profile image Profile Picture

    c04218d9 e10b-43dd-9a79-7b34f3783118 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

    e592c598 2dce-4211-a1d4-654f6283ea12 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

    95a7efeb 5052-4137-871f-851e18b6a141 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.

    Ron Pooters's profile image Profile Picture

    b4efa219 601f-4674-aad9-e87cf9c7cbd7 on 16 Aug 2020 04:08:34

    RE: Cognos TM1 as a data source

    This would be great

    Ron Pooters's profile image Profile Picture

    c0bb5113 363f-466d-a32b-fc4609c92b57 on 16 Aug 2020 04:08:00

    RE: Cognos TM1 as a data source

    I would love to see this!

    Ron Pooters's profile image Profile Picture

    158ec9f6 498e-435a-9698-d5cab4ec7d56 on 16 Aug 2020 04:07:51

    RE: Cognos TM1 as a data source

    Waiting for this badly

    Ron Pooters's profile image Profile Picture

    b7bbe52d 3c23-4320-9fc7-7fe8ef9f8997 on 16 Aug 2020 04:07:50

    RE: Cognos TM1 as a data source

    Would also like to see Power BI connect to TM1. Just downloaded Power BI Desktop, and tried to connect to TM1 via ODATA Feed, first via https then http after restarting the TM1 Server with UseSSL=F and it fails to connect both times.