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
Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
2 years ago

Hello,

The list of available APIs is available here : https://documentation.onestream.com/1375907/Content/REST%20API/OneStream%20Web%20API%20Endpoints.html

I don't think you can access a file from file explorer, but I usually use it to access either a Method or a Cube View ...

Regards,

tschilling's avatar
tschilling
Contributor
2 years ago

It's not exactly clean, but combining a Business rule with a data management sequence (which are callable from the API), there would be a way to do it.