let
source = SecMgmtInsights.Contents(GetTenantsList()),
summary= source{[Name="SoftwareUpdateStatusSummary"]}[Data],
output = Table.FirstN(summary, 999)
in
output
Expected behavior
Either an exception to be thrown or for the query to remove the $top parameter before making the call to the API
Actual behavior
The API is returning a HTTP 400 error and even if the FirstN command is not used the data is not show because this API does not support paging. Currently the connector is configured in a way where it would expect the API to have paging support.
Diagnostic logs
N/A
Environment
Power BI Desktop
Security and Management Insights connector version 2.1
Steps to reproduce
Invoke the following query
Expected behavior
Either an exception to be thrown or for the query to remove the $top parameter before making the call to the API
Actual behavior
The API is returning a HTTP 400 error and even if the FirstN command is not used the data is not show because this API does not support paging. Currently the connector is configured in a way where it would expect the API to have paging support.
Diagnostic logs
N/A
Environment