The CData Power BI Connector for Google Analytics is built on top of an ODBC driver. This section discusses how to install the connector, create a DSN, and connect from Power BI.

Installing the Connector

Installing the Connector is a step-by-step guide for how to manage the installation process.

Creating a Data Source Name (DSN)

Creating the Data Source Name describes the process to authenticate and connect to Google Analytics.

Google Analytics Version Support

The connector supports both Universal Analytics and Google Analytics 4 APIs. The connector provides a relational view of the Google Analytics profiles in your Google account or across your Google Apps domain. The connector includes tables that contain often-used dimensions and metrics as columns; additionally, you can customize the table schemas or write your own to combine any valid set of dimensions and metrics. The connector exposes the columns available through the Google Analytics Management API (Universal Analytics), the Google Anlytics Core Reporting API (Universal Analytics), the Data API (Google Analytics 4) and the Admin API (Google Analytics 4). You must enable these APIs by creating a project in the Google Developers Console. See "Connecting to Google Analytics" for a guide to creating a project and authenticating to the APIs.

For an introduction to Visualizing Data using the CData Power BI Connector for Google Analytics.