Forum Discussion

SKamp's avatar
SKamp
Regular Visitor
4 years ago

Google Analytics and Power BI

When trying to connect Power BI Desktop to our Google Analytics, we are finding that we can't change the selected date ranges of data being pulled in.  I believe that this is causing the data to be sampled and we are not seeing all of our campaigns. 

Any thoughts on how to bypass the thrid party connector or how to change the date selection so that we can see all of our campaigns? Or any other ideas on why we would only see ~20 campaigns in Power BI but ~ 1,000 in GA? 

Thanks!

Need Help

5 Replies

  • cassidy's avatar
    cassidy
    Icon for Power Participant rankPower Participant
    4 years ago

    This may or may not be helpful, but I gave up my fight with Google Analytics and BI and started converting everything to pulling from Google BigQuery instead.  With BigQuery, you can use normal SQL statements for the most part and the data won't be sampled.  This assumes you have GA feeding BigQuery.

     

    The drawback is that the prior day's data is often not ready until late morning and at random times.

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi SKamp ,

     

    When date ranges are very large, Google Analytics will return only a subset of values. To make sure that the data you're seeing is the same as you would get from Google Analytics, you can execute the query yourself in Google's interactive tool. To understand what data Power Query is retrieving, you can use Query Diagnostics to understand what query parameters are being sent to Google Analytics.

     

    You can use the process described in this document to understand what dates are being retrieved.

    https://docs.microsoft.com/power-query/connectors/googleanalytics#validating-unexpected-data 

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.