Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I've connected my Power BI to my Google Analytics account, but certain key metrics don't seem to show up. For example, I can get the number of bounces, but not the bounce rate, and I can see the number of new users but not the ratio of new vs returning traffic.
Is there a way to get this data?
I'm currently deciding between Power BI and Google Data Studio for my team's main dashboard tool, and while Power BI seems to have a better design, it seems much more difficult to show Google Analytics data.
Solved! Go to Solution.
@eberstk,
You can use Power BI Desktop to connect to Google Analytics, then calculate bounce rate and ratio of new vs returning traffic, create report there. After that, you can publish the Power BI Desktop file to Power BI Service, and create dashboard in Service.
There is a similar thread for your reference.
https://community.powerbi.com/t5/Desktop/Calculate-One-Time-Visitors-from-Google-Analytics-Session-D...
Regards,
Lydia
@eberstk,
You can use Power BI Desktop to connect to Google Analytics, then calculate bounce rate and ratio of new vs returning traffic, create report there. After that, you can publish the Power BI Desktop file to Power BI Service, and create dashboard in Service.
There is a similar thread for your reference.
https://community.powerbi.com/t5/Desktop/Calculate-One-Time-Visitors-from-Google-Analytics-Session-D...
Regards,
Lydia
Thank you for the help! Will the resulting report have a live feed from Google Analytics or will I have to re-upload the report to Power BI every time I want to see updated numbers?
Thanks again!
@eberstk,
You can set schedule refresh for your dataset in Power BI Service, this way, data will be updated automatically in Power BI Service based on the schedule each time you make change to the data in Google Analytics.
Regards,
Lydia
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
8 | |
8 | |
7 |
User | Count |
---|---|
17 | |
13 | |
7 | |
6 | |
6 |