Google Analytics - Google Merchandise Store data

[Omega]

Hi,

Has anyone managed to connect PBI with Google Marchandise store? I keep getting Forbidden access. 

Please help. 

[Omega]

Hi Tang, 

I think this will work with any other datasets but not Google Merchandise Store as the data is not owned by me but by Google. 

Right?

[v-xiaotang]

Hi @Omega 

Can we close this thread now if there is no other question? It would be nice if you can accpet my answer as the solution. Thanks 🙂

Best Regards,

Community Support Team _ Tang

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

[v-xiaotang]

Hi @Omega 

I think you are right. If so, you may need Google’s authorization to get the data. 

Best Regards,

Community Support Team _ Tang

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

[v-xiaotang]

Hi @Omega 

you can use Google Analytics connector,

https://docs.microsoft.com/en-us/power-query/connectors/googleanalytics

Best Regards,

Community Support Team _Tang

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

[Omega]

Hi,

That's what I did, yet it's giving me same error of Forbidden Acccess 😞

[v-xiaotang]

Hi @Omega 

try this - go to the google account settings, check the recent security activities of the google account, find your authorization to the desktop, and click confirm

then, go to Desktop, clear the old permission in Data Source Settings,

finally, try Google Analytics connector again.

Best Regards,

Community Support Team _ Tang

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