Is there option to connect live with google analytics

[angela]

Hi, I'm wondering is there a way to connect live with Google Analytics. I cannot find it, I'm using desktop and will be using server (not sure whether that's enabled on server?)

Thanks!

[Greg_Deckler · Accepted solution]

I do not believe that there is a live connection to Google Analytics out-of-the-box. If you could find some way to feed your Google Analytics data to an Azure Event Hub or IoT Hub and then connect Azure Streaming Analytics to it then you could send the output to Power BI as a live data stream. You could also do this via the Power BI REST API. I am not clear however how you would connect into Google Analytics to pump the data out of it.

[Anonymous · Accepted solution]

Hi @angela,

As smoupre's point of view, you can refer to below links to push the google analytics data to azure stream analytics job, then set the output to power bi.

Reference:

Analyzing Google Analytics Data in Real Time with Azure Stream Analytics (video)

Stream Analytics & Power BI: A real-time analytics dashboard for streaming data

Regards,

Xiaoxin Sheng

[Greg_Deckler · Accepted solution]

I do not believe that there is a live connection to Google Analytics out-of-the-box. If you could find some way to feed your Google Analytics data to an Azure Event Hub or IoT Hub and then connect Azure Streaming Analytics to it then you could send the output to Power BI as a live data stream. You could also do this via the Power BI REST API. I am not clear however how you would connect into Google Analytics to pump the data out of it.

[angela]

Thank you @Greg_Deckler and @Anonymous I don't have Azure Streaming Analytics, I see they have free version, will the free version do the work?

[Anonymous]

Hi @angela.

It seems work on free trial account.

Reference:

Create your free Azure account today

Regards,

Xiaoxin Sheng