Automated .pbix export to OneDrive/Sharepoint

[NovaBI]

Hello everybody,

is there a way to export reports automatically to another source?

We are using PBI Service as and app, everyone is a Pro user. That works well. The reports are updated daily with a scheduled refresh. 

I'd like to export the PBIX on a daily basis from PBI Ser to a Group Site in One Drive, but w/o manuel work. Is that possible?

[V-pazhen-msft · Accepted solution]

@NovaBI 
There is no such feature in power bi, but with my research it is possible with Flow, you may give it a try please refer to the following posts.

https://www.thebiccountant.com/2019/04/01/export-data-from-power-bi-using-microsoft-flow/.

https://blog.crossjoin.co.uk/2018/09/26/using-power-query-and-microsoft-flow-to-automate-the-creatio....

https://powerusers.microsoft.com/t5/Building-Flows/How-to-automate-Export-to-Excel-for-a-SharePoint-....

https://docs.microsoft.com/en-us/power-automate/run-scheduled-tasks.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau]

Hi. You can't automate an export from service. You can try to do it in "Transform Data" or "Edit Queries" from Power Bi Desktop to export when refreshing assuming that you have data on premise and it's using an on premise data gateway.

If you have a gateway on premise running the refreshes you can do something like this:

https://blog.ladataweb.com.ar/post/617917545084846080/powerbi-exportar-datos-automáticamente-al

That way you can automate the export. Maybe there is some way to do it calling Power Automate in case you don't have a gateway.

I don't think you have more than those two alternatives.

Regards,