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

Question

Hi AllI 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.ThanksPoojitha

anonymous · Answer

Hi,The format works fine in SAP BW, but when I enter the same format in Power BI i.e,&nbsp;52500100000 - 600000000000 , I get an error saying value not found.Value from - Value to , does not seem to work in Power BI.&nbsp;Thanks

v-deddai1-msft · Answer

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

v-deddai1-msft · Answer

Hi Anonymous&nbsp;,&nbsp;You can enter range for variable value in both desktop and service:&nbsp;For desktop:&nbsp;&nbsp;&nbsp;For service:&nbsp;&nbsp;For more details, please refer to the official document : https://docs.microsoft.com/en-my/power-bi/service-edit-sap-variables&nbsp;If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.&nbsp;Best Regards,Dedmon Dai

anonymous · Answer

Please find the attached screenshot,For Fund/Sponsored Program variable, I would like to give values as a range like&nbsp;52500100000 to 600000000000 rather than individual values.Is there a way to do that?&nbsp;

v-deddai1-msft · Answer

Hi Anonymous&nbsp;,&nbsp;This format is fixed in power bi, I suggest you to find a solution in SAP BW commuity.&nbsp;Best Regards,Dedmon Dai

Forum Discussion

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

6 Replies

Related content

Variable source connection in DataFlow

Data source

Sharing Variables between two sources

SQL Statement Variable Date Range

Variable Library