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

I have tried everything they wrote in the thread (see my original post). I have done some further digging in the problem and these are my findings:

When values are formatted as number or decimal number in Google Analytics, there is no problem.

The problem only occurs when something is formatted as Currency and exceeds 1.0E7.

The easiest way around this seems to be to create a different variable in Google Analytics which doesn't use Currency (like Lina did in the other thread).

I have tried everything with different regional settings etc but it doesn't work since the Error occurs in the query directly from the Google API (and cannot be changed as far as I can find).

The errors therefore remain and if I change the type of the column (even to text), all the correct values in the columns are changed but the Error values remain the same as the errors occured in the query and every subsequent step is after the first query.

Possible solutions as I see it are:

Using a different connector than the built in GA connector

Using a different variable from Google Analytics which doesn't use Currency

Going down a few granularity levels so the values don't exceed 1.0E7 (but then you probably have a sampling problem on your hands from the google API)