Skip to main content
December 7, 2021

Any configuration requirements to use REST API

  • December 7, 2021
  • 5 replies
  • 0 views

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

5 replies

December 7, 2021

It is detailed in the documentation.

Authentication

December 7, 2021

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

December 8, 2021

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)

MZ4Author
December 10, 2021

Thanks.

April 12, 2022

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.

April 12, 2022

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

April 12, 2022

Hey NLBart Thanks for you inputs. Really appreciated.