Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

refresh parameters

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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous,

     

    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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable

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