Unlocking Power BI: The Secret of Paginated Report Parameters

[@paulb236]

Just tried this 29/1/2025 and it worked for multi and single value selected on a multi select. Thank you.

[@kmaduri]

Hi Thanks for details explanation. I have been into Cognos and worked on Burst report, would like to know the same burst features in PowerBI. My question is once the Paginated report created with option to choose parameter values, how do set up the burst on that report from Power BI Service in a specific format generate a separate report for each color from drop down dynamically and saves into a folder? When I created similar report in Report builder then created the flow in Power Automate after published to Power BI Service, the flow is keep failing as it is not passing the parameter value automatically. In cognos when we set up the burst and assign the burst field, it will automatically picks up the value from burst query and generates the report. I'm looking for the steps and process how we can do burst in Power BI. Thanks

[@BlighHedges]

Can confirm they have updated so when you choose a single value do not get an error anymore 12:00

[@CG_PT]

Hi, Thank you for this information. I have done this but at the end when I am trying to use my parameter, it comes up with an error message. It works up until I create the parameter list. Is there any way that I can get some help with this?

[@AlessandroDiMarco-y2n]

You may not need to have users suffer with selecting either one value or multiple (or support team be harassed). Create the parameter normally (multi-value). You can use the excel sheet to feed its values as you did (but watch for Culture errors and eventually force the locale on the dataset to resolve the issue). Pass the parameter as a string by joining the list array into a single comma separated value and capture it in Power BI M dataset with a regular String Parameter. Split it back with a paramList = Text.Split(yourparameter,",") And use it to filter your table #"Filtered rows" = if (yourparameter "") then Table.SelectRows(#"Unfiltered Rows", each List.Contains(paramList, [yourcolumn])) else #"Unfiltered Rows" works for me.