Forum Discussion
Dynamically export filtered data to CSV via Power Automate
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
Sounds good. What is your question? What have you tried and where are you stuck?
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.
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