Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Multiple Parameters with Paginated Reports on Power Automate

I'm a little bit stuck at the moment with a Paginated report and Flow. I have a Power BI paginated report that uses location codes to filter a parameter location and then a Flow that emails each report to any user that appears on a SQL table row with that location code. For these purposes, this works very well with Flow building the Paginated report, filtering paramaters by code, and sending it to corresponding location manager's email.


However, this is problematic for users like district leadership, who need a report for more than one location, as each instance of their email prompts Flow to send an additional email (some managers receiving up to 27 emails in the morning). The paginated report uses page breaks within the grouping to separate each location when more than one facility is selected, so manually, I can create an export that is Sheet-separated by user in the excel output.


So the question is, how do I communicate to Power Automate to select multiple rows for a single parameter if the user's email is duplicated in the SQL table? I'm happy to rebuild my table for rethink how the report does grouping if needed.


I hope this isnt confusing, but any help would be appreciated. (p.s. I'm using Power BI Paginated rather than classic SSRS because we use data available on the Power BI Service in a standardized Dataset)

Frequent Visitor

I'm encountering a similar challenge with needing to input multiple values into a parameter which come from a Sharepoint Excel file, and would be keen to hear any ideas/solutions too.

I've tried inputting the multiple values as a concatenated string into one cell in my source file, then passing this as an array into the Flow parameter, but no luck there currently 🙁

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.