The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

JACardona's avatar
JACardona
New Contributor
4 years ago

Can PowerBI be connected to OneStream to pull CV Excel reports that are saved in File Explorer?

We are currently producing and saving excel extracts of CV's into File Explorer using books/parcel service. We would like to connect PowerBI to OneStream to pick up these files from the OS managed se...
Data Integration
johnnyRockets's avatar
johnnyRockets
New Contributor II
3 years ago

Yes, it is definitely possible to connect PowerBI to OneStream using OneStream's REST API. It takes some authentication setup and a OneStream business rule to produce the data sets needed. Assuming the REST API is enabled, you can then call out of PowerBI for an endpoint that returns a OneStream data set.

Please see below:

https://www.schgroup.com/resource/blog-post/how-to-connect-onestream-and-power-bi-in-4-steps/