How to give range for a variable value with SAP BW as a source

[Anonymous]

Hi All
I have a requirement where I am using BW as a source .
I would like to enter a range in the variable value .
Can you pls let me know how we can enter range in the variables.
Thanks
Poojitha

[v-deddai1-msft]

Hi @Anonymous ,

You can enter range for variable value in both desktop and service:

For desktop:

 For service:

For more details, please refer to the official document : https://docs.microsoft.com/en-my/power-bi/service-edit-sap-variables

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Anonymous]

Please find the attached screenshot,

For Fund/Sponsored Program variable, I would like to give values as a range like 52500100000 to 600000000000 rather than individual values.

Is there a way to do that?

[vhms31]

Hi @Anonymous , have you tried to:

1. create Parameters in PowerQuery/ PowerBI (e.g. ValueStart, ValueEnd)
2. create a List in PowerQuery from ValueStart to ValueEnd (Tip: {ValueStart .. ValueEnd} )
3. use this List as Parameter in your SAP Query. In PowerQuery there should be a step that calls the function "Cube.Transform". There you can switch the entered value with your List

[v-deddai1-msft]

Hi @Anonymous ,

This format is fixed in power bi, I suggest you to find a solution in SAP BW commuity.

Best Regards,

Dedmon Dai

[Anonymous]

Hi,

The format works fine in SAP BW, but when I enter the same format in Power BI i.e, 52500100000 - 600000000000 , I get an error saying value not found.

Value from - Value to , does not seem to work in Power BI.

Thanks

[v-deddai1-msft]

I suggest you create an idea in Power BI forum:https://ideas.powerbi.com/forums/265200-power-bi-ideas to make this feature coming sooner.