Investigate "sampling" issues when pulling GA data into pbi

[GitAntR]

• [ ] Use Lizbeth's link's for research on 'sampling' issue
• [ ] Investigate use of BigQuery for project
• [ ] Move towards a draft solution plan / update
• [ ] Communicate back to Lizbeth / Sean

[GitAntR]

Lizbeth's forum resources for the "sampling" issues

• https://www.skylinetechnologies.com/Blog/Skyline-Blog/October_2018/data-granularity-google-analytics-power-bi-api
• https://community.powerbi.com/t5/Power-Query/Does-the-Google-Analytics-connector-bring-in-full-data-or/m-p/156515
• https://community.powerbi.com/t5/Desktop/Avoid-sampling-Google-Analytics-connector/td-p/572755

[GitAntR]

Does problem persist when changing MAX date to be less than today? e.g. try set it to a few days ago...

[GitAntR]

Does problem persist when changing MAX date to be less than today? e.g. try set it to a few days ago...

Article(1): data-granularity-google-analytics-power-bi-api "we will need to create multiple fact tables, each containing a subset of the dimensions that play nicely together"

[GitAntR]

Awaiting send of google sheet document... Will plug this in temporarily to see desired value. Enterprise solution is to utilise Google BigQuery for data feed

[GitAntR]

Attempting re-build with Google BigQuery