Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi all,
We use both IBM Planning Analytics/TM1 and Power BI. I have seen several questions on the forums asking how to connect PBI to TM1 cube data but the question I'm more interested in is the use cases for doing so. Both have good reporting capabilities so I'm curious to hear from others what their experience has been and the advantages they have gained from using PBI to report on data from TM1 cubes.
Best,
Mitch
Hi @Anonymous ,
Please kindly refer to:
https://community.powerbi.com/t5/Power-Query/Connection-to-IBM-Cognos-TM1-via-OData/td-p/131562
https://veracitiz.com/blog/connect-power-bi-dashboard-with-tm1-cube-data-directly/
https://www.youtube.com/watch?v=oVZOf0Euxf0
https://www.dataclaritycorp.com/connect-tableau-and-powerbi-to-cognos-and-tm1/
https://community.powerbi.com/t5/Power-Query/Connection-to-IBM-Cognos-TM1-via-OData/td-p/131562
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks but the posts you cited are the same posts I referred to in my original post (where a lot of people are looking for guidance on the mechanics of connecting TM1 to PBI). My question in not the "how to" but rather what advantages are gained from using PBI to report on TM1 data that is not available in IBM's Planning Analytics Workspace reporting capabilities. In other words, what is the use case for using PBI against TM1 data...
Best,
Mitch
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!