Google Analytics Report

INSTALLATION INSTRUCTIONS

To replace the demo data with your own data:

  • Log into your Google Analytics account

  • Navigate to the desired Analytics Account (1)

  • Navigate to the desired Properties & App

  • Copy the Property ID, and paste into the Google Analytics View ID parameter (3)

  • If you purchased a refresh subscription, enter the purchase email into the Purchase Email parameter. Otherwise any other email inputted will still allow you to refresh data with a trailing six-month date window

  • Set the authentication method for Google Analytics to OAuth2 (4)

  • Provide your secured Google Analytics login email (5)

  • Ensure that the Privacy Levels for both data sources are set to public - one data source is for the Google Analytics account and the other is a Power Automate validation of the purchase email (6)

  • The Azure URL is for the Power Automate email license check. Set authentication method to anonymous (7)

More information about the Google Analytics connector can be found at the Microsoft documentation page.

PARAMETER UPDATE INSTRUCTIONS

If you’ve purchased a template app subscription to remove the six-month date filter. Please follow the instructions below to update the Power BI dataset email parameter

  • Log into the Power BI Portal

  • Navigate to the Google Analytics Workspace (1)

  • Select the ellipsis to access the Google Analytics dataset context menu (2)

  • Select Settings (3)

  • Change the Purchase Email value under the Parameters sub-menu to the same email you used to purchase the subscription in our Files Store. (4)

  • The next time the model is refreshed the subscription status should change to Active. Any questions concerns or issues please contact us below

Update Parameter Step 1.png
Update Parameter Step 2 and 3.png
 
One-on-One Meeting (Blue).png
 
 
Online Material (Blue).png
 

Consulting & Training

We provide many consulting services related to Power BI or Excel reporting. Including everything from Data Acquisition with Power Query, Data Modeling, or Visualization & Design.

Our services range from customized co-development, to structured training depending on the client's needs.

Articles & Videos

We also have numerous articles, videos, and other content we publish multiple times a month on various media platforms.

Many of these articles showcase great practices, techniques, or other important information related to Power BI or Excel.