Forum Discussion
List vulnerabilities API - Max results 8000?
Hi, Someone knows why there has been a limit since last December 2023 in the results of this request? I have built an powerbi report that connects and uses the information in tables from this api ...
Try following code, it will solve this issue: you can remove the exposedMachines condition if you want - skip is the important part
let
Source = OData.Feed("https://api.securitycenter.microsoft.com/api/vulnerabilities?$skip=8000", null, [Implementation="2.0"]),
Partial = if partial then Table.FirstN(Source, 50000) else Source,
#"Filtered Rows" = Table.SelectRows(Partial, each [exposedMachines] > 0)
in
#"Filtered Rows"
Hi !
I try the code under excel, advanced editor. I had the following error:
Expression.Error: Partial import does not correspond to any export. Have you forgotten a module reference?
Did I miss something ?
Thanks !
