Print

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:

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

Other videos on the topic:

Was this helpful?

Reader Interactions

Comments

  1. 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!

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents