Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I understand that if I try to "get data" from the Usage Metrics Report dataset in Power BI, it will perform a Direct Query instead of an Import. The reason I want to have it in Import Mode is so that I can view my data in Data view and Transform Data.
I know that if I used Power Automate to export data from the Usage Metric Report dataset, it'll be an import. How would I go about doing this? And is it recommended to have a scheduled or manual trigger?
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.
So this solution has Power Automate exporting the data into a PDF or PPT presentation. I really don't want that, I just want it in excel format.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |