Sending Power BI Table Data as a CSV File via Email with Power Automate

[csbrit]

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?

[csbrit]

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.

[Kishore_KVN]

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!!