Google Analytics - Expression Error

Hello,

I was having a similar problem and found this answer, but in my case this didn't fix the issue. I already had valid dimensions and metrics in the query, but I was still getting the error at the "Navigation" step of the query, before the part of the query where dimensions or metrics are added at all.

I have an alternative fix if you are having the same problem I was, which I thought I would post here in case it helps anyone else. It seems the problem was being causing the navigation step because PowerBI doesn't seem to accept the multiple variable assignments to drill down from GA account->property->view

If you open the Advanced Editor, you should see something like this (I have changed the actual account, property and view numbers of my GA to XXXs, YYYs and ZZZs):

https://i.imgur.com/7gePwJK.png 

My fix was to change the code here so that instead of having these three different variables in different steps, the entire navigation down the three different levels of ID was done in the "Cube.Transform" step. So your final version should look like this:

https://i.imgur.com/n4xgO5R.png 

This seems to resolves the issue.

Sorry those images are links and not embedded - this forum didn't seem to like me embedding the images in the post.