Forum Discussion

kamijaja's avatar
kamijaja
New Member
7 years ago
Solved

Avoid sampling Google Analytics connector

Hi,    I have read some threads about sampling data with the connector and there are some ways how to avoid it mentioned here let Source = GoogleAnalytics.Accounts(), #"1" = Source{[Id="99...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

For everyone else struggling with this...

I just wanted to add that v-chuncz-msft solution doesn't affect the GA connector data. For more detailed explanation watch this video (solution starts at 9min).

As for me, I only needed last month's data so this formula worked like a charm:

 

#"Filtered Rows" = Table.SelectRows(#"Added Items", each Date.IsInPreviousNDays([Date], 31))

 

 

Also, to check if the GA data is being sampled for the desired period please use https://ga-dev-tools.appspot.com/query-explorer/

Good luck!