Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using PowerBi Desktop to access the Microsoft Security Graphs, when I try and get any data this is the error that I recieve. I have done my research and cannot find out how to fix this, any advise would be appreciated !!
Error:
ole db or ODBC error: [Datasource.error] MicrosoftGraphSecurity
Request failed: The remote server returned an error: (400)Bad Request (max result set size 6200 cannot
exceed 6000)
Solved! Go to Solution.
Was told to address my issue i have to do the following
include only $top and not $skip in your first GET query. You can use @odata.nextLink for pagination. If you need to use $skip, it has a limit of 500 alerts. For example, /security/alerts?$top=10&$skip=500 will return a 200 OK response code, but /security/alerts?$top=10&$skip=501 will return a 400 Bad Request response code. For more information, see Microsoft Graph Security API error responses.
A work around for this limit is to use the $filter OData query parameter with the eventDateTime of the alert entity from the Microsoft Graph Security API, using ?$filter=eventDateTime gt {YYYY-MM-DDT00:00:00.000Z} and replacing the dateTime value with the last (1500th) alert. You can also set a range for the eventDateTime; for example, alerts?$filter=eventDateTime gt 2018-11-11T00:00:00.000Z&eventDateTime lt 2018-11-12T00:00:00.000Z
Utilize the "$filter" parameter to control the results returned to function below the 6000 limitation.
However I do not have enough experience on how to perform this but wanted top post what was recommended by Microsoft.
Hi @Anonymous
From this error message, it seems there are too many your queries to exceed the limiations of the API.
If so, please limit the results.
https://docs.microsoft.com/en-us/graph/known-issues#query-parameter-limitations
this error status code also indicates if the query is correct. please check if you do the right steps.
https://docs.microsoft.com/en-us/power-bi/desktop-connect-graph-security
You can connect to it via Odata connector or write queries in Advanced editor.
Best Regards
Maggie
Was told to address my issue i have to do the following
include only $top and not $skip in your first GET query. You can use @odata.nextLink for pagination. If you need to use $skip, it has a limit of 500 alerts. For example, /security/alerts?$top=10&$skip=500 will return a 200 OK response code, but /security/alerts?$top=10&$skip=501 will return a 400 Bad Request response code. For more information, see Microsoft Graph Security API error responses.
A work around for this limit is to use the $filter OData query parameter with the eventDateTime of the alert entity from the Microsoft Graph Security API, using ?$filter=eventDateTime gt {YYYY-MM-DDT00:00:00.000Z} and replacing the dateTime value with the last (1500th) alert. You can also set a range for the eventDateTime; for example, alerts?$filter=eventDateTime gt 2018-11-11T00:00:00.000Z&eventDateTime lt 2018-11-12T00:00:00.000Z
Utilize the "$filter" parameter to control the results returned to function below the 6000 limitation.
However I do not have enough experience on how to perform this but wanted top post what was recommended by Microsoft.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |