Power bi and google analytics. How to set up filters for date before getting full data

[viking3000]

How to set up filters for date before getting full data. Right now pbi export all data from day one. Is more than 1.7mil. rows. I reach limit after 1mil and way to use date filter inside pbi is not a option.

So are posible way setdate range parameter (example last 3 month) before export starts?

In adv editor source code:

let
    Source = GoogleAnalytics.Accounts(),
    #"1*******1" = Source{[Id="1*******1"]}[Data],
    #"UA-1*******1-1" = #"1*******1"{[Id="UA-1*******1-1"]}[Data],
    #"1*******6" = #"UA-1*******1-1"{[Id="1*******6"]}[Data],
    #"Added Items" = Cube.Transform(#"1*******6",
        {
            {Cube.AddAndExpandDimensionColumn, "ga:eventAction", {"ga:eventAction"}, {"Event Action"}},
            {Cube.AddAndExpandDimensionColumn, "ga:eventLabel", {"ga:eventLabel"}, {"Event Label"}},
            /*{Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},*/
            {Cube.AddMeasureColumn, "Unique Events", "ga:uniqueEvents"}
        })
in
    #"Added Items"

#"1*******1" = Source{[Id="1*******1"]}[Data],
    #"UA-1*******1-1" = #"1*******1"{[Id="UA-1*******1-1"]}[Data],
    #"1*******6" = #"UA-1*******1-1"{[Id="1*******6"]}[Data],

My guess, after source location we need somehow set date range parameters.

[v-lili6-msft]

hi, @viking3000 

You could use Parameters feature in Power BI.

This is the tutorial for you to refer to

https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/

Best Regards,

Lin