Hi @portapattie
To export data from the Usage Metrics Report dataset in Power BI and place it in import mode, you can try the following steps using Power Automate:
Log in to Power Automate.
Navigate to Create > Scheduled Cloud Flow to start a new cloud flow.
Name your flow, set the start date and time, and repeat frequency.
Add a new step and search for Power BI. select Export to File for a Power BI report.
Select the workspace and report. For Export Format, select the desired format.
You also have the option to specify the pages to be exported, if required.
Add another new step to configure the exported file to be emailed using Outlook 's Send Email action.
Export and email a report with Power Automate - Power BI | Microsoft Learn
Deciding between scheduled or manual triggers depends on your specific needs:
Scheduled Triggers: if you need regular updates at fixed intervals, you can choose scheduled triggers. This ensures that your data is continually refreshed without the need for manual intervention.
Manual triggers: Manual triggers are suitable for ad-hoc exports where you do not need to update your data at regular intervals. This gives you control over when the data is exported, which is useful for one-off analyses or when data changes infrequently.
In summary, timed triggers are recommended if your use case requires up-to-date data at a specific time. For less frequent or on-demand exports, manual triggers may be more appropriate.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
