Forum Discussion

zskolnik's avatar
zskolnik
Frequent Visitor
7 years ago
Solved

Google Analytics Sessions Syncing Issues

Hi everyone,   I'm trying to pull in information from Google Analytics to PBI. Specifically, I'd like the number of sessions from google/organic source/mediums.   I've tried a few different ways ...
Need Help
  • zskolnik's avatar
    zskolnik
    7 years ago

    v-juanli-msft 

     

    Ended up figuring this one out! Finally got it after reading some PBI forums of something completely unrelated.

     

    I realized I was pulling Sessions alongside a bunch of other fields (source, users, hits, etc), which was causing me to lose out on rows that didn't have associated values. For example, if a session had no hits and I was pulling both, then it wouldn't show up as a session.

     

    By pulling only sessions and the date, or users and the date, etc. I was able to link up GA and PBI. I suppose that's a beginner's mistake but very happy to have found the solution!


    Zev

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi zskolnik 

It seems the left one from Google Analytics is a visual instead of original dataset.

Please check if any other filter apply to it.

 

Best Regards
Maggie

zskolnik's avatar
zskolnik
Frequent Visitor
7 years ago

v-juanli-msft 

 

Ended up figuring this one out! Finally got it after reading some PBI forums of something completely unrelated.

 

I realized I was pulling Sessions alongside a bunch of other fields (source, users, hits, etc), which was causing me to lose out on rows that didn't have associated values. For example, if a session had no hits and I was pulling both, then it wouldn't show up as a session.

 

By pulling only sessions and the date, or users and the date, etc. I was able to link up GA and PBI. I suppose that's a beginner's mistake but very happy to have found the solution!


Zev