Filter the data in Power BI before you export it to excel using Power Automate
It is finally time to filter Power BI data using the filters in the report before we export it elsewhere, like excel, using Power Automate new step: Run a query against a dataset.
Here is the concatenate step, so you can copy it:
concat('"', replace(item()?['CategoryName'], ', ', '", "'), '"')
Watch the tutorial:

Other videos on the topic:

1
/
2


How to create a Export to Excel / CSV button in Power BI

Append exported Power BI data to Excel, AUTOMATICALLY π

Automatic exports of Power BI data π€ | Run a query against a dataset

Export from Power BI to Excel up to π₯100k rows π₯| Run a query against a dataset

Export MORE THAN 100k rows of Power BI data to CSV using Power Automate | No ROW limits!

Export data from Power BI – No limits -No headers

Change column names when exporting data from Power BI | Run a query against a dataset

Smart Alerts are finally here!!! π

Filter Power BI exports with Power Automate filters | Run a query against a dataset

Filter the data in Power BI before you export it to excel using Power Automate

Export Power BI data to different folders based on filters with Power Automate

Export Power BI data to different files based on CategoryID with Power Automate

Export Power BI data to different files based on category name

Export Power BI data to any format: excel, power point, pdf, xml, …..

Automatic exports of Power BI data to a local folder
1
/
2

Was this helpful?
Hi! I’ve added my filters but now my csv is only 1k rows and it should be 10k. Any workaround to this? Without the filters it gets exported correctly. Thanks for these series of videos, are great!