cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sreetejreddy
Helper I
Helper I

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

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

3 REPLIES 3
v-polly-msft
Community Support
Community Support

Hi @sreetejreddy ,

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.

sreetejreddy
Helper I
Helper I

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

Anand24
Super User
Super User

Hi @sreetejreddy ,

 

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. 

PBI_SuperUser_Rank@1x.png  

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

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!