Forum Discussion
Can What if parameter pass to advanced Query?
Hi juchen ,
Your demand is a good idea, while it is not supported to use What-if parameter in Advanced Editor in Power BI currently. You can post your new idea in Idea Forum , to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi juchen
You can not pass what-if parameters back to SQL server, you load all your data into a model on refresh, from there you use the only model as your data source.
If you want to reflect all the changes in you SQL DB you can use direct query mode, where you do not need to worry about passing parameters as DAX is folded into SQL on the fly, so filter context is translated into SQL.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Thanks for your promptly reply. I’m actually using direct query mode now. Since I need to pass user input value as variables of SQL server stored procedure, and user input function/field is not support in Power BI now, alternatively I’m thinking What-If parameter, letting user to slicer a range, then pass it to source sql server as direct query mode.
If what-if parameter cannot pass to stored procedure, do you have any suggestion on this scenario? Very appreciate for your help. 😃