Forum Discussion
Viewing SharePoint Site Hub stats in PowerBI
Hi,
I have successfully integreated Google Analytics to PowerBI for our SharePoint intranet site, however I am unable to connect my SharePoint usage stats.
I have searched and tried many solutions without success. I feel like I have missed something, given both are MS products I feel it should be easier to do than connecting Google Analytics.
Would someone mind assisting me with what I need to do to bring in SharePoint Usage stats, please?
Hi laurenlee ,
You can connect to the template app Microsoft 365 usage analytics in Power BI Service or use PBIT file in the attachment and edit your credentials in Power BI Desktop.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
This is not resolving it. I see this question in forums all over and no resolution.
With every website I have ever been part of I can connect my site to a tool and see beautiful reports, demographic information and export the data for further analysis in PowerBI or Excel.
The usage stats provided by SharePoint for our hub site are limited and not set up for analysis. What displays in PowerBI is not useful as all. We work in a distributed organisation and something as simple as demographic location of views is not an option. People who manage websites are not generally the same people that manage IT functions like user access and such so forcing usage stats of these functions together makes it impossible for communicators to do effective analysis.
Please either advise how I can simply connect my hub site stats to powerBI as easily as it is for Google Analytics so I can provide effective analysis on our internal communications.
v-kkf-msftCommunity Support
Hi laurenlee ,
Please see if these documentations are helpful:
https://ericjalexander.com/blog/2017/01/21/Integrating-Google-Analytics-Into-SPO
The Ultimate Guide to Setting Up Google Analytics in SharePoint
Best Regards,
WinnizThank you, I already have GA set up but we are unable to track demographic information with GA which is why we need to access proper stats in SharePoint.
- v-kkf-msft
Hi laurenlee ,
You can connect to the template app Microsoft 365 usage analytics in Power BI Service or use PBIT file in the attachment and edit your credentials in Power BI Desktop.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
