Is the connector certified by Microsoft?
Yes, Microsoft has completed their certification process. Our Power BI Connector is the only OneStream to Power BI Connector that has completed the Microsoft certification process.
Do I need to be a SaaS cloud customer to use the Power BI Connector?
Yes, customers need to be on our SaaS offering.
What version of the OneStream platform do I need to be on to use the OS Power BIConnector?
Customers must be on platform version 8.2 or later for the Power BI Connector to work.
What version of Power BI is required to use the OneStream Power BI Connector?
The connector will work with the May 2024 release of Power BI Desktop and all subsequent releases.
What type of data can be pulled from OS?
-
Get Cube Data: Retrieves cube data based on parameters you specify.
-
Get Custom Connector Data: Retrieves OneStream data according to a specific dashboard data connector.
-
Get Dimension Data: Retrieves a list of dimension members for a specific scenario and dimension type. The list is leveled, meaning there will be as many columns as the number of levels in the dimension.
-
Get Member Properties: Retrieves member attributes for a specific scenario and dimension type, including formulas used to calculate the member.
Are dynamic values exported into Power BI?
Yes, if you are using a Cube View through a custom data adapter. They are not exported using the Get Cube Data method.
Can I use a service account to run the Power BI Service?
Yes, it is possible to substitute service account credentials for OneStream user credentials in the Power BI Service. The service account must be added as a user to the OneStream platform.
Can I use an OneStream Power BI Connector connection to pull data from Excel?
Yes. The semantic model for the connection must first be saved to the Power BI Service. After it is there, Excel users can use the Get Data > From Power Platform to access the connections and pull data into either a table or a pivot table. You must also be on Microsoft 365.
What is the syntax for parameters?
Syntax for parameters is very minimalist. It follows the form: ParamterName1=Value1, ParamterName2=Value2.
NOTE: Besides comma separators, there are no delimiters or other special character such as single quotes, double quotes, exclamation points, or pipes.
IMPORTANT: There are no spaces on either side of the commas used to separate parameter/value pairs.
IMPORTANT: Use the name of the parameter and not the user prompt and use the name of the value and not its description.
Can I use multiple dimensional members as parameters in the Power BI Connector with the Custom Data pull method?
Yes, but they must be enclosed in square brackets.
Example: ParameterX = [S#Actual,S#Budget] when used in a data adapter connected to a CubeView.
Example: ParameterY = [('Actual','Budget')] where ParameterY is used with a SQL WHERE...IN statement and used in a data adapter connected to an SQL Query.
Can I pull annotations and comments made in cubes?
Yes, it is possible using the Cube View data adapter. Cube View MD does not include comments or annotations.
Are there any settings we can change in Power BI Desktop to improve performance when pulling large sets of data or several pulls at once?
Yes, we recommend setting the maximum number of parallel jobs to eight.
Can I use member expansion functions when pulling data using the Get Cube Data pull method?
Yes, the standard expansion functions, like base, parents, or children, can be used to specify the level of granularity of the data to pull from OneStream.
I am pulling data using a SQL custom data adapter. Which cube should I choose for my connection?
It doesn’t matter. You can choose any cube and it will work.
