Hello team,
Did anyone of you used TM1 cubes as data source Microfoft BI tools, such as PowerBI?
If you are interested in having this feature in MS BI, please vote here:
https://support.powerbi.com/forums/2652 ... ata-source
Regards
Cognos TM1 as data source in Microsft BI
- mce
- Community Contributor
- Posts: 352
- Joined: Tue Jul 20, 2010 5:01 pm
- OLAP Product: Cognos TM1
- Version: Planning Analytics Local 2.0.x
- Excel Version: 2013 2016
- Location: Istanbul, Turkey
Re: Cognos TM1 as data source in Microsft BI
I just saw the post in http://www.tm1forum.com/viewtopic.php?f ... it=powerbi
It looks third party Gateway product helps with this.
It looks third party Gateway product helps with this.
-
- Posts: 98
- Joined: Sat Feb 11, 2012 11:13 am
- OLAP Product: TM1 9x, BPC, Hyperion, HANA
- Version: TM1 10
- Excel Version: Excel 2003 - 2010
Re: Cognos TM1 as data source in Microsft BI
Power Query natively supports Odata V4 Payload which is the format you will get if you enable REST API on TM1 10.2.2 hence I would rather go down that path.
https://support.office.com/en-us/articl ... _176341939
I have not tested that yet but looks promising from a visual perspective .
Cheers
https://support.office.com/en-us/articl ... _176341939
I have not tested that yet but looks promising from a visual perspective .
Cheers
-
- Community Contributor
- Posts: 206
- Joined: Fri Oct 17, 2008 2:40 am
- OLAP Product: TM1, PA , TMVGate
- Version: 2.x
- Excel Version: 36x
- Location: Singapore
- Contact:
Re: Cognos TM1 as data source in Microsft BI
Unfortunately it 's not a straight forward task of using OData connection from PowerBI with TM1 Rest. Give it a test and you will know the issues.
-
- Posts: 1
- Joined: Wed Apr 26, 2017 7:50 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: Cognos TM1 as data source in Microsft BI
Hi, if you are looking to report from TM1 within PowerBI, you might be interested in the connector we have built to do this. If you'd like to discuss this further please email me at Dave.kerby@simpson-associates.co.uk
Thanks
Dave
Thanks
Dave
- stephen waters
- MVP
- Posts: 324
- Joined: Mon Jun 30, 2008 12:59 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: Excel 2010
Re: Cognos TM1 as data source in Microsft BI
CarpeDatum have a connector, TM1Connect, which links TM1 to Power BI (pLus Tableau and Qlik I think).
We are currently working with one of our clients on the Power BI\TM1 connection and initial tests results are good.
I think a couple of other partners have something similar as well.
We are currently working with one of our clients on the Power BI\TM1 connection and initial tests results are good.
I think a couple of other partners have something similar as well.