URL Fetch Limits Error

[pdhebar-ci]

Has anyone run into URL Fetch Limits with the connector?

We have a large number of reports through GDS and we hit the fetch limit frequently however we have limited the call numbers. Are there other factor that Google decides to use to restrict? Is there a transfer rate limit per second for example?

[alex-wenzel]

I am receiving ThrottlingException errors frequently from the report I built with the connector. The report also seems to be pulling new data constantly even though I'm not editing any charts and the connector says the data freshness interval is 12 hours. I'm also trying to find a way to keep this from happening. I'm sharply limiting the date range for the data I'm showing in the report, making it any smaller would make the report somewhat useless in my opinion.

I don't know if this is an issue with the connector or data studio, but I thought my experience might be relevant. @pdhebar-ci have you found a solution to this issue?

[rdgrocha]

I am receiving the same ThrottlingException errors, have you been able to solve this without limiting too much the data, @alex-wenzel ?

[alex-wenzel]

No @rdgrocha, from my recollection, I ended up creating an intermediate script that aggregated data into a Google Sheet and then pulled it into Data Studio from there.

[rdgrocha]

I was trying to avoid Google Sheets but I don't think a have choice anymore. Can you share the script you used?

[kennon8616]

Hi everyone,

I'm getting the same error 'ThrottlingException' with Google Data Studio and an Athena Connector, someone found a solution that avoid the use of a Google Sheet to collect the data?

Thanks