How to schedule and automatic daily report and save the chronology

[Quenjo]

Hi community,

I was wondering if there was a way (even if it implicates having the premium version of PowerBi) to automatically export an everyday report and keep an history of all the reports extracted everyday.

If there is a way, how can I achieve this ?

If not, is there maybe a way to locally save the report in an Excel file scheduling the script task everyday ?

Many thanks.

Let me know.

Regards,

quenjo

[Anonymous]

Power Automate? 

[Quenjo]

@Anonymous 

Thanks for your answer.

Is there a way, through power automate to publish the exact report containing the date / time at the extract moment on my workspace in the app.powerbi.com ?

This would be amazing.

[Anonymous]

pubulish a new report everyday?

like 
report-10-06-2022

report-09-06-2022

...

?

[Quenjo]

@Anonymous 

Exactly ! Without doing it manually. It is obiously needed, or at least I think so, to run PowerBi constantly on a virtual machine to schedule the job everyday.

I need to extract a financial report on a daily basis and have a chronology to have a sort of chronology for the customer.

[Anonymous · Accepted solution]

Power Automate can export and email reports

Power BI Automated Reports using Power Automate (mssqltips.com)

or you can do that via Power BI Rest API(PowerShell/Python....)