Forum Discussion

polman4's avatar
polman4
Helper I
3 years ago

GA4 Connector - Stuck at evaluating when refresh

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

 
Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

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

  • polman4's avatar
    polman4
    Helper I
    3 years ago

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

  • polman4's avatar
    polman4
    Helper I
    3 years ago

    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"

     

  • LukeHe's avatar
    LukeHe
    Regular Visitor
    2 years ago

    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.