Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi @P_Dugan,
How did you connect to google analytics. Power bi service or Power Bi desktop?
Regards,
Frank
Hello Frank,
Did you see my reply to your connector question?
I use PowerBI desktop to connect to Google Analytics.
Thanks,
Paul
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |