Forum Discussion
automatic export to excel
Does anyone know if there's a way to have data in Power BI Desktop exported out to an excel document automatically (without having to click on the ellipses and select Export Data) on a recurring basi...
I've managed to do this through the Power BI Excel Add-In. You basically have a pivot table in excel where its data source is the Power BI report itself (with all your columns and measures).
You update this as a regular pivot table and it will pull the data straight from Power BI, you just need to make the pivot table
I’ll try this, thanks!