Multiple value parameters in URL paramters

Anonymous — Mon, 13 Apr 2020 15:41:57 GMT

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/889073. 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.

Re: Multiple value parameters in URL paramters

dar100111 — Mon, 13 Apr 2020 21:07:08 GMT

In the past, I have just generated a hyplerlink with the formatted values in a table already from the rows of data. That may not be the best way to try what you are doing, but it should be easy to create a calculated field for this. Hoping to also find other good examples of this.

Re: Multiple value parameters in URL paramters

d_gosbell — Fri, 17 Apr 2020 02:30:56 GMT

If this is for a report hosted on the service you should be able to do this using the "in" operator

see https://docs.microsoft.com/en-us/power-bi/service-url-filters#filter-on-more-than-one-value-in-a-field

topic Re: Multiple value parameters in URL paramters in Report Server

Multiple value parameters in URL paramters

Re: Multiple value parameters in URL paramters

Re: Multiple value parameters in URL paramters