Sharepoint Site Usage in PowerBI?

[Chris_FSA]

I have now successfully connected my Office 365 Usage Report to Power BI but there's a few things that I can get from the Sharepoint Site Usage reports that don't appear to be available in the dataset.

The site usage report gives Unique Viewers, Site Visits and Trending Files, none of which appear to be available and this is the exact sort of data we'd like to display in our PowerBI reports. There doesn't even seem to be an option to export the site usage to use as a separate data source... And even if there was, I'm not sure I can add a second datasource to my PowerBI report?

If not, I'd also like to display device and software data from Google Analytics but the only way I've found to do so appears to be by creating another report. Ideally, I'd like all of my KPI's to be displayed on one dashboard or report.

If anyone could offer any insight into how to do any of the above, I would very much appreciate the help!

Many thanks.

[Anonymous]

Hi Eric, were you able to find a solution? It's been 4 years and there is still no OOTB solution. I need the same thing you are describing. Would appreciate any tips. Have a good day!

[Anonymous]

Unfortunately not, did some additional searching today w/ Bing Chat - Copilot, yet still no adequate solution

[Anonymous]

That's a pity. I found a couple of paid Power BI apps, but this is not ideal at all. Currently trying to analyze the dataset of the Microsoft 365 Usage Analytics app (comes with Power BI Pro) to see if I can fish out the exact data I need. 

[Anonymous]

I'm looking to do the same thing for our company... Haven't found anything useful yet.