Google Analytics Connector in PowerBI Desktop

[danieldefo]

Dear Community ,

Please could you assist me on following requirement.
Recently, I got task from client about Google Analytics in PowerBI.
When using the Google Analytics connector in PowerBI, the authentication prompt hints it's been created by "sqlazurelabs.com". Basing on official Microsoft site (https://blogs.msdn.microsoft.com/uk_faculty_connection/2011/12/08/SQL-azure-labs/) That SQL 
However, from security perspective, is there any data flowing to SQL Azure Labs or not it is under question.
Which alternative way Can I use to fetch data from Google Analytics and visualize in PowerBI. As I know there is also Rest API option for that.But do not how to use it properly.Is there any suggestion?
Looking forward to hearing by your side

Sincerely,
Daniel

[Anonymous · Accepted solution]

@danieldefo,

As per my understanding, the above notification is same as that allows Power BI Desktop to have offline access to your Google Analytics(GA) data, the data will not flow to SQL Azure labs. After your import data from GA to Power BI Desktop, Power BI Desktop stores these data in PBIX file.

In addition, you can also use Power Query in Power BI Desktop  to fetch data from GA. There is a blog for your reference.


Regards,
Lydia

[danieldefo]

@Anonymous Thanks lot for clarification!!