Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Google analytics - OLE DB or ODBC error: [Expression.Error] The field 'errors' of the record wasn't

I've connected my dashboard to Google Analytics, I require the unquie pageviews for specific pages for the last 14 months. I wasn't getting an error, now suddenly I am when nothing has changed, I get the following:


Initially, when loading the data it does pull through errors:

But I was able to apply the remove error step, removing the Page error, and filter to the last 14 months  


But Now I'm seeing the "OLE DB or ODBC error" message preventing me from refreshing or applying additional transformations, and I don't know why

If it helps, the MDX Query:

 

 

let
    Source = GoogleAnalytics.Accounts(),
    #"XXXXXXXX" = Source{[Id="XXXXXXXX"]}[Data],
    #"UA-XXXXXXXX-1" = #"XXXXXXXX"{[Id="UA-XXXXXXXX-1"]}[Data],
    #"YYYYYYYY" = #"UA-XXXXXXXX-1"{[Id="YYYYYYYY"]}[Data],
    #"Added Items" = Cube.Transform(#"YYYYYYYY",
        {
            {Cube.AddAndExpandDimensionColumn, "ga:pagePath", {"ga:pagePath"}, {"Page"}},
            {Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},
            {Cube.AddMeasureColumn, "Unique Pageviews", "ga:uniquePageviews"}
        }),
    #"Removed Errors" = Table.RemoveRowsWithErrors(#"Added Items", {"Page"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Errors", each Date.IsInPreviousNMonths([Date], 14))
in
    #"Filtered Rows"

 

 


Thanks in advance

  • Anonymous's avatar
    Anonymous
    4 years ago

    The issue is now resolved, I just waited for approx an hour and the error stopped.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    The issue is now resolved, I just waited for approx an hour and the error stopped.