Forum Discussion
Sending Power BI Table Data as a CSV File via Email with Power Automate
How do I create a flow to automatically create a csv file from a dax query table and send to my email on a weekly basis?
2 Replies
- Kishore_KVN
Solution Sage
Hello csbrit ,
Its a big process to explain here but if you have idea about both Power BI and Power Automate, then I can give you some outliner steps to create the same.
It requires combination of Action and Triggers.
Trigger: Recurrence (to run weekly)
Action: Power BI - List rows present in a table
Action: Compose (to convert data to CSV)
Action: Create file (SharePoint)
Action: Office 365 Outlook - Send an email (attach the CSV file)
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
This step is not available as an action for Power BI: List rows present in a table. I wanted to create this flow using the Power BI action step: Run a query against a dataset.
