Export the report in csv automatically

[nareshupadhyay]

Hi Team

Need your help. I have created a report and published it to service. 

Now I need to export the report data to csv formate and how I can automate this job. Can someone please help me on this issue.

Thanks

Naresh

[v-zhangti]

Hi, @nareshupadhyay 

You can export the data in the Power BI dashboard to a CSV file.

For details, please refer to this link: Export data from a Power BI visualization - Power BI | Microsoft Docs

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nareshupadhyay]

@v-zhangti : I can export the data in csv file manully but I am looking for option to do so automatically.

[nareshupadhyay]

Thanks for your reply! got your point. Is there any way, I can export using Power Automate.

I am able to add Power Automate visual but it is on click only. I am unable to schedule that.

[GilbertQ]

Hi @nareshupadhyay 

As far as I know that is currently not possible 

[GilbertQ]

Hi @nareshupadhyay 

By default Power BI is a visual reporting tool and not an export tool.

If you want to export data you could look at paginated reports and create a report subscription where it send the data via a CSV

Subscribe to paginated reports in the Power BI service - Power BI | Microsoft Docs

[nareshupadhyay]

it would require a Premium license. Can I create and publish paginated report with Power Bi Pro license?