Using Power BI with WordPress and Google Analytics

How to Install Google Analytics in WordPress for Beginners at WPBeginner

Use the Google Analytics connector for Power BI Desktop {Power BI documentation}

Check out this (free) Google Analytics template for Power BI by Gaelim Holland

Side note: take a look at my traffic statistics from the WordPress plugin “Monster Insights” after a link from Brent Ozar’s weekly newsletter:



Serious spike in page views


Top 10 Countries and Top 10 Referral sources


Top Posts/Pages – Guess which page Brent linked to!

Screenshots showing how to use Google Analytics data (Measures and Dimensions) with Power BI


Step1-GetData-ChooseGoogleAnalytics

Step2-ThirdPartyServiceConnectionWarning

Step3a-Navigator-AdExchange-Metrics

Selection of a Measure (only)

Step3b-Navigator-Adsense-Metrics

Only Measures available

Step3c-Navigator-Adwords-Metrics

Measures and Dimensions available

Step3d-Navigator-AppTracking-Metrics

Measures and Dimensions available

Step3e-Navigator-Audience-Metrics

Only Dimensions available. Notice you cannot only have a Dimension selected. (Sorry, I forget to uncheck this in later screenshots and the error persists)

Step3f-Navigator-ChannelGrouping_and_ContentExperiments-Metrics

Dimensions only

Step3g-Navigator-ContentGrouping-Metrics

Mixture of many available Dimensions and some Measures

Step3h-Navigator-CustomVariablesOrColumns-Metrics

One Measure and a bunch of available Dimensions

Step3i-Navigator-DoubleClickBidManager-Metrics

Both Measures and Dimensions available

Step3j-Navigator-DoubleClickCampaignManager-Metrics

Both Measures and Dimensions available

Step3k-Navigator-DoubleClickForPublishers_and_DoubleClickforPublishersBackfill-Metrics

Mostly Measures and a couple of Dimensions

Step3L-Navigator-DoubleClickSearch-Metrics

Both Measures and Dimensions available

Step3m-Navigator-Ecommerce-Metrics

Both Measures and Dimensions available

Step3n-Navigator-EventTracking-Metrics

Both Measures and Dimensions available

Step3o-Navigator-Exceptions_and_GeoNetwork-Metrics

Dimensions only available

Step3p-Navigator-GoalConversions-Metrics

Both Measures and Dimensions available

Step3q-Navigator-InternalSearch-Metrics

Both Measures and Dimensions available

Step3r-Navigator-LifetimeValueAndCohorts-Metrics

Both Measures and Dimensions available

Step3s-Navigator-PageTracking-Metrics

Both Measures and Dimensions available (finally fixed the error message)

Step3t-Navigator-PlatformOrDevice-MeasureError-Metrics

Only Dimensions available. Notice that at least one Measure must be selected.

Step3u-Navigator-Publisher-MeasureDisplay-Metrics

Only Measures available

Step3v-Navigator-Session-MeasureAndDimensionDisplay-Metrics

Only Measures available

Step3w-Navigator-SiteSpeed-MeasureDisplay-Metrics

Only Measures available

Step3x-Navigator-SocialInteractions-MeasureAndDimensionDisplay-Metrics

Both Measures and Dimensions available

Step3y-Navigator-System-Metrics

Only Dimensions available

Step3z-Navigator-Time-Metrics

Only Dimensions available

Step3zz-Navigator-TrafficSources-Metrics

One Measure and several Dimensions available

Step3zzz-Navigator-User-Metrics

Both Measures and Dimensions available

Step3zzzz-Navigator-UserTimings-Metrics

Both Measures and Dimensions available