Google Analytics Power BI Report
Provides a detailed report built off Google Analytics data. Allowing for a deep dive analysis on daily page views with forecasting and adjustable rolling average, month-over-month traffic gain or loss, top pages visited, traffic source trends over time, and more.
Once you log in with credentials you’ll be prompted to enter your Google Analytics View ID. This will populate the report with your sites data. Depending on the size of your data, the initial load may take some time due to the speed of the Google Analytics API. On average, it can load about 35,000 rows a minute.
We recommend you test the report out as a free online only version by adding it from the Microsoft AppSource store here. This will let you know if your Google Analytics account will work with this template. Note that with the online version, the data model, Power Query applied steps, and DAX cannot be edited. Otherwise you can purchase the downloadable PBIX file which gives you access to the full report.
Check out a sample of the report below:
Created by Reid Havens of Havens Consulting (www.havensconsulting.net):