Autocreate report from PBI report to Excel

[MilanZ]

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 · Accepted solution]

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,

[MilanZ]

Thanks!