refresh parameters

[MarkusEng1998]

I created a way to switch between Web URL datasources from a vendor by creating cascading parameters. The first one (ProjNo) selects the project number. The second one (ProjURL) concatenates this number into the actual web request. I have to update ProjNo first, then update ProjURL. Is there a way to trigger the refresh of the subsequent parameters?

Thanks in advance for any suggestions.

[MarkusEng1998]

Thanks, Caitlan. No I don't have Premium. This is my workaround.

[v-xiaoyan-msft · Accepted solution]

Hi @MarkusEng1998，

I'm not sure I understand your needs exactly.
You can implement it, but it needs to be done in a Power BI Paginated report and it requires a Power BI Premium license.

Please check if this article is helpful to you:

Use cascading parameters in paginated reports  

Also, you can refer to this case:Referencing one parameter within another parameter within Power Query 

Hope it helps,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.