Using an ODBC driver on the on prem gateway

[Anonymous]

Hi,

We have set up an odbc driver to connect to Sage 50 .

The driver is setup on the gateway server.

How do we in the PBI desktop, connect to the odbc driver on the on prem gateway.

Thanks

Chris

[johnt75]

You need to install the ODBC driver on your local computer as well and connect using that. You can then map that connection to the ODBC driver on the gateway when you publish into the Power BI service