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.

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.

Importing TM1 Data into Power BI

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

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

Data Visualization in Power BI

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

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

• Introduction of TMVGate
• Preserving dimension hierarchies when connecting TM1 to Power BI
• Explore our YouTube channel

For more information or a free trial, contact us at info@itlink.com.sg