Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NovaBI
Helper V
Helper V

Automated .pbix export to OneDrive/Sharepoint

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?

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@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.

View solution in original post

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@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
Super User
Super User

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,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors