Dynamically export filtered data to CSV via Power Automate

[davidjmpinto]

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. 

[lbendlin]

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

[davidjmpinto]

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.