cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Movva365 Regular Visitor
Regular Visitor

Direct connection to TM1 CUBE

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
4 REPLIES 4
Super User I
Super User I

Re: Direct connection to TM1 CUBE

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Movva365 Regular Visitor
Regular Visitor

Re: Direct connection to TM1 CUBE

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?
Super User I
Super User I

Re: Direct connection to TM1 CUBE

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Movva365 Regular Visitor
Regular Visitor

Re: Direct connection to TM1 CUBE

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors