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 s...
Need Help
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.

  • kymramosrpo's avatar
    kymramosrpo
    Icon for Advocate V rankAdvocate V
    3 years ago

    Hi! Thank you for the suggestion. Can you share with us how to connect to Google BigQuery?

      • kymramosrpo's avatar
        kymramosrpo
        Icon for Advocate V rankAdvocate V
        2 years ago

        Thank you for the reply. Reading my question again I've realized that it's too vague/general.
        I was able to connect to Google BigQuery but I could only access publicly available data:

        I would like to know how can I connect to our data? Is there a similar community for Google Analytics where I can ask raise questions? Thank you!