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.

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.
   

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:

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.

• Related Articles

• Using ODBC Drivers with Power BI Online

  Power BI Online supports working with ODBC drivers, but to ensure proper functionality—especially for scheduled data refresh—you need to configure the setup correctly. Make sure the Power BI Data Gateway is installed on the same computer where the ...

• Setting up a Connection to ODBC in Delphi Using Devart ODBC Driver

  This guide will walk you through the steps of setting up a connection to an ODBC driver in Delphi. We'll use ODBC Driver for Salesforce as an example. Prerequisites: Devart ODBC Driver for Salesforce installed on your machine. A Salesforce account ...

• Setting up a Connection to QuickBooks Desktop Using Devart ODBC Driver

  This knowledge base article provides step-by-step instructions on how to set up a connection to QuickBooks Desktop using the Devart ODBC Driver. Following these steps will help you successfully connect to QuickBooks Desktop and retrieve your ...

• Setting Up MongoDB Atlas and Connecting via Devart ODBC Driver

  This article will guide you through the process of setting up MongoDB Atlas, creating a cluster, configuring access, obtaining the connection string, and connecting to MongoDB Atlas using the Devart ODBC Driver for MongoDB. 1. Creating a Cluster in ...

• How to Work in Power Query Using ODBC Driver

  1. Connect to an ODBC Source In Power BI Desktop, go to the Home tab and click on Get Data to connect to an ODBC source. From the list of available connections, select the DSN connection that you created in the ODBC Administration tool. You can learn ...