How to extract full SharePoint Site Usage Analytics via API (avg time, device, heatmap)?
Hello everyone, I'm trying to automate the extraction of SharePoint Site Usage Analytics reports, but I'm running into a limitation where the data exposed by Microsoft Graph API does not match the analytics available in the SharePoint UI or the exported Excel report. In the SharePoint site analytics page, I can see metrics such as: Unique viewers Site visits Average time spent per user Usage by device Usage by time (heatmap) Trend charts for the selected period (7 / 30 / 90 days) There is also a Download button that exports an Excel file containing all these analytics. However, when I query Microsoft Graph using the SharePoint usage reports endpoints (for example: getSharePointSiteUsageDetail), the API only returns a subset of the data: { "lastActivityDate": "2026-01-20", "uniqueViewers": "28", "siteVisits": "615", "avgTimeSpentPerUser": null, "byDevice": null, "byTimeHeatmap": null, "fileCount": "759", "activeFileCount": "45", "pageViewCount": "615", "visitedPageCount": "28", "reportRefreshDate": "2026-01-20", "reportPeriodDays": "7" } As you can see: Fields like avgTimeSpentPerUser, byDevice, and byTimeHeatmap are always returned as null. The numeric values (unique viewers, visits, etc.) are also different from what the SharePoint UI shows for the same time range. The Graph data appears to be delayed and aggregated differently compared to the UI. From what I can tell: These metrics seem to exist internally (since the UI and Excel export clearly show them). But they are not exposed through any documented Graph API endpoint. The Excel download does not appear to have a stable or supported API endpoint that can be called programmatically. My questions Is there any supported way to programmatically retrieve the full SharePoint analytics dataset (including avg time, device breakdown and time heatmap)? Is the Excel export endpoint accessible via any supported API? Are these fields intentionally not exposed in Microsoft Graph? If this is not possible today, what is the recommended approach for automating this type of analytics collection? Any clarification or official guidance would be greatly appreciated. Thanks in advance!
Change in SharePoint File Selection Behaviour
Has anyone noticed this in the last week/s? Basically before, you used to be able to SELECT files without opening them. Now, 5-6 times out of ten, if I try to select a document or folder it opens instead. Like, even when i am clearly clicking the checkmark to the left of the file/folder, it will STILL OPEN in the browser, rather than just selecting. It's like the file open behaviour has gotten more sensitive or something? It's really frustrating because my users need to add metadata to documents by selecting them, and now they have to fight with SharePoint nearly every time.
Issue: Date picker / calendar icon disappeared from Page Details pane
Hi everyone, I am reaching out to see if anyone else is experiencing a recent issue with the Date field in SharePoint Online. Since yesterday (January 15th), the calendar icon / date picker has disappeared from the Page Details pane when editing properties for News pages. Here are the details of the issue: The Problem: When clicking on a Date column in the Page Details pane, the calendar selector no longer pops up. Manual Entry: It is still possible to type the date manually, but the visual interface is gone. Comparison: Interestingly, the date picker works perfectly fine when using "Edit in grid view" in the Site Pages library. The issue seems specific to the side property pane (Details pane). Browsers tested: I have reproduced the issue on both Microsoft Edge and Google Chrome (latest versions), even after clearing the cache. Is this a known bug following a recent update, or is there a new UI setting I might have missed? Has anyone seen a similar report in the M365 Service Health dashboard? Thanks in advance for your help!
PnP Search Results Handlebars template saves but does not reflect on UI
Hi everyone, I am working with the PnP Search Results web part in SharePoint Online and facing an issue where a custom Handlebars result template saves successfully but does not reflect on the UI. I created a table-style Handlebars template with columns Document, Region, Country, Language, Status and Validation Date, one row per document. Documents are returned correctly and filters based on the same refinable properties work as expected. Debug output using JSONstringify(item) confirms that all refinable values are present. The same if-condition logic using item.RefinableStringXX works in a list-style layout, but in a table layout the template saves without errors and either does not reflect on the UI or renders rows with empty metadata columns. Inline bindings do not render unless wrapped in if blocks and even after fixing this the UI sometimes continues to show the previous layout. Managed property mappings, selected properties, indexing and library reindexing have already been verified. Has anyone experienced this behavior with PnP Search Results templates or knows if this is related to caching, result types overriding templates or a known limitation with table-style Handlebars layouts?Delete Version History
Hello Team, I'm looking for help with deleting the version history of specific files in SharePoint, but retaining the last 10 versions. I can see that I can manually delete the version history, but this is going to be a rather long task for this particular file, or i can delete them all which we don't want. I've found powershell commands which will go through all files in a document library but nothing for a specific file. Does anyone have anything which will do this? Thank you.
SharePoint Online global storage limits
Does anyone know the maximum total storage limit I can have by adding up user licenses that include the SharePoint service? I've looked at the limits page, but it only shows the maximum limit per site, not the total. Another way to ask the question is, what is the maximum storage I can get by increasing it by 10GB for each license I purchase?
