Can I set-up a Gateway in Power BI Service when using Get Data in Power BI Report builder to connect

Hi AnupamaSemwal99,

If you want to connect to Snowflake through a gateway using Power BI Report Builder, you should switch from Get Data - Snowflake (native connector) to ODBC. The native connector always uses a cloud-to-cloud connection and does not go through the gateway, but ODBC connections can be routed via the On-Premises Data Gateway. To set this up, install the gateway and the Snowflake ODBC driver on the same server, then create an ODBC DSN using the settings you will use in Report Builder. In Power BI Service - Manage Gateways - Add Data Source, select ODBC as the type and enter the DSN name and authentication details matching the DSN on the gateway server. After adding the data source, publish your paginated report (RDL), and in the dataset/data source settings, you should see the ODBC gateway entry to map your report to the gateway connection.

It's important that the DSN name in the gateway matches the one used in Report Builder, or the mapping won’t show up. Also, ensure the credentials match what Snowflake requires. Once mapped, report refreshes and executions will go through the gateway instead of directly connecting cloud-to-cloud. This approach is recommended for enforcing gateway use with paginated reports and Snowflake.

Thank you.