Forum Discussion
csbrit
2 years agoFrequent Visitor
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?
Kishore_KVN
Solution Sage
2 years agoHello 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!!