Hi Community,
Like more people within this community, I am struggling with the Google Analytics Reporting API connector. It still looks like we have some kind of sampling in the data, but I cannot verify whether or not this is actually sampling or something wrong with my query. We use the Table.SelectRows method described in this post: https://community.powerbi.com/t5/Desktop/Dynamic-value-in-datatime-QueryFilter/m-p/360343#M162637, to pull in data from 1 week. Sampling in the dataset should not be able to occur for one week worth of data. We do however see a discrepancy between the dataset and the reporting interface for all metrics.
When I try to verify the data in the Google Analytics interface with the data I can pull from the Query Explorer (https://ga-dev-tools.appspot.com/query-explorer/), I see the data matches 100%. Hence, there seems to be something wrong with the connector and/or my query.
My query looks like this:
let
Source = GoogleAnalytics.Accounts(),
#"1" = Source{[Id="XXXXXX"]}[Data],
#"2" = #"1"{[Id="UA-XXXXXX"]}[Data],
#"3" = #"2"{[Id="XXXXXX"]}[Data],
#"Added Items" = Cube.Transform(#"3",
{
{Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},
{Cube.AddAndExpandDimensionColumn, "ga:hostname", {"ga:hostname"}, {"Domain"}},
{Cube.AddAndExpandDimensionColumn, "ga:userType", {"ga:userType"}, {"User Type"}},
{Cube.AddMeasureColumn, "Users", "ga:users"},
{Cube.AddMeasureColumn, "Sessions", "ga:sessions"},
{Cube.AddMeasureColumn, "Pageviews", "ga:pageviews"},
{Cube.AddMeasureColumn, "Bounces", "ga:bounces"},
{Cube.AddMeasureColumn, "Session Duration", "ga:sessionDuration"}
}),
#"combinedData" = Table.Combine({
Table.SelectRows(#"Added Items", each (Date.Year([Date]) = 2019 and Date.WeekOfYear([Date]) = 13))
})
in
#"combinedData"
Hope someone is able to help me out!
