Forum Discussion

apmulhearn's avatar
apmulhearn
Helper III
2 years ago

G4 - Google Analytics - Errors when expecting an integer

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:

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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