Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |