Forum Discussion
pang22
Helper III
Helper IIIexport the report automatically from PowerBI
Hello,
I have published the Powerbi report to My workspace.
Is there any method to auto export the detail table data to excel automatically daily and send the excel via email?
2 Replies
rubayatyasminCommunity Champion
Hi, pang22
use Power Automate cloud flow. and to export data to excel you can use BI helper.
Export and email a report with Power Automate - Power BI | Microsoft Learn
Solved: PowerBI Export - Scheduling and Send Export to Exc... - Microsoft Fabric Community
- christinepayton
Most Valuable Professional
Yes, you can use Power Automate for this. If it's not a paginated report, you can use the action "query a dataset" - I did a tutorial on it here - in the example it's embedded in an email, but you can simply drop the query results into a CSV and attach it to the email instead.
