Forum Discussion
Helper IIExport filtered matrix to Excel using Power automate
Oh I see: You have entered the formula into the wrong window. That will indeed just interpret it as text.
Instead, click on "Add dynamic content" and then choose the "Expression"-window for the formula.
Community ChampionHi kb177 ,
You can use the "Run a query against a dataset"-action to fetch the data from Power BI.
You can retrieve the query code by turning on the performance analyzer, start recording and refresh the matrix visuals. Then copy the query and use it in the Power Automate action.
kb177I want to export to excel not to csv, After pasting the query in the below flow what should be done next
I dont want to create csv table and create a file from that
From there you can try converting CSVs to Excel with something like this template:
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-To-New-Excel-Table/td-p/1826096
