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

The field 'signInActivity' of the record wasn't found #127

Closed ghost closed 4 years ago

ghost commented 4 years ago

Steps to reproduce

Run the following query against a set of customers where some users have never authenticated

let
    source = SecMgmtInsights.Contents(null),
    users = source{[Name="Users"]}[Data], 
    data = Table.SelectColumns(users, "signInActivity")
in
    data

Expected behavior

The resulting table should include data for all users where it exists.

Actual behavior

Expression.Error: The field 'signInActivity' of the record wasn't found.
Details:

Diagnostic logs

All functions were invoked as expected, the problem is the given field does not exist in all records

Environment

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