Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I created three different queries that extract data from Google Analytics using the Google Analytics built-in connector:
let Source = GoogleAnalytics.Accounts(), #"Step 1" = Source{[Id="XXXXXXX"]}[Data], #"Step 2" = #"Step 1"{[Id="XX-XXXXXXX-XX"]}[Data], Data = #"Step 2"{[Id="XXXXXXXXX"]}[Data], Result = Cube.Transform(Data, { {Cube.AddMeasureColumn, "Sessions", "ga:sessions"} }) in Result
let Source = GoogleAnalytics.Accounts(), #"Step 1" = Source{[Id="XXXXXXX"]}[Data], #"Step 2" = #"Step 1"{[Id="XX-XXXXXXX-XX"]}[Data], Data = #"Step 2"{[Id="XXXXXXXXX"]}[Data], Result = Cube.Transform(Data, {
{Cube.AddAndExpandDimensionColumn, "ga:channelGrouping", {"ga:channelGrouping"}, {"Channel"}}, {Cube.AddMeasureColumn, "Sessions", "ga:sessions"} }) in Result
let Source = GoogleAnalytics.Accounts(), #"Step 1" = Source{[Id="XXXXXXX"]}[Data], #"Step 2" = #"Step 1"{[Id="XX-XXXXXXX-XX"]}[Data], Data = #"Step 2"{[Id="XXXXXXXXX"]}[Data], Result = Cube.Transform(Data, {
{Cube.AddAndExpandDimensionColumn, "ga:channelGrouping", {"ga:channelGrouping"}, {"Channel"}},
{Cube.AddAndExpandDimensionColumn, "ga:eventCategory", {"ga:eventCategory"}, {"Interaction"}}, {Cube.AddMeasureColumn, "Sessions", "ga:sessions"} }) in Result
Every query returns a different number, but the source is always the same and there are no applied filters, since this connector does not provide a filtering system.
I think this is a very important issue to solve.
Regards
Lino
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.