Forum Discussion

Smithberg's avatar
Smithberg
Regular Visitor
9 years ago

PBI doesn't recognize currency from Google Analytics ( DataFormat.Error )

Hi,   I have connected to Google Analytics directly through PBI desktop.   (leaving some information as xxx) When currency numbers are above 10million, they are formated as xxxE7, which PBI does...
jonathanvarga42's avatar
jonathanvarga42
New Member
8 years ago

Hi, 

 

I´m experiencing the same error when importing data from GA to Power BI, has anyone get to the solution of this issue?? 

 

Any help on this trouble or other way to avoid this kind of error with the currency type. 

 

Thank you!

  • Smithberg's avatar
    Smithberg
    Regular Visitor
    8 years ago

    I used a workaround:

     

    Use the revenue per user GA metric instead, which is formatted as a decimal number.

    Import ga:users as well

    Multiply users and revenue per user