I'm trying to make auto refresh working, if I manually refresh data in desktop app, everything works. Once I try to hit the refresh button in web version I get the following error:
[Unable to combine data] Section1/acquisition by day/json references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
Side note, this is not firewall error.
Here's a code I have:
let
json = Web.Contents("http://my_googleanalytics_endpoint/query", [Query=[#"access_token"=settings[token], #"ids"=settings[id], #"start-date"=settings[start], #"end-date"=settings[end], #"metrics"="ga:newUsers", #"dimensions"="ga:landingPagePath", #"max-results"="10000"]]),
headers = List.Transform(Json.Document(json)[columnHeaders], each _[name]),
data = Table.FromRows(Json.Document(json)[rows], headers),
//////
// then go some transformations, not a cause?
//////
#"Renamed Columns" = Table.RenameColumns(data,{{"ga:landingPagePath", "ga:pagePath"}}),
#"Lowercased Text" = Table.TransformColumns(#"Renamed Columns",{{"ga:pagePath", Text.Lower}}),
#"Changed Type" = Table.TransformColumnTypes(#"Lowercased Text",{{"ga:date", type date}, {"ga:newUsers", Int64.Type}, {"ga:sessions", Int64.Type}, {"ga:yearMonth", Int64.Type}})
in
#"Changed Type"
"Settings" is another data source where I store and re use parameters and values. Any ideas how to fix error? or rebuild formulas?
