Forum Discussion

phillipross2000's avatar
phillipross2000
Frequent Visitor
5 years ago
Solved

Google Analytics Not Pulling in Time Data

Hi, I am relatively new to PowerBI - I am looking to build a PowerBI Dashboard connected to our e-commerce website with key stats from Google Analytics. For some reason however, it's only bringing in the aggregate numbers, with no way to filter it by date. Since I'd like to create a time series chart, does anyone know how to bring in date data as well? I've attached a photo of what it looks like. 

 

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI phillipross2000,

    In fact, these fields are defined analysis results from google analytics datasets and you can change them.
    If you want to do custom with visualizations, I'd like to suggest you get data from the underlying dataset, then you can use them to manually create visuals based on data fields with value fields.

    Regards,

    Xiaoxin Sheng

  • ReportGuru's avatar
    ReportGuru
    Post Patron
    2 years ago

    Hi phillipross2000 As a workaround, maybe you can try to test your connection with a 3rd party connector. I currently use windsor.ai's GA connector and I can bring date field from GA, and also I can filter by date on a preview stage in the platfrom before exporting to PBI, so once my data arrives in PBI it is already filtered for the date range I set. In case you wonder, to make the connection first search for the GA connector in the data sources list:

     

     

    After that, just grant access to your GA account using your credentials, then on preview and destination page you will see a preview of your GA fields:

     

     

    There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.