Forum Discussion

P_Dugan's avatar
P_Dugan
New Member
7 years ago

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-msft's avatar
    v-frfei-msft
    Community Support

    Hi P_Dugan,

     

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

     

    Regards,

    Frank

    • P_Dugan's avatar
      P_Dugan
      New Member

      Hello Frank,

      Did you see my reply to your connector question?

       

      I use PowerBI desktop to connect to Google Analytics.

       

      Thanks,

       

      Paul