Adding multiple parameters

[homboy27]

How do i add a 2nd parameter to below? i have another parameter called "Test" i would like to add to the below parameter

{Cube.ApplyParameter, "VAR_WBS_LEVEL1", {4, #"Test 2", null}},

[v-shex-msft]

Hi @homboy27 ,

Maybe you can try use below formula if it works.

#"Steps"= Cube.Transform(Source,
{
{Cube.ApplyParameter, "VAR_WBS_LEVEL1", {4}},
{Cube.ApplyParameter, "Test", {null}}
})

Regards,

Xiaoxin Sheng

[homboy27]

That didnt work. Is there anything else to try?

[homboy27]

Can anyone else please help?

[v-shex-msft]

HI @homboy27 ,

Maybe you can try to set up these parameters on connector navigation menu.

Connecting to SAP Business Warehouse Server using Power BI

Regards,

Xiaoxin Sheng