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!
Hi, @Reinier ,
What you can do is create a Sharepoint List and assign a column for each Data you want to get (File Name, Created by, File Size, etc. ) . then using Power Automate create a flow that will trigger when someone uploads on your SharePoint sites, then connect your flow to SharePoint list.
Then make a Power BI report and your Data source will be your SharePoint list.
I hope it will help you.
Thank you, but I'm more intrested in the site or file useage. So, how many times is a file been vieuwed in the last weeks? Do you know it this is also possible.
Can you share some screenshots to clarify your issue more explicitly? You can also refer to: https://powerbi.microsoft.com/en-us/blog/explore-your-office-365-adoption-data-in-power-bi/.
Hi @v-yuta-msft. Apologies for the delay, I've had a few days off.
In Sharepoint Online, I can download spreadsheets with figures such as Visits, Hits and Search Queries here:
From Site Contents, I can also view Unique Viewers and Site Visits on a daily basis for the last 90 days, however this can't be exported as a spreadsheet.
Also on this page, it shows the most popular content over the last two weeks.
Using the same process, we can see the Unique Viewers, Site Visits and popular content for each of our subsites, as well as which of the subsites has the most views.
As far as I can tell, none of this is included in the dataset I get when I connect Sharepoint to Power BI. The usage data for each product is more focused on file activities like sharing and syncing and doesn't even list what content is popular for these metrics.
The only O365 applications to give data on what devices are used to access them are Yammer, Skype, Teams and Exchange.
The actual Sharepoint usage stats are focussed more on enabled and active, with users, files and sites which although useful to know doesn't quite give us what we're looking for, especially as I can't seem to get a list of the sites and files.
It also gives us data on who the most active users are and although it's interesting to see what the most active departments are, this doesn't correlate to our subsites and knowing active individuals isn't hugely enlightening.
And I can't see a way to add another data source so I couldn't add in the spreadsheets from Sharepoint Online or connect Google Analytics to display all of these sources on one dashboard.
I can analyse the data from Power BI in Excel so could use that data as a datasource in another data vis tool such as Data Studio or Tableau but this is a manual process that I want to avoid. I'd just like to be able to get the data I need, which is clearly available somewhere, all in one place.
@Chris_FSA have you found any workaround to get the sharepoint site usage in PowerBI. I am looking to do the same but the 365 analytics dataset is definitley limited.
Same question/requirements for our Intranet, built on 20+ site collections (corporate pages, Functional Area pages, Policies & Procedures, etc...). Our management is eagerly requesting a dashboard to view site usage for each of the pages, news & documents available on the intranet. How can we access the site usage statistics from Power BI for multiple site collections and drill down to/filter on specific pages/docs/news etc...
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!
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.