Forum Discussion

tuankid's avatar
tuankid
New Member
8 years ago

Data type from GA

let
    Source = GoogleAnalytics.Accounts(),
    #"123456" = Source{[Id="123456"]}[Data],
    #"UA-123456-12" = #"123456"{[Id="UA-123456-12"]}[Data],
    #"123456" = #"UA-123456-12"{[Id="123456"]}[Data],
    #"Added Items" = Cube.Transform(#"123456",
        {
            {Cube.AddAndExpandDimensionColumn, "ga:searchKeyword", {"ga:searchKeyword"}, {"Search Term"}},
            {Cube.AddMeasureColumn, "Revenue", "ga:transactionRevenue"}
        }),

I have something like this. When the revenue loads into Power BI, it loaded in scientific form and failed to recognize the cell as a number. 

 

DataFormat.Error: We received unexpected data for a column of type 'Currency'.
Details:
    2.43648E8

Any help would be highly appriciated.

 

Tuan.

1 Reply