Someone may correct me here but from what I can tell most of the visualization tools that support Odata expect it to be a straight GET call against a URL, possibly with some parameters. Unfortunately, the TM1 REST API isn't that simple and requires you to use POST as well as parse the response into a much flatter looking dataset.
Tableau has a custom Web Data Connector that essentially allows you to build a custom webpage to perform any actions you need and then pass the response into Tableau. I wrote a very basic WDC as a sample once, but someone with better web/javascript skills than I have could probably make something relatively easily. The downside is that large datasets don't come over the REST API very quickly. It's not terrible but compared to dropping to file its much slower. One upside is you can maintain user security to the data in TM1 since you can require login on the page that you will use to select your data.
The reason I bring up the Tableau example is you can roughly perform the same thing with PowerBI.
https://docs.microsoft.com/en-us/power-bi/desktop-connector-extensibilityAlso, many users just simply use a TI process to write out the data to database or file and then let their other tools read it from there.
Unfortunately there is nothing out of the box for any of these tools that I know of.
------------------------------
Robby Meyers
------------------------------
Original Message:
Sent: Fri June 07, 2019 06:32 PM
From: Ajay Yendluru
Subject: Access PA Cubes from Visualization tools
Hi All,
Has anyone set up connector from Power BI to Planning Analytics successfully
I understand that there is OData feed connection in PowerBI, PA went hubless from 2.0.5 and uses OData by default now ...I am struggling to set up connection between PowerBI and TM1
I also researched about ODBO however powerBI doesn't have that connector
There are third party connectors like gateways available however it's again another tool which needs licensing, maintenance and support
Any insights on this topic would be greatly appreciated
Thanks in Advance
Ajay
------------------------------
Ajay Yendluru
------------------------------
#PlanningAnalyticswithWatson