export the report automatically from PowerBI

[pang22]

Hello,

I have published the Powerbi report to My workspace.

Is there any method to auto export the detail table data to excel automatically daily and send the excel via email? 

[christinepayton]

Yes, you can use Power Automate for this. If it's not a paginated report, you can use the action "query a dataset" - I did a tutorial on it here - in the example it's embedded in an email, but you can simply drop the query results into a CSV and attach it to the email instead. 

[rubayatyasmin]

Hi, @pang22 

use Power Automate cloud flow. and to export data to excel you can use BI helper. 

Export and email a report with Power Automate - Power BI | Microsoft Learn

Solved: PowerBI Export - Scheduling and Send Export to Exc... - Microsoft Fabric Community