Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

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 Poojith...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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?

     

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

        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

    • vhms31's avatar
      vhms31
      New Member
      6 years ago

      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