Hi, I am trying to pass muliple values in the paginated report, i.e. not multiple parameters. For instance I am trying see users aged 21, 22, 23, when I am passing 21 it works fine. But when I pass all three values it doesn't work. i.e. it gives blank page. Any suggesstions are much appreciated. I have posted it in the ideas Please click here to open . Regards,Uday

Hi stevenamani , I have finally managed to crack this, Things to do in the Paginated report: 1. Create a main dataset and then the other filter datasets, for example we have a 2 parameters (Division and Site)2. In the main dataset add this code FILTER(VALUES('Sites'[Division]),OR(@Division ="All",PATHCONTAINS(@Division,'Sites'[Division]))),FILTER(VALUES('Sites'[Site]),OR(@Site="All",PATHCONTAINS(@Site,'Sites'[Site]))),3. Under parameters section of the main dataset add this for the relevant parameters=Join(Parameters!Division.Value,"|")=Join(Parameters!Site.Value,"|")4. Under parameters make sure that you are allowing multiple values and the available values and default values are set to the relevant parameter datasets. Finally make sure that when you run the paginated report it should give you all the results i.e. the parameters are optional and unless you select the parameters the data should not be filtered. Things to do in the PBI reoprt1.Create a measure to export Excel Export URL = VAR __Division = IF (NOT ( ISFILTERED ( Sites[Division] ) ),BLANK (),"&rp:Division="& CONCATENATEX ( ALLSELECTED ( Sites[Division] ), Sites[Division] , "&rp:Division=" ))VAR __Site =IF (NOT ( ISFILTERED ( Sites[Site] ) ),BLANK (),"&rp:Site="& CONCATENATEX ( ALLSELECTED ( Sites[Site] ), Sites[Site], "&rp:Site=" )) VAR __baseURL = "https://app.powerbi.com/groups/e29303d3-a2bd-4e1f-b6cb-a85be2cbf72f/rdlreports/5670f37c-f056-4cc5-8cce-e903bcf559df?" &__Division&__Site VAR __FinalURL = CONCATENATE(__baseURL, "&rdl:format=EXCELOPENXML")RETURN__FinalURL ***** Make sure that you replace the __baseUrl hyperlink with your rdl report link. The best way to do so is to run the rdl report on the power BI service and copy it. 2. Add the measure to pass parameters to the excel.(in my report I have downloaded a excel image and in the action select web url and select the measure you have created). Hope this makes sense.

Hi Team,I got the solution, We need to give the expression like belowDim_Corp_Hier/Cur_Area_Nbr in ('" & Join(Parameters!Area.Value,"','") & "')

Hi v-lid-msft , I have set the parameter to be multi valued and also in the dataset I have set the default to select all the values as showed in the below video. https://www.youtube.com/watch?v=KYfhclGrI48&t=922s Regards, Prime

Hi Team, How we can achive the same in source as sql in report builder. In above example source as power bi report in report builder so that we can use that dax expressions but in my case source as sql server in report builder and using URL action we are trying to call the power bi serice report in report builder and it is working as expected for single selection but multi selection parameters it is not working

Hi Anonymous , Based on my research, We need to set Allow multiple values property for the parameter, please refer to this document: https://docs.microsoft.com/en-us/power-bi/report-builder-parameters#bkmk_Report_Parameters If you need to Pass a report parameter in a URL , The format for a multi-value parameter is to repeat the parameter name for each value. please refer to the example in this document: https://docs.microsoft.com/en-us/power-bi/report-builder-url-pass-parameters#additional-examples Best regards,Community Support Team _ Dong LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Paginated report with multi valued parameter not working

19 Replies

Narukkp
Helper V
5 years ago
Hi Team,
I got the solution, We need to give the expression like below
Dim_Corp_Hier/Cur_Area_Nbr in ('" & Join(Parameters!Area.Value,"','") & "')
v-lid-msft
Community Support
6 years ago
Hi Anonymous ,

Based on my research, We need to set Allow multiple values property for the parameter, please refer to this document: https://docs.microsoft.com/en-us/power-bi/report-builder-parameters#bkmk_Report_Parameters

If you need to Pass a report parameter in a URL , The format for a multi-value parameter is to repeat the parameter name for each value. please refer to the example in this document: https://docs.microsoft.com/en-us/power-bi/report-builder-url-pass-parameters#additional-examples

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous
  Not applicable
  6 years ago
  Hi v-lid-msft ,
  
  I have set the parameter to be multi valued and also in the dataset I have set the default to select all the values as showed in the below video.
  
  https://www.youtube.com/watch?v=KYfhclGrI48&t=922s
  
  Regards,
  
  Prime
  - v-lid-msft
    Community Support
    6 years ago
    Hi Anonymous ,
    
    How about the result if you repeat the parameter name for each value in a URL?
    
    Best regards,
    
    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable
3 years ago
Hi,
i have the same problem but with driver ODBC so i use ? instead of @
And this solution is not working,do u know something??
Anonymous
Not applicable
3 years ago
What was your final solution for power bi dataset?

Forum Discussion

Paginated report with multi valued parameter not working

19 Replies

Related content

Paginated Report visual Not working With parameters

Paginated Report - Field Parameter

Paginated report - optional parameter

Paginated Report with Parameter breaks in Service

Power BI Paginated Report Parameter Mapping Error