Problem with GA4 2.0 connection
Some time ago I connected to GA4 using the Google Analytics 2.0 connector, however, in December it started to present the problem below, and no changes were made to it during the period. What makes it seem even stranger is that in the automatic update, some days it updates, and other days it presents the same problem without making any type of adjustment. Please, can anyone help? Problem presented: DataFormat.Error: We found an unexpected character in the JSON input.DetailsReason = DataFormat.Error Value = \31 Position = 0 In the advanced editor it looks like this: let Fonte = GoogleAnalytics.Accounts([Implementation = "2.0"]), #"navegation1" = Fonte{[Id="accounts/9999999"]}[Data], #"navegation2" = #"navegation1"{[Id="properties/9999999"]}[Data], #"navegation3" = #"navegation2"{[Id="properties/9999999"]}[Data], #"Itens Adicionados" = Cube.Transform(#"navegation3", { {Cube.AddAndExpandDimensionColumn, "transactionId", {"transactionId"}, {"transactionId"}}, {Cube.AddAndExpandDimensionColumn, "date", {"date"}, {"date"}}, {Cube.AddAndExpandDimensionColumn, "campaignName", {"campaignName"}, {"campaignName"}}, {Cube.AddAndExpandDimensionColumn, "medium", {"medium"}, {"medium"}}, {Cube.AddAndExpandDimensionColumn, "source", {"source"}, {"source"}}, {Cube.AddMeasureColumn, "totalRevenue", "totalRevenue"} }) in #"Itens Adicionados" * The IDs have been changed to "9999999". I'm warning you so it doesn't look like it's a mistake.
