Data refresh error : Google Analytics

[PrathSable]

Hi Guys , 
 
I'm facing some trouble while refreshing Google Analytics data in power BI Service.
I have created a Function in power BI which pulls data from Google Analytics.
 
Although the refresh works perfectly fine on Power BI Desktop, It gives the below error in power BI service.
 
Any help will be much appreciated.

Thanks in Advance!

Error Message

[V-lianl-msft]

Hi @PrathSable ,

Please check the following limitations for Google Analytics connector.

• The number of dimensions is limited to 7, and the number of metrics to 10
• Some dimensions and metrics can’t be queried together
• Your data set is already aggregated, averaged etc. so you can’t use already summed/averaged data for further calculation alone or with other data
• A lot of metrics are useless for aggregation. For example, you can’t count the daily users, and then sum up to a monthly number of users.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.