Forum Discussion

Yuhan's avatar
Yuhan
Regular Visitor
6 years ago

Google Analytics: How to specify samplingLevel?

As far as I know, Power BI still uses the old Core Reporting API v3 to connect to Google Analytics, not v4. For those that don't know, you could reduce sampling when querying GA data by specifying sa...
Need Help
Icey's avatar
Icey
Community Support
6 years ago

Hi Yuhan ,

 

I don't have a google account, so I can't test for you currently. I find that you can set sample values for the parameters in the Query Explorer.

Or, maybe you can refer to this post to create one parameter: Passing parameters for Google Analytics in the Advanced Editor. 

 

 

Best Regards,

Icey

 

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

Yuhan's avatar
Yuhan
Regular Visitor
6 years ago

IceyThanks for linking the Query Explorer, I did not know of this.

 

However the Query Explorer outputs queries as an URI. I'm guessing Power Bi is letting us write our queries in M and then converting that into an URI for Google. But some options available in the API seems to be unsupported in M. For example, the query URI may include a samplingLevel option, but how can I code that using the Advanced Editor?

 

I'm not sure the passing parameters do the trick either, because they are written in M too.