Forum Discussion
Send a weekly email with CSV
Hi,
Can someone please point me in the right direction about how I send a weekly email with an attached CSV, please? I have Power Automate, but not really too sure how to use it.
I want an email to be sent every Friday, 10am with the contects of a table in Power BI added to a CSV.
Thanks in advance.
I've not tried the power automate route.
If you have/can get a premium per user licence or have premium capacity you can use power bi report builder Power BI Report Builder - Power BI | Microsoft Docsto create a very basic table report. Then direct in the service schedule an email with csv extract.
4 Replies
- parry2kSuper User
Anonymous did you checked this link Export and email a report with Power Automate - Power BI | Microsoft Docs
Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
- AnonymousNot applicable
I did, but that just seems to give an option for a PDF, not a CSV.
- bcdobbsCommunity Champion
I've not tried the power automate route.
If you have/can get a premium per user licence or have premium capacity you can use power bi report builder Power BI Report Builder - Power BI | Microsoft Docsto create a very basic table report. Then direct in the service schedule an email with csv extract.
- parry2kSuper User
Anonymous here are the details of RestAPI that you can use to export to file as CSV
Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.