Forum Discussion

Aman-K's avatar
Aman-K
Helper III
1 year ago

Import Google Analytics data into Power BI

Hi guys,   I was wondering if it's possible to import Google Analytics data into Power BI?   We already have a number of web metrics as our KPIs, including number of visitors and bounce rate. Cur...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, Aman-K 

In the Power BI Desktop Get Data window, select Online Services from the categories on the left, then select Google Analytics and click Connect. You'll be prompted to sign in to your Google Analytics account. Enter your credentials and allow Power BI to access your Google Analytics data.


Once connected, you'll see a list of your Google Analytics account, properties, and views. Select the data you want to import. Click Load to import the data into Power BI.
For Google Analytics 4 (GA4), you can use the Google Analytics Data API (V1) to connect and import data. Once you've imported your data into Power BI, you can create dynamic reports and dashboards to visualize your KPIs, such as visitor count and bounce rate, and embed those reports into SharePoint pages for easy access and real-time updates. You can learn more about this from the following links:

Connecting Google Analytics to Power BI | Discover the Power of Your Data

 

Power Query Google Analytics connector - Power Query | Microsoft Learn

 

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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