Extract raw data from google analytics

[Sanskruti]

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. 

[Adel]

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.

[v-chenwuz-msft]

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.

[Sanskruti]

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 .