Forum Discussion

New Contributor

3 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

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/

Forum Discussion

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

Related Content

Direct Connect Loads into OneStream

OneStream Identity Server (OIS) Content

Setup On-Prem Oracle DB connection in OneStream Cloud

Jdbc database connection for SIC

GitHub/OneStream Integration