New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

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
Was this helpful?
Previous How to create a real time dashboard with Flow (Power Automate) and Power BI
Next Paginated Reports with MS Word and Power BI

Reader Interactions

Let us know your thoughts...

Table of Contents