Forum Discussion

dbradley's avatar
dbradley
New Member
9 years ago

Connection to IBM Cognos TM1 via OData

Hi,   I've been struggling to connect to an IBM Cognos TM1 Database (enabled for Rest API) through Power BI and the OData Feed.   I see there is a third-party connector available to assist with t...
hugoberry's avatar
hugoberry
Icon for Responsive Resident rankResponsive Resident
9 years ago

Not ideal, however have you tried accessing the REST interface using a Web.Contents data access function?

 

=Web.Contents("http://tm1server:8000/api/v1/Cubes/$count")

If successful at least you know you're getting somewhere. Afterwards you can use Odata.Feed with some of its parameters set 

https://msdn.microsoft.com/en-us/library/mt260868.aspx