Multiple values for a parameter in URL parameters

[Anonymous]

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]

var baseURL = "https://app.powerbi.com.....?rp:MASTERREFERENCESProgramID="

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.

[V-lianl-msft]

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]

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