OneStream Navigator

The OneStream Connector uses the Import method and offers you the following options to pull data and metadata:

• Get Cube Data

• Get Custom Adapter Data

• Get Dimension

• Get Member Properties

  

Each option has required and optional parameters that need to be provided. Optional parameters have a default value that might need to be changed, based on the design of your OneStream application.

Toggle the parameters to just the required ones or use all of them. If necessary, Power BI will display a preview of data for the table that would be returned.

After providing the parameters select one of the following buttons: 

• Load: To load the table into the internal Power BI Desktop data model.

• Transform data: To make changes in the table before loading it into the internal Power BI Desktop data model. This option will launch Power Query Editor in a new window with a representative view of the table.

  NOTE: If you see the Load button and the Transform Data button grayed, check the checkbox on the left-hand side.

Repeat the steps above for all additional tables.

After data loads to Power BI Desktop data model, you can create relationships between tables as well as create reports.