Page 1 of 1
Cognos TM1 as data source in Microsft BI
Posted: Thu Oct 01, 2015 9:34 am
by mce
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
Re: Cognos TM1 as data source in Microsft BI
Posted: Thu Oct 01, 2015 10:06 am
by mce
I just saw the post in
http://www.tm1forum.com/viewtopic.php?f ... it=powerbi
It looks third party Gateway product helps with this.
Re: Cognos TM1 as data source in Microsft BI
Posted: Fri Oct 02, 2015 1:45 am
by nick_leeson
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
Re: Cognos TM1 as data source in Microsft BI
Posted: Fri Oct 02, 2015 10:53 am
by kangkc
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.
Re: Cognos TM1 as data source in Microsft BI
Posted: Wed Apr 26, 2017 3:13 pm
by davidkerby
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
Re: Cognos TM1 as data source in Microsft BI
Posted: Thu Apr 27, 2017 8:56 am
by stephen waters
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.