microsoftgraph / microsoftgraph/msgraph-sdk-powershell
Get-MgBetaReportServicePrincipalSignInActivity fails
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 898
- Forks
- 230
- Avg merge
- 2d 5h
- Merged PRs (30d)
- 31
Description
Describe the bug
trying to pull ServicePrincipal Signin Data.
Get-MgBetaReportServicePrincipalSignInActivity
Authenticated as GA and Security Admin. Cannot get powershell query to return results. RAW API query is successful in Graph Explorer
Get-MgBetaReportServicePrincipalSignInActivity_List: User is not in the allowed roles
Status: 403 (Forbidden)
ErrorCode: Authentication_RequestFromUnsupportedUserRole
Date: 2026-02-20T00:29:35
Expected behavior
return proper JSON data for SP Signin activity
"@odata.context": "https://graph.microsoft.com/beta/$metadata#reports/servicePrincipalSignInActivities",
"@odata.nextLink": "https://graph.microsoft.com/beta/reports/servicePrincipalSignInActivities?$skiptoken=3f1d26a74d2c66ee0ffa2bd59ec9229ed6aace91038bc5e1509a55de05c5b150",
"@microsoft.graph.tips": "Use $select to choose only the properties your app needs, as this can lead to performance improvements. For example: GET reports/servicePrincipalSignInActivities?$select=appId,applicationAuthenticationClientSignInActivity",
"value": [
{
"id": "MDAwMDAwMDItMDAwMC0wMDAwLWMwMDAtMDAwMDAwMDAwMDAw",
"appId": "00000002-0000-0000-c000-000000000000",
"lastSignInActivity": {
"lastSignInDateTime": "2026-02-19T17:02:22.8258112Z",
"lastSignInRequestId": "db867493-60ee-4371-898a-8f6597750b00"
},
"delegatedClientSignInActivity": {
"lastSignInDateTime": null,
"lastSignInRequestId": null
},
"delegatedResourceSignInActivity": {
"lastSignInDateTime": "2026-02-19T17:02:22.8258112Z",
"lastSignInRequestId": "db867493-60ee-4371-898a-8f6597750b00"
},
"applicationAuthenticationClientSignInActivity": {
"lastSignInDateTime": null,
"lastSignInRequestId": null
},
"applicationAuthenticationResourceSignInActivity": {
"lastSignInDateTime": "2026-01-21T23:53:34.3439822Z",
"lastSignInRequestId": "54742ab6-89bd-4ff6-be5c-c42f673c1a00"
}
},
{
"id": "MzhhYTNiODctYTA2ZC00ODE3LWIyNzUtN2EzMTY5ODhkOTNi",
"appId": "38aa3b87-a06d-4817-b275-7a316988d93b",
"lastSignInActivity": {
"lastSignInDateTime": "2026-02-19T17:02:22.8258112Z",
"lastSignInRequestId": "db867493-60ee-4371-898a-8f6597750b00"
How to reproduce
Connect-MgGraph -Scopes "AuditLog.Read.all","Directory.Read.All"
Get-MgBetaReportServicePrincipalSignInActivity
SDK Version
No response
Latest version known to work for scenario above?
No response
Known Workarounds
No response
Debug output
Click to expand log
```</details>
### Configuration
_No response_
### Other information
_No response_
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with Get-MgBetaReportServicePrincipalSignInActivity and compare its request, permissions, and role handling with the successful Graph Explorer request. Reproduce it using Connect-MgGraph with the scopes listed in the issue. Done means the cmdlet returns the service-principal sign-in JSON or clearly identifies the required role discrepancy.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell
- Domain
- api, authorization, tooling
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100