Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Pikachu-Power
Post Prodigy
Post Prodigy

Google Analytics Different Results

‎06-15-2021 05:30 AM

Hi all,

 

I have connected Power BI directly with Google Analytics and noticed some strange behaviour in the results:

 

I have for example 6 Million Sessions. When I expand for the dimension time I still have 6 Million Sessions. When I expand for the dimension Device Category I suddently get 3.5 Million Sessions. Can someone explain this?

 

Many thanks.

Labels:
Message 1 of 6
476 Views
0
5 REPLIES 5
Pikachu-Power
Post Prodigy
Post Prodigy

‎07-08-2021 12:18 AM

No one who can confirm this behavior? 🤔

Message 6 of 6
320 Views
0
parry2k
Super User
Super User

‎06-15-2021 09:22 PM

Thanks, @amitchandakfor calling out.

 

hey @Pikachu-Power, if you pulling data from Google cube and not doing any transformation then it is something that is provided by the cube, not sure there is anything on the power bi side.

 

Are you doing any transformation after connecting to the cube?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 3 of 6
391 Views
0
Pikachu-Power
Post Prodigy
Post Prodigy
In response to parry2k

‎06-15-2021 11:47 PM

hi parry2k,

 

thanks for your reply. i do not any transformations. just pulling the data from google cube master: dimensions date, device category and values sessions. i have 3.5 million sessions... but when i just pul date and sessions i get 6 million.

 

do i need to do some transformations? normally google gives me one table with three columns. 

Message 4 of 6
381 Views
0
Pikachu-Power
Post Prodigy
Post Prodigy
In response to Pikachu-Power

‎06-16-2021 01:52 AM

Maybe I have wrong understanding of cube models:

 

Unbenannt.PNG

 

In the Power Query Editor: When I order descending i get other values as choose this year and than order descending (these are the right values i want). Maybe someone can explain this behaviour.

Message 5 of 6
369 Views
0
amitchandak
Super User
Super User

‎06-15-2021 06:21 AM

@parry2k , can you help with this



Message 2 of 6
431 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All