Help making a connection from IBM TM1 Cubes to PowerBI

[Anonymous]

I am very new to PowerBI and my first task is to connect a TM1 cube to PowerBI Desktop to begin creating reports off of. I have searched the community and tried to follow what others were doing spending hours trying and having no luck.  Has anyone successfully connected without purchasing a third party connector?  Thanks!

[mwegener · Accepted solution]

HI @Anonymous ,

yes, it works something like this.

Create an OLE DB connection

Connection string:

provider=TM1OLAP;access permission=Read;initial catalog=xxx

SQL statement:

SELECT [xxx].Members * [yyy].Members ON ROWS,
       [zzz].Members ON COLUMNS
FROM [yxz]