topic Re: Extract raw data from google analytics in Developer

Extract raw data from google analytics

Sanskruti — Thu, 08 Sep 2022 06:54:30 GMT

Hello,
I'm trying to get the raw data from google analytics in power bi using google API. I have created credentials, enabled the API's.

Now i'm trying to connect this with power bi. Is there any way?

Thank you.

Re: Extract raw data from google analytics

v-chenwuz-msft — Fri, 09 Sep 2022 02:49:55 GMT

Hi @Sanskruti ,

Here is the official guide of how to get data from google analytics

https://docs.microsoft.com/en-us/power-bi/connect-data/service-google-analytics-connector

Best Regards

Community Support Team _ chenwu zhu

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

Re: Extract raw data from google analytics

Sanskruti — Fri, 09 Sep 2022 04:17:17 GMT

Thanks for replying @v-chenwuz-msft

I directly connected google analytics with powerbi but it is giving me aggregated data. And my requirement is to collect the raw data.

Thank you .

Re: Extract raw data from google analytics

Adel — Fri, 09 Sep 2022 06:22:01 GMT

to get raw data would be to connect it to a data warehouse such as bigquery and then get your data into power bi.
Because no one provides google analytics connectors with raw data.
But check out windsor.ai they have their own cloud way cheaper than BigQuery.