Forum Discussion
Bug in Power Query? Losing records after change order of filtering. Weird puzzle??
I want to report the total visits on webpages for our organization. The data I get from Google Analytics; A total of 190.000 records of page-counts, per site, per day over the last 2 years. However, it seems that 'Power Query' loses records when changing the filtering order. I have applied two filters, in the sequence below (see first printscreen);
First filter [Rijen gefilterd2], each [Date] = #date(2019, 2, 12)
Second filter [Rijen gefilterd], each Text.Contains([Page path level 3], "25480")
figure 1: the good result
when I change the order of the two filters the outcome is wrong, I only get 4 records with different totals.
What is going on????? I don’t understand why I lose records with the same filtering but different sequence. When I delete the two filters, and load the data into power bi and drop it in a table and do the same filtering, I also get the incorrect records.
Is this a bug? Can any one me help to solve this problem. Do I have to report this to Microsoft?
I’m already struggeling for 6 hours on this problem.
2 Replies
- ImkeF
Community Champion
There are limitations on Googles site on how many data the API will deliver (also sampling might take place).
Please check out Ruths videos how she worked around these issues, i.e. here: https://www.youtube.com/watch?v=5bkJCjJK9U0
I believe you have to use a custom connector so that your filters are actually pushed down to the source at Google to reduce the size of the data that counts against your daily limit.
