Curbal has its own social media server on Mastodon. Check it out here!

Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / Knowledge Base / Filter the data in Power BI before you export it to excel using Power Automate
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

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

Posted
Updated
ByRuth Pozuelo Martinez

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
Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents