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.
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.rsthttps://community.powerbi.com/t5/Desktop/Connect-Power-BI-to-FTP/m-p/506592#M236579
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.
I need the data from the report to get downloaded to a FTP location.
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.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!