Forum Discussion

PG03's avatar
PG03
Frequent Visitor
4 years ago
Solved

Log Analytics Data Missing

I'm creating a report based on a simple Log Analytics query   SigninLogs | where AppDisplayName startswith "Windows Sign In" | where CreatedDateTime >= ago(7d)   This query returns 87,702 recor...
Need Help
  • PG03's avatar
    PG03
    4 years ago

    I figured out the problem.  In the query I was projecting a column that was a JSON record.  Removing this column from the query normalized the results.

parry2k's avatar
parry2k
Super User
4 years ago

PG03 are you exporting from Power BI or exporting to Power BI, not fully clear where you are exporting to/from?

  • PG03's avatar
    PG03
    Frequent Visitor
    4 years ago

    I'm using the Log Analytics "export" command to generate the M query