filter on date

[P_Dugan]

Hello everyone,

I'm trying to extract data from google analytics consisting of the following dimensions and metrics;

            {Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},
            {Cube.AddAndExpandDimensionColumn, "ga:pagePath", {"ga:pagePath"}, {"Page"}},
            {Cube.AddMeasureColumn, "Pageviews", "ga:pageviews"},
            {Cube.AddMeasureColumn, "Unique Pageviews", "ga:uniquePageviews"},
            {Cube.AddMeasureColumn, "Avg. Time on Page", "ga:avgTimeOnPage"},
            {Cube.AddMeasureColumn, "Entrances", "ga:entrances"},
            {Cube.AddMeasureColumn, "Bounce Rate", "ga:bounceRate"},
            {Cube.AddMeasureColumn, "% Exit", "ga:exitRate"},
            {Cube.AddMeasureColumn, "Page Value", "ga:pageValue"}

If I comment out the "page" dimension I get data that is up to date (up to yesterday's date), if I leave the dimension in then the latest data returned is from 2016, any ideas why this is?

Is there a limit on rows imported from Google Analytics when using the free desktop version of Power BI?

I cannot apply a date filter in the query to only return records within the last 8 weeks as this results in an empty table, the filter is being applied to the existing data which I know does not contain data later than 2016.

Thanks,

Paul

[v-frfei-msft]

Hi @P_Dugan,

How did you connect to google analytics. Power bi service or Power Bi desktop?

Regards,

Frank

[P_Dugan]

Hello Frank,

Did you see my reply to your connector question?

I use PowerBI desktop to connect to Google Analytics.

Thanks,

Paul

[P_Dugan]

Hello @v-frfei-msft Frank,

I'm using Power BI Desktop.

Thanks,

Paul