How to Connect Power BI to a Data File on SFTP Server?

Hello,
I have a data file stored on an SFTP server, and I need to connect this file to Power BI for reporting purposes. Could anyone suggest the best approach to connect to an SFTP server from Power BI, either directly or through any workaround? I’d also appreciate any guidance on automating the data refresh once the connection is established.

Thanks in advance!