Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I'm working on a PowerBI report of SharePoint online site statistics. I need to be able to tell how many of our employees are viewing/visiting our news by their 'employee type' - data from our AAD.
I am struggling to find data outside of Audit via Purview that has a record of the visit/view that includes the userId of the action. Is it possible to get Sharepoint Audit data as an API?
I am working with Graph APIs mainly
Solved! Go to Solution.
This page may provide some answers for you.
Create auditLogQuery - Microsoft Learn
Proud to be a Super User! | |
This page may provide some answers for you.
Create auditLogQuery - Microsoft Learn
Proud to be a Super User! | |
Thank you for your help.
Do you know if it's possible to create a query via the API where I can specify the URL of the sharePoint sites with a wild card - like I can from the Purview portal
For example I'd like to only get auditData on "www.company.sharepoint.com/sites/XYZ*" - where * is a wildcard
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 5 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 15 | |
| 14 | |
| 11 | |
| 8 | |
| 8 |