How to avoid Google analytics limits?

[Anonymous]

Hi,

With a growing number of reports, I faced GA limits - so it becomes impossible to refresh all the reports on the same day (too big data).

Does anyone know the better way to avoid that (sorry, maybe my assumptions are too stupid, I'm quite new in this area):

- Learn and use R or Phyton to connect to GA App without using a build-in connector?
- Use an external DB (like AWS, I know that Azure would be preferable in this case but my company against for it) - import data into DB and then use SQL?
- Something else?

Thank you in advance.

[v-lili6-msft]

hi  @Anonymous 

To my knowledge, this is designed by default in power bi.

 "Import data into DB and then use SQL" maybe a great solution, you could have a try.

Regards,

Lin

[amitchandak]

@Anonymous , Not very clear. But I think that limit is on the ID and from Google. so whatever medium you use it will limit.