Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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:

TiaH_0-1653659632354.png


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

TiaH_1-1653659693338.png

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

TiaH_2-1653659804389.png


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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.