Forum Discussion
Google Analytics and Power BI: immediate error after importing (valid dimension and metric combo)
Hi everyone, When I import data from Google Analytics, it appears there's a bug. First off, to test this, I am importing pages (dimension) and pageviews (metric), which is a valid dimension and m...
Anonymous,
I have figured out a workaround. It involes simply using the advanced editor within the query editor to manually add additional dimensions and/or metrics. Note that you need to know the API names of the dimensions and metrics, which you can browse here: https://developers.google.com/analytics/devguides/reporting/core/dimsmets
I took a video of my workaround. I simply go into the query editor, go to the Source step within Applied Steps, and then go into the advanced editor. Then I copy and paste, and simply change the names to the dimensions/metrics I want to add. The video explains it better. :)
PERFECT solution when none of the others didn't work. Thanks!!