Forum Discussion
filter on date
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
3 Replies
- v-frfei-msftCommunity Support
Hi P_Dugan,
How did you connect to google analytics. Power bi service or Power Bi desktop?
Regards,
Frank