Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

GA4 Connector Stuck evaluating

Hello everyone !

 

I'm trying to load data from Google Analytics 4 onto a dashboard.

 

I try to get the activeUsers by date and country like so : 

 

Cube.Transform(#"properties/1",
{
{Cube.AddAndExpandDimensionColumn, "date", {"date"}, {"date"}},
{Cube.AddAndExpandDimensionColumn, "country", {"country"}, {"country"}},
{Cube.AddMeasureColumn, "activeUsers", "activeUsers"}
})

 

But weirdly, the evaluation never stops.

 

I sent a request directly through the Google Data API, and it worked with no problems. 

 

I have now been waiting for 7 hours, and it still doesn't stop. 

 

I also tried loading with different Dimensions, and it works flawlessly. 

It is as if the combination between country and date is throwing PowerBI in a loop. 

 

Did you ever experience that ? 

3 Replies