Postgresql – How to copy view from MS SQL to PGSQL

I have a MS SQL Server running in a different country (hence VPN, hence long round trip delay) and delveloping a PowerQuery model on a view located on that MS SQL Server.
Everytime I change something in the model, it reloads the view which is consuming a lot of time.
I'd like to:

1. setup a local PostGreSQL Server on my Mac (done already)
2. mirror the MS SQL View data into a PostgreSQL Database
3. connect the powerQuery to the local PostgreSQL Server (easy)

I'm struggling with "2", mirror the content of a view into the PostgreSQL server without using direct SQL (TCP1433) which I cannot use.

How can I mirror the data to the PostgreSQL Server using ODBC only?

BTW: I have no direct access to the MS SQL Server apart from the ODBC connection

EDIT: If required, I can also install a MS SQL Express Edition if that helps in any way. Thanks