Forum Discussion
Google Analytics Expression Error on PBI Desktop
Hello, I am trying to integrate with Google Analytics to review data related to my website traffic. When I walk through the connection process in Power BI Desktop, I run into the follow error (Ex...
Hi onsitetech,
If I only click Dimensions(line graph icon) under User or Geo Network without combining metrics(bar chart icon), I can reproduce your error.
Based on this article which lists Dimensions & Metrics Explorer in Reporting API V4, only certain dimensions and metrics can be used together to create valid combinations. In your scenario, please click Dimensions and metrics to import data from Google Analytics to Power BI Desktop. This way, you are able to exclude the above error and successfully load data. There is an example for your reference.
Thanks,
Lydia Zhang