An error occurred while saving the commentChristian Ofori-Boateng commented
You can do this with a third party tool like PBRS from ChristianSteven Software. https://go.christiansteven.com/power-bi-reports-scheduler-power-bi-reports-distribution-pbrs.
This will schedule the report as a visual in Excel, or as a data-dump in Excel or CSV and email it to a recipient. Schedule based on date/time or you can even schedule based on event triggers e.g. when a database record is modified or added.