Forum Discussion
PBI doesn't recognize currency from Google Analytics ( DataFormat.Error )
To clarify:
my client's GA is setup with Sweden as Region,
Currency is therefore in SEK.
The error occurs directly in the query from GA using PBIs built-in connector.
Query:
= Cube.Transform(#"Added Items", {{Cube.AddMeasureColumn, "Revenue", "ga:transactionRevenue"}})
After this, I cannot do anything to change the format as the Error has already occured.
There is no format change before this query (see pictures in thread)
Does not make a difference if I change my regional settings (tried various regions) when I do the query!
Hope someone has a solution, would be a great help!
/Smithberg
Have you changed the region settings(Location and Formats) in your computer to Sweden? And please also change the global region setting to Sweden in Power BI Desktop, then re-connect to GA and check if the issue still persists.
Besides, you can retrieve data from Google Analytics api directly to Power BI following the instructions in this article, then create reports.
Regards,
Hi again,
I have tried changing regional settings (both on my computer and in PBI). Nothing works.
Additionally I have tried creating a calculated metric in google analytics based on Revenue but as a decimal number instead of currency. Would have been a solution, but I couldnt get the calculated metric to work in the connector.
What does work:
Using google sheets to access the data and then importing the data through the web connector. However, my client deems the information too sensitive to use the publish to web function in google sheets.
Using the revenue per user metric in combination with the users in the API connector! However, I do lose some aspects as I wanted to include other dimensions such as DeviceCategory, which I cannot do now as Google will sample my data which would be completely unreliable as I'm then combining two sampled fields (thus multiplying the sample degree). This is the solution I'm going for until I can find a more sustainable solution.
I have seen the excel connector guide this is about as fiddly as exporting manual reports from google analytics and then loading an entire folder (as I would have do to manual refreshes either way).