Setting up a Connection to Power BI Online Using Devart ODBC Driver

Setting up a Connection to Power BI Online Using Devart ODBC Driver

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

  1. Open ODBC Data Source Administrator on your PC.
  2. Add a New DSN Connection.
A screenshot of a computer

Description automatically generated, Зображення

Step 2: Set Up On-Premises Gateway

Install On-Premises Gateway:
  1. Download and install the On-Premises Data Gateway from the Power BI website if you haven't already.
  2. Follow the installation instructions to complete the setup.
Configure the Gateway:
  1. During the installation process, create a gateway and assign a name to it, such as "devart15".
  2. Make sure to install the gateway on the same PC where the Devart ODBC driver is installed.
A screenshot of a computer

Description automatically generated, Зображення

A screenshot of a computer

Description automatically generated, Зображення

Step 3: Verify Power BI Report Settings

Log in to Power BI Online:
  1. Go to Power BI Online and log in with your account.
Navigate to Settings:
A screenshot of a computer

Description automatically generated, Зображення
Click Gateway and cloud connections:
A screenshot of a computer

Description automatically generated, Зображення
Verify the gateway configuration and ODBC source:
A screenshot of a computer

Description automatically generated, Зображення
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.