Forum Discussion
Berl21
Helper III
2 years agoGoogle Analytics Connectior Beta (2.0) - error when looking for user data starting 2022
Hi, thanks for providing the new connector, I am looking forward to using it a lot. There is an issue with the date column. I am aiming to make an easy visual, showing the KPI total users by ...
clukaych
2 years agoFrequent Visitor
I am having the same issue and have discovered a usable workaround until a more permanent solution is implemented, though it won't apply to all use cases.
You can pull by 'date' and 'year' and then filter only by 'year' and it won't throw an error. That should give the desired granularity and, once combined that with some creative filtering (either 'begins with' or converting to a number then filtering), you can get it to filter down to a more manageable date range. I ended up using this step below to get all dates within the past 10 years:
= Table.SelectRows(#"Changed Type", each [year] > (Date.Year(DateTime.Date(DateTime.FixedLocalNow()))-10))
Hope that helps!