Power BI Export data > Flow/Power Automate > SFTP

Hi there,   Has anyone managed to automate the export data function using Flow/Power Automate. My workplace is looking to generate the file to land in a SFTP to upload into another system.