search

microsoft / secmgmt-insights-connector

Power BI connector that provides insight into the current state of how Microsoft 365 is configured and whether best practices have been implemented
MIT License
13 stars 3 forks source link

Software update status summary function #104

Closed ghost closed 4 years ago

ghost commented 4 years ago

Steps to reproduce

Run the following query 

let
    Source = SecMgmtInsights.Contents("Partner"),
    softwareUpdateStatusSummary = Source{[Name="SoftwareUpdateStatusSummary"]}[Data]
in
    softwareUpdateStatusSummary

Expected behavior

Available information from the API to be shown in the resulting table

Actual behavior

: The query specified in the URI is not valid. The requested resource is not a collection. Query options $filter, $orderby, $count, $skip, and $top can be applied only on collections.
Details:
    error=[Record]

Diagnostic logs

Exception:
ExceptionType: System.Net.WebException, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message: The remote server returned an error: (400) Bad Request.
StackTrace:
   at Microsoft.Mashup.Engine1.Library.Common.WrappingHttpWebRequest.WrapResponse(Func`1 getResponse)
   at Microsoft.Mashup.Engine1.Library.Web.Request.CreateResponse(ResourceCredentialCollection credentials)
   at Microsoft.Mashup.Engine1.Library.Web.Request.GetResponseCore(ResourceCredentialCollection credentials)
   at Microsoft.Mashup.Engine1.Library.Common.RetryPolicy.Execute[TResult](IEngineHost host, Func`1 func)
   at Microsoft.Mashup.Engine1.Library.Web.Request.GetResponse(ResourceCredentialCollection credentials, RetryPolicy retryPolicy, SecurityExceptionCreator securityExceptionCreator, Boolean tokenRefreshed)

Note the HTTP request where this is failing is https://graph.microsoft.com/beta/deviceManagement/softwareUpdateStatusSummary?%24top=999

Environment

Windows 10 Power BI Desktop SecMgmtInsights version 2.0-preview-1