Connect GA4 to Power BI: BigQuery vs Connector

The two main ways to connect GA4 to Power BI are the free BigQuery export, which Power BI reads from BigQuery, and third-party connectors built on the GA4 Data API. There is no official Microsoft GA4 connector. For serious web analytics reporting the BigQuery export is the better choice, because it gives raw, unsampled, event-level data with full granularity, whereas connectors return aggregated and potentially sampled data. This guide compares both and explains when each makes sense.

BigQuery export versus connector

GA4 BigQuery export. GA4 can stream or batch its raw event data into BigQuery at no licensing cost (you pay BigQuery storage and query). You then connect Power BI to BigQuery. This gives you every event with full parameters, no sampling, and complete control over how sessions, users and conversions are defined. It is the route for anything beyond simple dashboards.

Third-party connectors. Several vendors offer GA4 connectors built on the GA4 Data API. They are quick to set up and return familiar report-style metrics, but they inherit the Data API's limits: aggregated data, potential sampling on large or complex queries, cardinality limits and a fixed set of dimensions and metrics. Fine for a quick summary, limiting for deep analysis.

For most organisations that care about accurate, flexible web analytics, the BigQuery export wins. Use a connector only when you need a fast, simple view and can accept aggregation and sampling. And if you are still deciding whether GA4 reporting needs Power BI at all, our Power BI vs Looker Studio comparison covers when Google's free tool is the better fit.

Setting up the BigQuery route

The practical steps are: enable the GA4 BigQuery export in GA4 admin, let event data accumulate, then connect Power BI to BigQuery using the native connector. Because GA4's raw export is event-level and deeply nested, the real work is transforming it into a tidy reporting model. Best practice is to build clean, flattened views or tables in BigQuery (sessions, users, conversions, traffic sources) and have Power BI read those, rather than parsing nested event JSON inside Power Query. This keeps refreshes fast and the model maintainable. See our data integration and warehousing approach for how we structure this.

Web analytics metrics worth modelling

Once the data is clean, prioritise the metrics that drive decisions:

• Sessions, users and new versus returning users.
• Engagement rate and average engagement time, GA4's core engagement signals.
• Conversions and conversion rate, by event and by channel.
• Acquisition by source, medium and campaign, the basis for marketing analysis.
• Landing page and content performance.
• Funnels and path analysis, where the raw export really pays off versus a connector.

Model these over a star schema with date, channel, page and device dimensions so measures stay reusable and queries stay fast.

Common pitfalls

Parsing raw events in Power Query. The GA4 export is nested and large. Transforming it inside Power BI is slow and brittle; do the flattening in BigQuery.

Sampling surprises. If you rely on a connector and your numbers look smoothed or capped, sampling or cardinality limits are likely the cause. The export avoids this.

Definition drift. GA4's session and conversion definitions differ from older analytics tools and from ad platforms. Document your definitions so the dashboard is internally consistent.

Cost neglect. BigQuery query cost is usually modest, but unpartitioned queries over the full event table can add up. Partition by date and query views, not raw tables. Confirm current Google Cloud pricing.

Getting it done well

A dependable GA4 model in Power BI comes from clean BigQuery transformation and disciplined metric definitions, not from the connector you pick. Our Power BI consultants in the UK build governed web analytics models on the GA4 BigQuery export, and engagements usually begin with a fixed-scope Trusted Numbers Review (£2,000–£4,000 as of 2026, confirm current pricing). If you are blending paid media into the same view, see our guide on connecting Google Ads to Power BI.

If the concern starts before Power BI, use the Google Analytics audit powered by Growth Radar. It checks the live properties, data freshness, conversions and search evidence before a reporting build is chosen.

Turn GA4 events into web analytics you can trust and act on. Run the free Growth Radar Scan to find the first measurement gap.