Forum Discussion

danieldefo's avatar
danieldefo
Frequent Visitor
8 years ago
Solved

Google Analytics Connector in PowerBI Desktop

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

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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