Forum Discussion

richardurrutia's avatar
richardurrutia
New Member
5 years ago
Solved

Google Analytics - data gap

Hello, I'm using the Google Analytics connector on powerbi and I have some issues with the data on powerbi. I always have a gap between the data that I see on Google Analytics and the data imported ...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi richardurrutia 

 

Currently Google Analytics connector in Power BI does not have the functionality to specify date range dimension directly from the UI. So, Power BI sends the entire date range from the earliest possible to the current date. When date range is large, the queried data may be different. 

 

In order to resolve this, you can connect to Google Analytics first. Then in Power Query Editor, select date column and apply a date range filter to it. This would add a date range explicitly in Power BI. This queries GA API for only the selected date range, and should pull the data within the time interval specified.

 

For example,

#"Filtered Rows" = Table.SelectRows(#"Added Items", each [Date] >= #date(2019, 9, 1) and [Date] <= #date(2019, 9, 30))

 

Hope this helps.

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.