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
- MS Excel 2010, 2013, 2016 or Power BI
- Power Query Addon
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:
Here is the short video which describes how this workbook works.
https://vimeo.com/maximuvarov/googleanalyticsviapowerqueryformsexcel
