How to automate export to excel?

[ovonel]

I get this very nice report, in excel, with the message:

"Applied filters:
Week Offset is less than 0
FiscalYear is Current Fiscal Year
FY & Month is FY24 - 07 - Dec
Cost Center is PTP Depot Center"

How can I automate it to get this excel, say daily... I haven't found such option yet.

[edhans]

You cannot do this in Power BI. You would need to use Power Automate to run a DAX query, send it to the model to get the data, and then Power Automate can convert that to a CSV file and email it to you, drop it in a Sharepoint folder, or whatever. The Power Automate community would be the place to ask how to do all of this except for the DAX query. For that, you can probably get the query from Power BI Desktop for the visual you want - Performance Analyzer, Refresh Visuals, then get the DAX query of the viz you want automated.

Microsoft Power Automate Community - Power Platform Community