Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How to automate export to excel?

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 Cen...
Need Help
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
2 years ago

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