Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey, I have a Power BI Pro license. I am trying to export the data in CSV format and schedule it for weekly. Is there a way to achieve this. Thanks.
Solved! Go to Solution.
@smedarametla Please watch this video:
Hi @smedarametla ,
Thanks a lot @Tahreem24 , he provided the right idea, but the video he provided did not load for me.
You can refer to my steps:
Sign in to Power Automate.
Select Create > Scheduled cloud flow.
Name your flow, set the start date, time, and select the weekly frequency.
Add a new step to your flow, search for Power BI actions, and select Export To File for Power BI Reports.
Choose the workspace and report you wish to export.
Note: The export format options include PDF, PPTX, and PNG, but not CSV directly.
Add another step to send an email with the exported report attached.
Since direct CSV export is not available through this method, you may need to manually convert the exported file to CSV format.
Learn more about creating scheduled flows:
Export and email a report with Power Automate - Power BI | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi @smedarametla ,
Thanks a lot @Tahreem24 , he provided the right idea, but the video he provided did not load for me.
You can refer to my steps:
Sign in to Power Automate.
Select Create > Scheduled cloud flow.
Name your flow, set the start date, time, and select the weekly frequency.
Add a new step to your flow, search for Power BI actions, and select Export To File for Power BI Reports.
Choose the workspace and report you wish to export.
Note: The export format options include PDF, PPTX, and PNG, but not CSV directly.
Add another step to send an email with the exported report attached.
Since direct CSV export is not available through this method, you may need to manually convert the exported file to CSV format.
Learn more about creating scheduled flows:
Export and email a report with Power Automate - Power BI | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
@smedarametla Please watch this video:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |