Power BI export to CSV, email recurrence in Power Automate

[JenniferT]

Hello everyone,

Is there a way in Power Automate to create a flow to have a daily email recurrence sent to a group of people from the data results in Power BI but I want to export the file as a CSV? I am only seeing PDF or PNG and PPTX

[lbendlin · Accepted solution]

In Power Automate run a DAX query against your semantic model.  Convert the result to a CSV table. Store that table as a file in a cloud storage. Create an email and point to that newly created file for the attachment.