In this guide, we will walk you through the process of setting up a connection to Power BI Online using the Devart ODBC Driver. This involves creating a DSN connection, setting up an on-premises gateway, and verifying Power BI report settings.
Step 1: Create a DSN Connection
- Open ODBC Data Source Administrator on your PC.
- Add a New DSN Connection.
Step 2: Set Up On-Premises Gateway
Install On-Premises Gateway:
- Download and install the On-Premises Data Gateway from the Power BI website if you haven't already.
- Follow the installation instructions to complete the setup.
Configure the Gateway:
- During the installation process, create a gateway and assign a name to it, such as "devart15".
- Make sure to install the gateway on the same PC where the Devart ODBC driver is installed.

Step 3: Verify Power BI Report Settings
Log in to Power BI Online:
- Go to Power BI Online and log in with your account.
Navigate to Settings:

Click Gateway and cloud connections:

Verify the gateway configuration and ODBC source:
By following these steps, you have successfully set up a connection between Power BI Online and the Devart ODBC Driver using the on-premises gateway.