Viewing SharePoint Site Hub stats in PowerBI

[laurenlee]

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? 

[Anonymous]

For my part, i m using clarify from microsoft

[laurenlee]

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-msft]

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,
Winniz

[laurenlee]

Thank 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 ,

Have you tried using the Google Analytics connector to connect to Power BI Desktop?

Best Regards,
Winniz

[v-kkf-msft · Accepted solution]

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,
Winniz

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