Nightly export of a large PowerBI table (65mb) to a SFTP

Job ID: 37479343

Budget: $30 – $250 USD

We have a PowerAutomate flow which exports a certain table from our Power BI model nightly, however as the table has now grown above 50mb, the method we were using no longer works (giving an error related to chunking).

The objective of this task is to export that table as a CSV file and upload it to a SFTP (details are already in Power Automate, however you do not have to use Power Automate to achieve the outcome - any solution that works is fine).
Related categories: Power BI Power Automate