Automatic Export Report in Excel

[PiyushH1]

Hi 

Does anyone know if there's a way to have data in Power BI service exported out to an excel document automatically (without having to click on the ellipses and select Export Data) on a recurring basis?

Thanks!

[csssoft]

You can automatically export a Power BI report to Excel on a scheduled basis using PBRS, a third-party solution from ChristianSteven Software.

There is an easy to follow tutorial video here

[stvsurf · Accepted solution]

You can create a report with the Power BI dataset connection in power BI report builder, publish the RDL Report and then you can subscribe to the report and select XLSX as output

[PiyushH1]

@stvsurf ,

Thank for your response. It is very useful.

 my another question is, if someone else has publised report in Power Bi service without RDL report then can i subscribe reports in Excel ?

Thank you.