PQGoogleAnalytics - Google Analytics connector for Power BI and Power Query for Excel

This program is written on M# language and it is used for retrieving data from Google Analytics api directly to Power BI Excel using Power Query Addon.

A lot of code [in this application] is taken from article on kohera.be.

You can download Xls and PBIX file from here

Requirements

1. MS Excel 2010, 2013, 2016 or Power BI
2. Power Query Addon

Ignore privacy levels

To make this file work you need to enable the setting "ignore privacy levels" on privacy tab in Power BI or Power Query for Excel settings. Here is the screenshot:

Video demonstration

Here is the short video which describes how this workbook works.

https://vimeo.com/maximuvarov/googleanalyticsviapowerqueryformsexcel