Direct connection to TM1 CUBE

[Anonymous]

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]

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]

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]

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-cog...

[Anonymous]

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