automatic export to excel

Question

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 basis?

Thanks!

alexvc · Answer

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

ibarrau · Answer

I think you would be able to do this with a Trick using R. Add a new step in edit query with R language. In this step you receive the dataset use for e.g.

write.csv(dataset, file = "MyData.csv")

Then output the same dataset to continue the steps in edit query. With this, you may be able to generate automatically a .csv file on each update the gateway runs.

Regards,

P/D You must have R installed in order to make the operation.

ibarrau · Answer

That is not possible with Power Bi.&nbsp;May be another tool can help you. Check DAX studio for example, but don't think this is posible.&nbsp;Regards,

anonymous · Answer

Hi akkolbeckIt is possible, with a little trickery.Take a look here:http://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-and-dax-studio-methods/and here: http://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-2-importing-power-bi-data-to-excel-directly/&nbsp;

v-swshaw · Answer

But then how will my R script run if I finally publish my report?Even if I use personal gateway this R script is for output data result in file so there is no source data connection in this case!

Forum Discussion

automatic export to excel

7 Replies

Related content

export data from power bi visuals to excel automatically

Automatic Export Report in Excel

schedule excel export

Export to excel automatically

Powerbi Export to Excel Option