Forum Discussion
External Data Stream issues
Hello LeahS,
Thank you for your follow‑up.Since you're using the built-in Google Analytics (GA4) connector, the request and response handling is managed internally, so you won’t have direct control over how the API payload is structured.
The error you’re encountering typically occurs when the combination of dimensions, metrics, or query scope results in a complex response that Power Query is unable to process correctly.
You may try the following:
- Reduce the number of dimensions and metrics selected
- Limit the date range further, even if already filtered
- Avoid high-cardinality fields (e.g: page path, event name, user-level dimensions)
- Split the query into smaller queries (for example, by date ranges or metric groups)
For more information on connecting to Google Analytics data using the built‑in connector, please refer to the official documentation below:
Best regards,
Ganesh Singamshetty
Since the source is G4 (google analytics) how would I go about doing that? I'm using the built in API connector.
Community SupportHello LeahS,
Thank you for your follow‑up.
Since you're using the built-in Google Analytics (GA4) connector, the request and response handling is managed internally, so you won’t have direct control over how the API payload is structured.
The error you’re encountering typically occurs when the combination of dimensions, metrics, or query scope results in a complex response that Power Query is unable to process correctly.
You may try the following:
- Reduce the number of dimensions and metrics selected
- Limit the date range further, even if already filtered
- Avoid high-cardinality fields (e.g: page path, event name, user-level dimensions)
- Split the query into smaller queries (for example, by date ranges or metric groups)
For more information on connecting to Google Analytics data using the built‑in connector, please refer to the official documentation below:
Best regards,
Ganesh Singamshetty