How to Connect TM1 to Power BI

, ,
11 September 2023
Jay Wang

How to Connect TM1 to Power BI

What is TMVGate?

Connect IBM Planning Analytics to Power BI with TMVGate! TMVGate is a powerful connector that seamlessly connects IBM Planning Analytics (formerly known as TM1) with leading data visualization platforms, including Power BI.

Learn How to Connect TM1 with Power BI using TMVGate

For those familiar with TM1 and BI tools, here's a quick demo to show just how easy it is to connect the two using our TM1 to Power BI connector, TMVGate.

Select the TM1 Data to Connect to Power BI

Open your TM1 server and select the cube containing the data you want to analyze. For this example, let's say we select a Sales Cube and then click on views to choose by region.

TM1 Data to Connect to Power BI

How to Make the Connection Between TM1 and Power BI?

Open TMVGate's simple interface and fill out the necessary fields—username, password, and cube details. Click on 'Generate Get View URL,' copy the generated URL.

Connect TM1 and Power BI

Importing TM1 Data into Power BI

Open Power BI and click on 'Get Data,' then 'Web.' Paste the copied URL and click 'OK.'

Import TM1 Data to Power BI

The data is loaded swiftly, and you click on 'Load' to proceed.

tm1 connecting to power bi

Data Visualization in Power BI

For this example, we'll choose 'region' and 'summation value' to visualize total sales value by region.

tm1 connector to power bi data visualization

And there we go! With these simple steps you can connect TM1 with Power BI.

Further Considerations

  • A secure and effortless implementation: TMVGate leverages a High-Performance Extraction Engine to extract data directly from TM1, without requiring additional resources or hardware. This allows for the straightforward export of data from existing TM1 cubes and views without the need for complex TI scripts. TMVGate maintains the integrity of your TM1 security structure ensuring all existing access control measures in TM1 remain in effect when you connect it with Power BI.
  • Real-time connectivity and cost-effective ownership: Are you looking for real-time data updates? TMVGate has you covered. And with a lifetime license, you gain complete ownership and control, all while enjoying cost benefits.

Explore Further

For more information or a free trial, contact us at

Jay Wang (ITLink, Principal Consultant)
ITLink is a Singapore-based IT consulting company that has been working with diverse multinational corporations to solve their business problems for the past two decades. #TM1 #PlanningAnalytics #HealthCheck #PerformanceAnalysis
© ITLink 2024, All rights reserved.