How to export/download a Power BI report data as an excel/csv to a FTP path?

[Anonymous]

Hi,

We want a report's data to be exported or downloaded to an FTP path as an excel/csv from Power BI.

We tried useing Power Automate in Power BI, but it is not coming through.

Please suggest.

Warm Regards,

Sreetej

[v-rongtiep-msft]

Hi @Anonymous ,

This is currently not supported.You can use Microsoft Flow to automate the extraction of your data from the FTP server to your OneDrive or SharePoint.

Maybe you will have another solution by read these post :

https://www.cdata.com/kb/tech/ftp-odata-power-bi.rst
https://community.powerbi.com/t5/Desktop/Connect-Power-BI-to-FTP/m-p/506592#M236579

Best Regards

Community Support Team _ polly

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

[Anonymous]

I need the data from the report to get downloaded to a FTP location.

[Anand24]

Hi @Anonymous ,

There is still no direct functionality to export Power BI reports(.pbix files) to Excel format. 

You might consider using Power BI Report Builder(.rdl files) which gives an out-of-the-box functionality to excel export.

You can also look at this post for help. 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn