In Power Automate, do the following:

1. Go to My Flows

2. Create a new automated cloud flow

3. Search for Power BI triggers -> Select When a data driven alert is triggered

As for updating the excel file, I would need more information. What is the data source of your report?