Forum Discussion
Google ANalytics 4 Broken connector
Hi Anonymous ,
You mentioned that 'getting a very low amount of data succeeds, but larger queries fail.' Have you considered the approach of 'narrowing the query scope and performing multiple queries instead of a single large-scale query'? This might help reduce the complexity of individual queries and improve their success rate.
Maybe this link will help you a lot:
Power Query Google Analytics connector - Power Query | Microsoft Learn
Best Regards,
Bof
Hi, getting subsets of that can theoretically maybe work, but practically not. Sometimes even one day of data is giving an error, depending on the dimensions. It's just not sustainable. And I would be forced to constantly modify the code.
Also the page you link does use the profiler which I tried but I can't find the API call. Besides that, I still believe that it's broken since even little amount of Data, far far below the GA limits which I know and I use on other tools, throws an error
Thanks but this approach cannot work as it's not scalable. You would need to constantly maintain each piece of data and change the date filter,whenever new data is coming. Besides that, it's not properly documented how to add a date filter, so by default it takes all the data.
