How to Find Users' Last SharePoint Sign-In Date in Power BI
Question details
The user needs to find and report on the last date and time users signed into or visited pages in SharePoint using Power BI.
- Product
- SharePoint and Power BI
- Device & OS
- not provided
- Scenario
- Building a Power BI dashboard to track user engagement, activity, and the most recent connection dates for SharePoint environments.
- Observed behavior
- SharePoint's default hidden lists do not reliably track or store users' latest connection or page-visit dates, making direct Power BI queries to these lists ineffective.
Ensure you have the necessary Microsoft 365 administrative privileges to access Microsoft Purview, Microsoft Entra ID, or standard usage reports before attempting to build a Power BI dashboard.
Use Microsoft Purview and Entra Logs for Power BI Reporting
Since SharePoint does not natively store reliable last-usage dates, use Microsoft Purview audit logs or Entra sign-in logs as the data source for your Power BI reports.
SharePoint's hidden user information lists do not consistently update last-activity dates. To get accurate user activity and sign-in reporting, you must retrieve data from higher-level Microsoft 365 administrative centers and import those logs into Power BI.
Log into the Microsoft Purview compliance portal or Microsoft Entra admin center using your administrator credentials.
Navigate to the audit or sign-in logs section, filter the activity for SharePoint logins or page views, and export the data.
Open Power BI Desktop, use the 'Get Data' feature to import your exported log files, and build DAX measures to calculate the maximum date per user.
Consult the Microsoft Power BI Community
Seek advanced DAX and data modeling guidance directly from Power BI specialists.
Looking for a Free Office Suite? Try WPS Office
While WPS Office does not directly manage Power BI or SharePoint audit logs, it is an excellent, lightweight alternative for viewing exported log data, creating reports, and handling daily document tasks. Enjoy high compatibility with Microsoft formats, a familiar user interface, and seamless migration completely for free.
- 1. Download WPS Office: Visit the official WPS website to download and install the free office suite.
- 2. Open Exported Data: Launch WPS Spreadsheet and easily open your exported SharePoint CSV or Excel audit logs.
- 3. Analyze and Share: Use built-in pivot tables and filtering tools to review sign-in dates before importing them to Power BI.
Frequently Asked Questions
Does SharePoint store users' last sign-in dates natively?
No, SharePoint's internal hidden user lists do not reliably track or update the last time a user signed in or visited a page. For accurate tracking, external audit logs must be used.
Where can I find reliable SharePoint usage and sign-in data?
Reliable sign-in data and page-visit metrics can be found in Microsoft Entra sign-in logs, Microsoft Purview audit logs, or standard Microsoft 365 usage reports.
How can I automate fetching these logs into Power BI?
Instead of manually exporting CSV files, you can connect Power BI to the Microsoft Graph API or use the Microsoft 365 Usage Analytics template app to automate data retrieval.
