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
Super UserHi LeahS
It would help to share a bit more detail about the source behind the external stream, for example whether it is an API, database, file-based source, or something going through a gateway. It would also be useful to know whether this is happening to one stream only or to multiple streams, and whether anything changed recently in the source, credentials, or gateway.
If the refresh is consistently getting stuck on "Evaluating," I would check the refresh history first, validate the stream independently, and review whether there were any recent schema or connectivity changes upstream. If nothing obvious changed and the issue started suddenly, it may also be worth checking for a service-side incident and opening a support ticket with the relevant refresh timestamps and logs.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly