Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Bee
New Member

Google Analytics - Expression Error

I have 2 custom dimensions which I am trying to load the data into Power BI using the online services - Google Analytics. I checked on custom dimensions and encountered "Expression.Error: Google Analytics requires that at least one measure be specified". Please help to resolve issue

custom.JPGerror.JPG

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi , @Bee 

Do you use at least one  valid dimension and measure combination?

Here  we need  at least one valid measure to display the data.

For more detail ,you can refer to the video on the third party website.

Url: https://www.youtube.com/watch?v=FW4s43dmisc

1Annotation 2019-12-24 104234.png2Annotation 2019-12-24 104320.png

 

In addition ,you can also refer to the following related posts.

Url: https://community.powerbi.com/t5/Power-Query/Google-Analytics-Expression-Error-on-PBI-Desktop/td-p/1...

https://community.powerbi.com/t5/Power-Query/Google-Analytics-and-Power-BI-immediate-error-after-imp...

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-easonf-msft
Community Support
Community Support

Hi , @Bee 

Do you use at least one  valid dimension and measure combination?

Here  we need  at least one valid measure to display the data.

For more detail ,you can refer to the video on the third party website.

Url: https://www.youtube.com/watch?v=FW4s43dmisc

1Annotation 2019-12-24 104234.png2Annotation 2019-12-24 104320.png

 

In addition ,you can also refer to the following related posts.

Url: https://community.powerbi.com/t5/Power-Query/Google-Analytics-Expression-Error-on-PBI-Desktop/td-p/1...

https://community.powerbi.com/t5/Power-Query/Google-Analytics-and-Power-BI-immediate-error-after-imp...

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

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.

 

This also solved the error for me.  Thanks for posting your follow up.

This last post solved my issue too!!! grwat stuff thanks for this.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors