Solved: Autocreate report from PBI report to Excel

MilanZ · ‎03-27-2018

Hi, Can you please help me if exist possibilitiy in PBI service to create a flow or something (like macro), which will generate an export data from PBI Report (or PBI Dashboard) to excel file, whic can be published on SharePoint or One Drive. Thanks Milan

ibarrau · ‎03-27-2018

Hi, there is no way to automatically export to excel with Power Bi. You have to do it manually.

A different way to try this is to create an excel on sharepoint with "Power Bi Publisher for excel" plugin in order to connect to power bi services with the excel file. Then you can create a pivot table with the requirement you have and configure to update the file any time is open.

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

View solution in original post

ibarrau · ‎03-27-2018

Hi, there is no way to automatically export to excel with Power Bi. You have to do it manually.

A different way to try this is to create an excel on sharepoint with "Power Bi Publisher for excel" plugin in order to connect to power bi services with the excel file. Then you can create a pivot table with the requirement you have and configure to update the file any time is open.

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