Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Multiple values for a parameter in URL parameters

Hello

I am trying to trigger paginated report by passing paramters from Power BI. My question is how I can pass multiple values of the same parameter and multiple such parameters from URL to paginted report. There are a few threads in the forum that are similar. https://community.powerbi.com/t5/Service/Paginated-Report-Using-URL-Parameters-and-Select-ALL/m-p/88.... However, I have not found the solution. I have used the following measures. This is the base URL measure: 

Base URL =
var pid = [Selected Prid]
RETURN
CONCATENATE(baseURL, pid)
This is the measure to select the parameter values
Selected Prid = CALCULATE( (
        CONCATENATEX(
            MASTER_REFERENCES,
            MASTER_REFERENCES[Program ID],
            ","
        )
    )
)
This is the measure to download the report in a format
Word =
VAR baseURL =  [Base URL]
RETURN
CONCATENATE(baseURL, "&rdl:format=pdf")
 
The problem is it only generates the report when I select only 1 value from the slicer. The program ID in the service is not triggered when I select multiple values from the slicer

 

 

1) I want to select multiple program IDs in the slicer and generate report for it and I also have other slicers as well where the user would generally select from one of the slicers.

2) Is it possible to download the report without the end-user-viewing of the service page? Thank you.Any help is much appreciated and valuable.

Need Help
Show and Tell

2 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    1. According to my test, passing URL parameters does not support multiple choices at present.

    2. You can do this for paginated (rdl) reports, but not currently for Power BI (pbix) files. The ability to subscribe to pbix files is currently only available in the cloud service (so when you publish to powerbi.com)

     

    Best Regards,
    Liang
    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
      6 years ago

      Hello V-lianl-msft 

      Thank you for your reply.

      1. I think you can pass multiple values for a parameter. I tried to use "?rp:parameter" twice and it works but only for two values from the slicer. There is youtube video discussing this topic and they mentioned it is possible with some workaround.

      2. Whenever we pass a value from the slicer, the end user usually sees the service page of paginated report and then the file gets downloaded. We want to avoid that. I heard this is not the case with SSRS where the user just sees a flash and this can also be done in paginated. 

       

      Thank you