topic Dynamically export filtered data to CSV via Power Automate in Developer

Dynamically export filtered data to CSV via Power Automate

davidjmpinto — Sat, 09 May 2026 18:33:10 GMT

Hi all,

I'm trying to build a Power Automate flow that exports data from a Power BI semantic model to a CSV file in SharePoint, using the Run a query against a dataset action (to export more than 1000 rows). I've followed FourMoo's blog (link),the Curbal video (link) and Reza Dorrani (https://www.youtube.com/watch?v=cT4JdClkLh8&t=26s), but my scenario goes a step further: the user picks the dimension and measure dynamically.

Scenario
The report uses: Field parameter Dimensions — user picks one dimension (e.g. Product Brand, Sales Rep)
Field parameter Measures — user picks one measure (e.g. Invoiced Sales)

Calculation group Time Intelligence with selections like CY, PY,
Other filters in the filter pane / slicers (Year, Country, Currency)

I need the export to reflect whatever the user has selected — dimension, measure, time calc, and the other filters — and export to CSV.

Re: Dynamically export filtered data to CSV via Power Automate

lbendlin — Sat, 09 May 2026 21:40:58 GMT

Sounds good. What is your question? What have you tried and where are you stuck?

Re: Dynamically export filtered data to CSV via Power Automate

davidjmpinto — Sun, 10 May 2026 14:17:54 GMT

I followed the ‘Run a query against a dataset’ method (as I only want to export a matrix, I obtained the DAX query directly from the Performance Analyzer). The problem is that if I select different filters and run the flow, the exported data is always the same and does not adapt to my selection.