Forum Discussion
Solved
Can What if parameter pass to advanced Query?
Hi Power BI experts, Would like to know if some one has suggestion on pass "what if paramter" to Power query, and then pass it to SQL Server stored procedure. I have tried way community provided,...
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 Mariusz,
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. 😃
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. 😃
