Export(Excel) report to a drive with a subscription

Hi FahmiTUIC ,

Please try below steps:

1. Set up a Power BI subscription:
Go to your report in Power BI Service.
Click on the 'Subscribe' button.
Configure the subscription settings to send the report to an email address that you have access to. You can set the frequency to daily as per your requirement.
Save the subscription.
2. Create a Power Automate Flow:
Go to Power Automate.
Create a new automated flow.
Choose the trigger as 'When a new email arrives' (you can select the specific folder if needed).
Add an action to 'Get attachment' from the email.
Then, add an action to 'Create file' in the department drive directory where you want to save the report.
3. Test your Flow:
Once you've set up the flow, test it by triggering the Power BI subscription manually.
Check if the report is received in the email and subsequently saved to the department drive directory.
4. Monitor and Maintain:
Regularly check the flow runs to ensure it's working as expected.
Make adjustments if there are any changes in the report, email, or drive directory configurations.

Note: email subcribe attached file only have PDF and  PowerPoint format file

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.