After CREATING a Google Analytics query, how do I get back to the Navigator to Edit?

[gotmike]

I created a query using the connector for Google Analytics, and now I'm trying to go back to edit the query, but I can't seem to get the Navigator Window to show back up.

I get an error like..

Expression.Error: Google Analytics requires that at least one measure be specified.

And when I look at the code, I see something like this...

let
    Source = GoogleAnalytics.Accounts(),
    #"[AccountId]" = Source{[Id="[AccountId]"]}[Data],
    #"[UA-CODE]" = #"[AccountId]"{[Id="[UA-CODE]"]}[Data],
    #"[PropertyId]" = #"[UA-CODE]"{[Id="[PropertyId]"]}[Data]
in
    #"[PropertyId]"

If I look at the raw query code from a newly-created one, I see something like this...

let
    Source = GoogleAnalytics.Accounts(),
    #"[AccountId]" = Source{[Id="[AccountId]"]}[Data],
    #"[UA-CODE]" = #"[AccountId]"{[Id="[UA-CODE]"]}[Data],
    #"[PropertyId]" = #"[UA-CODE]"{[Id="[PropertyId]"]}[Data]
    #"Added Items" = Cube.Transform(#"[PropertyId]",
        {
            {Cube.AddAndExpandDimensionColumn, "ga:adDistributionNetwork", {"ga:adDistributionNetwork"}, {"Ad Distribution Network"}},
            {Cube.AddAndExpandDimensionColumn, "ga:adwordsCampaignID", {"ga:adwordsCampaignID"}, {"Google Ads Campaign ID"}},
            {Cube.AddAndExpandDimensionColumn, "ga:adGroup", {"ga:adGroup"}, {"Google Ads: Ad Group"}},
            {Cube.AddAndExpandDimensionColumn, "ga:adKeywordMatchType", {"ga:adKeywordMatchType"}, {"Keyword Match Type"}},
            {Cube.AddAndExpandDimensionColumn, "ga:adMatchType", {"ga:adMatchType"}, {"Query Match Type"}},
            {Cube.AddAndExpandDimensionColumn, "ga:adQueryWordCount", {"ga:adQueryWordCount"}, {"Query Word Count"}},
            {Cube.AddAndExpandDimensionColumn, "ga:adMatchedQuery", {"ga:adMatchedQuery"}, {"Search Query"}},
            {Cube.AddMeasureColumn, "Clicks", "ga:adClicks"},
            {Cube.AddMeasureColumn, "Cost", "ga:adCost"},
            {Cube.AddMeasureColumn, "Cost per Conversion", "ga:costPerConversion"},
            {Cube.AddMeasureColumn, "Cost per Goal Conversion", "ga:costPerGoalConversion"},
            {Cube.AddMeasureColumn, "CPC", "ga:CPC"},
            {Cube.AddMeasureColumn, "CPM", "ga:CPM"},
            {Cube.AddMeasureColumn, "CTR", "ga:CTR"},
            {Cube.AddMeasureColumn, "Impressions", "ga:impressions"}
        })
in
    #"Added Items"

So, yes I can edit it manually if I want to go in and do so, but how can I get back to the UI to configure an individual query?

[v-jiascu-msft · Accepted solution]

Hi @gotmike,

There could be two ways. Please refer to the snapshot below.

1. It seems you can add more items in step 3 that you can find it out in the "Applied Steps".

2. Open the connector again in the "Recent Sources".

Best Regards,
Dale

[gotmike]

that's it!

thanks!