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.

[v-achippa · Accepted solution]

Hi @davidjmpinto,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response.

The issue here is the DAX query copied from Performance Analyzer is static, so the ‘Run a query against a dataset’ action will always execute the same query and return the same result.

Power Automate does not automatically pick up the current slicer, field parameter or calculation group selections from the report.

To make the export dynamic, the selected values from the power bi need to be passed into the flow and then applied dynamically in the DAX query before execution. Otherwise the export will continue returning the same data each time.

Thanks and regards,

Anjan Kumar Chippa