Alternative Ways to Update What-If Parameter in Embedded Report

[tc2024]

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?

[Anonymous]

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 solutions

I 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.

[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

[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

[tc2024]

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,

Could you use Apply all for achiving this? Then you adjust all the What if first and Then apply Them:

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-new-apply-all-slicers-and-clear-all-slic...

Br

Marius

[tc2024]

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.