GA4 Connector - Stuck at evaluating when refresh

[polman4]

Hello,

I'm running the new version of google analytics connector that supports GA4.

I'm running the following code:

let
    Source = GoogleAnalytics.Accounts([Implementation="2.0"]), 
    #"accounts/504700" = Source{[Id="accounts/504700"]}[Data],
    #"properties/383621137" = #"accounts/504700"{[Id="properties/383621137"]}[Data],
    #"properties/1" = #"properties/383621137"{[Id="properties/383621137"]}[Data],
    #"Added Items" = Cube.Transform(#"properties/1",
        {
            {Cube.AddAndExpandDimensionColumn, "date", {"date"}, {"date"}},
            
            {Cube.AddAndExpandDimensionColumn, "customEvent:nextweb_c_author", {"customEvent:nextweb_c_author"}, {"nextweb_c_author"}},
            {Cube.AddAndExpandDimensionColumn, "customEvent:nextweb_c_kava", {"customEvent:nextweb_c_kava"}, {"nextweb_c_kava"}},
            {Cube.AddAndExpandDimensionColumn, "customEvent:nextweb_c_main", {"customEvent:nextweb_c_main"}, {"nextweb_c_main"}},           

            
            {Cube.AddAndExpandDimensionColumn, "customEvent:nextweb_c_pagesource", {"customEvent:nextweb_c_pagesource"}, {"nextweb_c_pagesource"}},
            {Cube.AddAndExpandDimensionColumn, "customEvent:nextweb_c_site", {"customEvent:nextweb_c_site"}, {"nextweb_c_mnextweb_c_site"}},
            {Cube.AddAndExpandDimensionColumn, "customEvent:nextweb_c_sub", {"customEvent:nextweb_c_sub"}, {"nextweb_c_sub"}},
            
            {Cube.AddMeasureColumn, "screenPageViews", "screenPageViews"},
            {Cube.AddMeasureColumn, "eventCount", "eventCount"}
        }),
    #"Filtered Rows" = Table.SelectRows(#"Added Items", each [date] > #date(2023, 7, 3)),
    #"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each ([nextweb_c_pageuid] <> "" and [nextweb_c_pageuid] <> "(not set)"))
in
    #"Filtered Rows1"

The problem is that when i add the following line:

{Cube.AddAndExpandDimensionColumn, "customEvent:nextweb_c_pageuid", {"customEvent:nextweb_c_pageuid"}, {"nextweb_c_pageuid"}},

and i try to refresh it always gets stuck at "Evaluating"

The above custom dimension just has numbers in it. Nothing special.

Any help would be appreciated.

Kind regards,

Grigoris

[LukeHe]

This forum helpful as ever. Last post over a year ago. No useful info on why this is happening and how to stop it happening:

Stakeholders don't care that you're forced to watch a never ending spinny wheel. They just want their dashboard. 

[polman4]

I also tried to run a very simple query but it gets stuck also.

    #"Added Items" = Cube.Transform(#"properties/1",
        {
            {Cube.AddAndExpandDimensionColumn, "customEvent:nextweb_c_pageuid", {"customEvent:nextweb_c_pageuid"}, {"nextweb_c_pageuid"}},
            {Cube.AddMeasureColumn, "eventCount", "eventCount"}
        }),
    #"Filtered Rows1" = Table.SelectRows(#"Added Items", each ([nextweb_c_pageuid] <> "" and [nextweb_c_pageuid] <> "(not set)"))
in
    #"Filtered Rows1"

[polman4]

The longest i have waited is 15 hours! Still evaluating and no change 😞

[lbendlin]

Define "always gets stuck" - how long have you been willing to wait for that metadata refresh phase to complete?