Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I ran into an issue and I'm hoping someone here can help. I pulled some data from GA in PBI and the numbers aren't lining up. When I pull sessions per day I get an accurate number, when I pull sessions per gender, device category, age, and browser the numbers are severely reduced. Can anyone explain this? Can anyone help me get around this?
When I look at the GA platform, I'm able to validate that the metric per day is correct.
Date | Sessions | Age | Gender | Browser | Device Category | Date | Sessions | Organic Searches | New Users | Users | ||
Wednesday, June 13, 2018 | 20779 | 45-54 | female | Chrome | desktop | Wednesday, June 13, 2018 | 618 | 168 | 196 | 281 | ||
45-54 | male | Chrome | desktop | Wednesday, June 13, 2018 | 505 | 196 | 281 | 365 | ||||
35-44 | female | Chrome | desktop | Wednesday, June 13, 2018 | 393 | 168 | 168 | 337 | ||||
25-34 | female | Chrome | mobile | Wednesday, June 13, 2018 | 337 | 140 | 253 | 281 | ||||
25-34 | female | Chrome | desktop | Wednesday, June 13, 2018 | 1404 | 421 | 589 | 982 | ||||
25-34 | male | Chrome | desktop | Wednesday, June 13, 2018 | 421 | 112 | 196 | 309 |
Hi, @Anonymous
Please recheck whether there are other unknown age groups, browser, device category data is not included.
Best Regards,
Community Support Team _ Eason
From my investigation. GA does not report "unknown" or "no data" resulting in diminished metrics when measuring across dimensions that have no data. With that said, my bst practice has been to bring in data strategically:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |