Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Multiple value parameters in URL paramters

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]
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.

2 Replies