Forum Discussion
Google Analytics and Power BI: immediate error after importing (valid dimension and metric combo)
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. :)
I am having this same problem. I successfully imported one measure and one dimension into my report. I am able to see the data. Now, when I go to Query Editor > Applied Steps > Navigation, I get this error message:
Expression.Error: Google Analytics requires that at least one measure be specified.
This error prevents me from clicking the gear icon next to Added Items (says "We cannot modify this step because there are errors in previous steps. Please resolve those errors first."), so I cannot get back to the measures & dimensions menu to select additional measures or dimensions.
This error doesn't make logical sense. I chose one measure ({Cube.AddMeasureColumn, "Sessions", "ga:sessions"}) and one dimension ({Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}}). To state that I did not specify at least one measure is false.
It seems like Sessions and Date are very basic, and so compatibility should not be a problem.
Does anyone have insight on this problem?
-----------------------------
My Power BI Desktop version is: 2.51.4885.543 64-bit (October 2017)