'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Create a Power BI Report for SharePoint Views by User ID
Question details
The user needs to create a Power BI report that measures SharePoint Online news post views categorized by employee type from Microsoft Entra ID.
- Product
- Power BI / SharePoint Online
- Device & OS
- not provided
- Scenario
- Analyzing SharePoint news post engagement at a user-level by linking audit logs with employee demographic data.
- Observed behavior
- User-level visit data requires extraction from Purview audit logs and complex integration with Microsoft Graph APIs and Entra ID data.
Ensure you have the necessary administrative privileges to access Microsoft Purview audit logs, SharePoint usage data, and Microsoft Entra ID (formerly Azure AD).
Consult Microsoft Communities for Advanced API Integration
Because this task involves complex integrations across multiple Microsoft services, seeking guidance from specialized Microsoft communities is the best path.
Extracting user-level SharePoint audit data and combining it with Entra ID employee types requires specialized usage of Microsoft Graph APIs and Power BI data modeling.
Determine exactly which events in the Purview audit log correspond to viewing SharePoint Online news posts.
Document your specific requirements, including how you plan to link the Entra ID user demographic data with the SharePoint audit events.
Navigate to the official Microsoft Power BI or Microsoft Fabric community forums and post your detailed query for expert architectural guidance.
Enhance Your Daily Productivity with WPS Office
While specialized data modeling with Power BI and SharePoint requires Microsoft's ecosystem, WPS Office provides a lightweight, comprehensive suite for your everyday document, spreadsheet, and presentation needs.
- 1. Download the Software: Visit the official WPS Office website to download the free installation package.
- 2. Install and Launch: Run the installer and open WPS Office on your desktop or mobile device.
- 3. Analyze Data: Open WPS Spreadsheet to import your exported log data and create customized charts.
Frequently Asked Questions
Can Power BI connect directly to SharePoint usage data?
Yes, Power BI can natively connect to SharePoint list and folder data, but accessing detailed, user-level audit logs usually requires connecting to the Microsoft 365 compliance center or using Microsoft Graph APIs.
How do I get employee roles from Microsoft Entra ID into Power BI?
You can use the Microsoft Graph API or the Azure Active Directory connector in Power BI to import user profile data, including employee types and job titles.
Why isn't user-level visit data available in standard SharePoint analytics?
Standard SharePoint site analytics provide aggregated page views to protect user privacy. Tracking individual views by user ID requires administrative access to backend Purview audit logs.
