Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

DataFormat.Error: While importing Google Analytics data for Revenue

Hi,

 

hope someone can help me with that.

I´m trying to import revenue data from our Google Analytics account by date. I have 10 different Sales Lines, some are working just fine but some are runing into an error:

 

DataFormat.Error: Unerwartete Daten für eine Spalte vom Typ "Currency" erhalten.
Details:
1.6553920699772E7

 

Means:

DataFormat.Error: Retrieve unexpected data for a Currency column.

Details:
1.6553920699772E7

 

Does someone know how the handle that kind of error. I assume that the amount is to big, but I´m not aware of any size restrictions for the fields. I also tried to split the date by hour, but this doesn´t helped.

Thanks in advance for any recommendations.

Best

Lina

Need Help

8 Replies

  • hugoberry's avatar
    hugoberry
    Responsive Resident
    9 years ago

    The number looks quite small for currency:

    $16,553,920.699772

     

    Can you provide some more details to the query that loads this data? Maybe the precision of this number is too hard to grasp.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi,

       

      thanks for your reply. The query to get the data looks like this:

       

      = Cube.Transform(#"xxxxxxxxx",

      {

      {Cube.AddAndExpandDimensionColumn, "ga:deviceCategory", {"ga:deviceCategory"}, {"Device Category"}}, {Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},

      {Cube.AddMeasureColumn, "Average Order Value", "ga:revenuePerTransaction"},

      {Cube.AddMeasureColumn, "Ecommerce Conversion Rate", "ga:transactionsPerSession"},

      {Cube.AddMeasureColumn, "Revenue", "ga:transactionRevenue"},

      {Cube.AddMeasureColumn, "Transactions", "ga:transactions"},

      {Cube.AddMeasureColumn, "Sessions", "ga:sessions"}

      })

       

      When I checked the value in GA directly I get also the currency written before the value. I tried a variable which does not include the currency but this doesn´t work either.

       

      Thanks

      Lina

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        9 years ago

        Just tried your query but using my own GA account and it worked fine.  Maybe it's regional settings or something up with GA.

         

        What are your regional settings in Power BI desktop set to?