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...
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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Smithberg,

 

Could you please post sample data of the Revenue column? I find a similar thread stating same issue, and Lina uses a different variable as a workaround.

Reagrds,
Lydia Zhang