Any configuration requirements to use REST API

MZ
New Contributor III

We have recently upgraded to version 6.5 from 5.1. Our Power BI consultants want to try the REST API to pull data out from OneStream repositories. Anyone has done this before and knows what setup/configuration need to perform before using REST API? Thanks

8 REPLIES 8

It is detailed in the documentation.

Authentication

LeeB
Contributor II

Main prerequisite is that you have to have an external authentication provider.

NLBart
New Contributor II

I have set-up the REST API with our Azure platform. The signon is with Azure AD and that works fine for us. If you have any specific question or difficulty let me know and maybe I can give some tips. (I have done it last summer and it was some trail and error method)

MZ
New Contributor III

Thanks.

IBK
New Contributor III

Hi NLBart. I am trying to do the same thing. Could you please let me know how this worked as the token keeps failing for me.

 

Thank You,

Indu

Nikpowar97
New Contributor III

Hey, @MZ  do you have any update on this. We also do have a similar approach. Currently we have connect OS with Azure. Can we anyway leverage it to connect with BI. Our requirement is to pull data from OneStream repository establishing connection with Rest APIs thereby specifying the server/DB name in Power BI.

 

Would really appreciate

TIA.

NLBart
New Contributor II

HI, OneStream is developing a Power BI connector. I have bene using it and tetsing it. It ises teh Azure log on, so when you have set-up the Azure log on already the other steps are not too difficult. It will allow you to directly query the data, get the hierarchies of your dimensions and get the information from Cubeviews. It is very versatile. I think they are slowly rolling it out, but I do not know their exact roll-out schedule. I would suggest that you ask your local OneStream representative if you can already start implementing and testing it. If you have any further questions etc. let me know. regards, Bart

Nikpowar97
New Contributor III

Hey @NLBart Thanks for you inputs. Really appreciated.

Please sign in! MZ