Forum Discussion

LeahS's avatar
LeahS
Frequent Visitor
5 months ago
Solved

External Data Stream issues

On Monday, I was able to refresh my dashboards with external streams without any issues.  Starting yesterday, the external data streams get stuck on "Evaluating".  Does anyone have any ideas on what ...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    4 months ago

    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

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
5 months ago

Streaming dataset capacity throttling.

Check service health dashboard. Restart stream endpoint. If persists, duplicate dataset (new streaming dataset sidesteps stuck evaluation). Common after capacity limits hit.

LeahS's avatar
LeahS
Frequent Visitor
5 months ago

That is helpful.  When I try to limit the dates, which should make the load smaller, I get the following error Expression.Error: The field 'errors' of the record wasn't found.
Details:
code=400
message=Invalid JSON payload received. Message too deep. Max recursion depth reached for key ''
status=INVALID_ARGUMENT

 

Any ideas on how to fix?