Automatically creating CSV files of cost analysis report

Hi,

In the Cost Analysis report of the Azure subscription, I can generate a CSV file that contains the cost of each resource group. This is located in the screenshot:

We have multiple Azure subscriptions and every couple of ways, I would go to this section to download the CSV file (indicated via the red arrow).

Rather than checking Azure every day, I want to have a function where it would run automatically, generate the CSV file and then email it to me. I was wondering if there's a way to do this (e.g. maybe via Power Automate, Powershell or something else).

Jason