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

Smithberg,

I am not able to reproduce your issue. In your scenario, firstly remove any “Change type” step for the ga:transactionRevenue in APPLIED STEPS. Then right click the ga:transactionRevenue column in Query Editor,  select “Change Type->Using Locale”, change the data type of the column to Decimal Number with English locale.



After that, change the Format of the column to Currency under Modeling ribbon in report view of Power BI Desktop.


Regards,
Lydia Zhang

Smithberg's avatar
Smithberg
Regular Visitor
9 years ago

Hi Lydia,

 

I have tried to change locale and data types before, unfortunately the error persists.

Before adding revenue (no errors)After revenue is addedAfter locale is changed

Changing the locale doesn't change anything. Even with different region settings when I import the data!

Do you have any other ideas? =)

 

Regards,

William