Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

PowerQuery to access Google Analytics API Data

We are tryign to build PowerQuery to access Google Analytics API Data using below syntax.    We are keep getting error that client unauthorized.   we try to create the Cliendid information using ...
General Comment
Need Help
v-yingjl's avatar
v-yingjl
Community Support
4 years ago

Hi Anonymous ,

Since Google Analytics uses OAuth2 authentication method, please try to refer this document about OAuth autentication in Power Query:

Implementing an OAuth Flow 

 

Simliar Blog: HOW TO GET GOOGLE ANALYTICS DATA IN POWER QUERY 

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    thanks for the reply v-yingjl . 

    We did tried that article, but when we tried below URL using our clientid and codes, it do not work.

    Any idea?

    https://accounts.google.com/client_id=YourClientID
&response_type=code
&redirect_uri=urn%3aietf%3awg%3aoauth%3a2.0%3aoob
&approval_prompt=force
&scope=https%3a%2f%2fwww.googleapis.com%2fauth%2fanalytics.readonly
&access_type=offline