Forum Discussion
PBI doesn't recognize currency from Google Analytics ( DataFormat.Error )
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).