Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sureshyadlapall
New Member

Power BI with planning analytics

Hi,

 

Can we connect to IBM planning analytics from power bi ?

 

Thanks,

Suresh Yadlapalli

3 REPLIES 3
bobgillvan
New Member

Using the TM1Py library, it only takes a few lines of code to pull a view or mdx query from Planning Analytics into Power BI. I did a video on it available here.

JLITLink
New Member

Hi Suresh
 
Sorry for the late reply, you might like to try TMVGate.
 
It is a purpose-built gateway and an efficient solution. It allows you to connect your data in Planning Analytics/TM1 to industry leading BI tools like PowerBI.

It has a lightweight server based architecture and does not require any software or driver on the client workstation, making it ideal for widespread deployment.

TMVGate returns Cube view (private or public) and Dimension Hierarchies data in real time streaming in either the JSON, XML, HTML or CSV (TXT or Pipe) format via a simple HTTP or HTTPS call. 
The various data streaming formats have been validated with the visualization tools mentioned, without the need for any additional scripting.
 
You can watch the demo videos on our Youtube channel here:

Please send us an email if you'd like a free TMVGate trial we'll get back to you in as soon as possible. Most of our clients don't even require half of the free trial time to get their required results. 
Email: info@itlinkbiz.com or visit our website at https://www.itlinkbizs.com
v-jiascu-msft
Employee
Employee

Hi Suresh,

 

It seems the IBM planning analytics is also a BI tool. Why not connecting to the data source directly? Maybe you can try the Planning analytics API. I would suggest you create an idea here for an official connector.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors