Export and email table from published report, weeklser

Hello,

This may not be the correct place but I'm hoping that enough power bi devs see it and someone knows how to do this. 

Every week: I have to open up my report in power bi service, export my table into excel. Then attach it to an email and send it to the same group of people. Recently I saw a video on how to use power automate to export an entire report with a click of a button. 

What I want: is to automatically on a weekly basis, export all the tables in my power bi report into excel. Is this possible? 

Thanks in advance, 

Michelle