Direct connection to TM1 CUBE

Question

Hi, I am trying to understand the best possible ways to connect to TM1 cubes to power bi without using third party connectors.

If you suggest ODBC driver can you please post me a link of the driver download location and name of it please

If any other way can you detail me step wise please.

If no better option than using third party which do you suggest please

nickyvv · Answer

If you don't want to use third party connectors you still have a few options:
- configure TM1 for an ODBC connection
- use Odata to connect to the cube

This question on the forum has a few good pointers to these options:
https://community.powerbi.com/t5/Power-Query/Connection-to-IBM-Cognos-TM1-via-OData/td-p/131562

anonymous · Answer

Thanks for the reply, how do we configure TM1 ODBC ? So we would get a link for every cube to which we connect from either OData/Web connector?

nickyvv · Answer

In the other question I mentioned there's a link to a support site with more info:
http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/how-to-configure-cognos-datasource-via-odbc-connection-3263273

anonymous · Answer

Thanks again, I have seen the link, just confused what driver needs to be used, for example if we need to access sql server through odbc then it would be sql odbc driver so just want the name of the odbc driver which needs to be configured

Forum Discussion

Direct connection to TM1 CUBE

4 Replies

Related content

RLS implementation under direct Lake connectivity

Power BI Direct Query (Live connection)

Private Endpoint support for direct EventHub → EventHouse connection

olap cube live connection

Replace Direct query table connection to a Direct query, QUERY connection - Databricks