ITLink website

Using TMVGate to Connect TM1 to Power BI

Connect TM1 to Power BI Without TI Scripts or Middleware

Jay Wang

Jay Wang is the Managing Director of ITLink, a leading Singapore-based IT consulting firm renowned for its innovative problem-solving capabilities and trusted partnerships with multinational corporations. With three decades of experience at the forefront of technology solutions, Jay has steered ITLink to become a powerhouse in data analytics, TM1 documentation, and enterprise IT transformation.

Step-by-Step: How to Connect TM1 to Power BI Using TMVGate

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.

‍

Always generate your TMVGate view URL using a pre-saved TM1 view with consistent dimension order. This ensures stable report refreshes and accurate data alignment in 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.'

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.

Still wrestling with TM1 performance issues?

We’ve helped multiple Singapore teams cut calculation times by 50%+

Get your system reviewed →

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.

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