schedule excel export

Hi viswaaa ,
This is actually a clever solution (to me atleast). You can maintain the formatting in Excel as well in this way. 
If you want to hook the paginated report up in a Power Automate flow to automate the saving to OneDrive part, even then there is an easy step available to do it since paginated reports export to excel without a fuss. From my experience, paginated reports have a tendency of introducing small additional cells in Excel around edges (or new pages in pdf) when the placement is not done right in the report builder but with some care this is not really an issue.