Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
Solved! Go to Solution.
The issue is now resolved, I just waited for approx an hour and the error stopped.
The issue is now resolved, I just waited for approx an hour and the error stopped.