G4 - Google Analytics - Errors when expecting an integer

[apmulhearn]

Hi!

In PowerBI Desktop, I'm using the Google Analytics 2.0 connector to connect to G4.
My numbers in my models are all off, because of errors in some of the data. The auto-created table wants integers, but some of my results are decimals.

I can't figure out how to make this work and would appreciate help.

These are screenshots of the applied steps.

When i try to change the column type (right click - change type) to decimal, or to transform/round, I get this message:

[Anonymous]

Hi @apmulhearn ,

Please follow the steps below and check if you can connect to G4:

1. Create a new report and uncheck the option "Detect column types and headers for unstructured sources" (Options and settings --> Data Load --> Type Detection)

2. Connect to G4

Best Regards