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

OData Select and Expand failed #135

Closed ghost closed 4 years ago

ghost commented 4 years ago

Steps to reproduce

Invoke the following query

 let
        source = SecMgmtInsights.Contents(GetTenantsList()),
        deviceMgmt = source{[Name="DeviceManagement"]}[Data],
        filteredTable = Table.SelectColumns(deviceMgmt, {"tenantId", "intuneAccountId"}),
        removedNullAccountIds = Table.SelectRows(filteredTable, each [intuneAccountId] <> null)
    in
        removedNullAccountIds

Expected behavior

The resulting table to contain the intuneAccounId column with data when the API returns it.

Actual behavior

The resulting table has a column named intuneAccounId, but all of the rows are null

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)

The following is output from the Microsoft Graph Explorer

{
    "error": {
        "code": "BadRequest",
        "message": "Parsing OData Select and Expand failed: Could not find a property named 'tenantId' on type 'microsoft.graph.deviceManagement'.",
        "innerError": {
            "date": "2020-09-21T19:22:24",
        }
    }
}

Environment

Power BI Desktop Security and Management Insights version 2.0