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 runi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi,

 

in PowerBI desktop my regional setting is Germany.

 

Thanks

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Give it a crack on US just to see if it works any better (I know there will be other shortcomings)

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    changed it to US, but still not working. 

    • hugoberry's avatar
      hugoberry
      Responsive Resident
      9 years ago

      I was able to replicate the error with

      = Currency.From("1.6553920699772E7","de-DE")

       

      it is fixed with 

      = Currency.From("1.6553920699772E7","en-US")

      or

      = Currency.From(Number.From("1.6553920699772E7"),"de-DE")

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi,

         

        thanks for your reply, I didn´t had the time to test it. I found a work arround using a different variable. I will test it as soon as I have time.