Google Analytics filter by date with connector

[StephenF]

This GA connector looks a bit basic.

How would you filter on date with it - it seems to pull all the data it can at the moment.

Im looking to pull the last 28 days data aggregated so it can count unique users. So i need to filter by date without including the date field as a column.

Is there a manual line or two I can add to to the query?

Here is my expression i want to date bound on import.

= Cube.Transform(#"105237604",
        {
            {Cube.AddAndExpandDimensionColumn, "ga:userAgeBracket", {"ga:userAgeBracket"}, {"Age"}},
            {Cube.AddAndExpandDimensionColumn, "ga:userGender", {"ga:userGender"}, {"Gender"}},
            {Cube.AddAndExpandDimensionColumn, "ga:pagePathLevel1", {"ga:pagePathLevel1"}, {"Page path level 1"}},
            {Cube.AddMeasureColumn, "Users", "ga:users"}
        })

[OlegS]

Hi @StephenF 

As a workaround you can import your GA data into windsor.ai account and access the data with Power BI.

You can also filter the last 28 days to import and get the number of unique users.

[v-frfei-msft]

Hi @StephenF ,

Did you want to filter your data by parameter in power query? Please refer to this case.

https://community.powerbi.com/t5/Desktop/Power-Query-Current-Date-Filter/td-p/67586

[StephenF]

I'm not trying to filter the rows post import. I'm trying to filter in the API call.

[Anonymous]

hi @StephenF!

have you found a solution? if yes, can you please share it with us?

Thanks,