GA4 has a Power BI connector, but getting it working means configuring a data gateway, walking through an OAuth setup in Power BI Desktop, and working within what the connector exposes. API Import takes a different path: describe what you want in plain English, and the data lands in a Power BI dataset directly — no gateway, no configuration file, no manual export.
Connect Google Analytics
Open API Import from the Extensions menu in any Google Sheet and select Google Analytics 4 from the connector list. Sign in with Google — one click, same account that owns the GA4 property — then select the property you want to pull from.
Describe What You Want
Type what you need in plain English:
"Get sessions, users, bounce rate, and average session duration by page for the last 30 days."
API Import maps this to the GA4 Data API, applies the date range, and returns a flat table — one row per page:
| Page | Sessions | Users | Bounce Rate | Avg Session Duration |
|---|---|---|---|---|
| /home | 12,450 | 9,830 | 42% | 1m 54s |
| /pricing | 4,210 | 3,670 | 38% | 2m 11s |
| /blog | 3,980 | 3,540 | 61% | 0m 47s |
The data is unsampled. GA4 Explorations sample above 100,000 rows; the GA4 Data API returns exact numbers regardless of volume.
Select Power BI as the Destination
In the Write to dropdown, select Power BI instead of Google Sheets. Sign in with your Microsoft account once via Azure AD, then choose your Workspace, dataset name, and table name. API Import creates the dataset automatically if it doesn't exist. Click Run — the rows land in Power BI in seconds.
Schedule It
Open Schedule, pick a daily or weekly cadence, and set your timezone. After that, the workflow runs on its own: GA4 data refreshes in Power BI without any manual step. Enable Clear before write for a rolling 30-day window, or leave it off to accumulate a growing history.
The same flow works for any API — Google Analytics is just the example. Shopify orders, HubSpot deals, GitHub issues, or any REST API your team uses can follow the same path into Power BI.