Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.