Forum Discussion

ryta's avatar
ryta
New Member
5 months ago
Solved

GA4 vs Power BI: Fixing large session count differences when filtering by hostname and site_family

Hi all, I’m trying to bring sessions and engaged sessions into Power BI using the Google Analytics 4 connector. I have filters in GA4 based on hostname and a custom dimension (e.g., site_family), an...
Need Help
  • RicardoTraNa's avatar
    RicardoTraNa
    5 months ago

    Hey! This is a pretty common GA4 vs Power BI mismatch 🙂

    Try this:

    • Count distinct sessions; 

    • Apply filters at session level; 

    • Use native metrics (sessions, engagedSessions) if possible

    Hope that help! 

Kedar_Pande's avatar
Kedar_Pande
Super User
5 months ago

ryta 

 

Export same filtered period from GA4 UI as CSV. Compare row counts with Power BI import. If CSV matches GA4 but Power BI doesn't, it's connector filter translation issue.

Try BigQuery Export instead - raw data always matches perfectly.