Forum Discussion
Alternative Ways to Update What-If Parameter in Embedded Report
I have embedded a PowerBi report in my web application and because I have many what-if parameters and the values are being plugged into DAX calculations, the report is very slow. I am exploring alternative methods to for updating the what-if parameters. Is it possible to update what-if parameters via the PowerBi API or via some other method?
7 Replies
mariussve1Solution Sage
Hi,
Could you use Apply all for achiving this? Then you adjust all the What if first and Then apply Them:
Br
Marius
Thank you for the suggestion, but unfortunately this will not work for us because we are plugging in the What-If parameters to DAX calculations. I have updated my original question post accordingly to reflect that information.
- mariussve1
Hi again,
Could it be possible to explore filtering "What if" with a URL filter?
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
Br
Marius
Unfortunately, this will not work for our use case either as we don't want to filter data but recalculate DAX calculations.
- mariussve1
But when you change the whatif parameter with a url filter it will be recalculated?
Marius
- mariussve1
Hi,
If you think my answer provided some kind of a soulition, please consider accepting it as soulition and click the button. I also greatly appreciate if you give me a kudos 🙂
Br
Marius
Hi,tc2024 .I am glad to help you.
Hello,mariussve1, thanks for your concern about this issue.
Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutionsI hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
