This repository was archived by the owner on Nov 16, 2023. It is now read-only.
This repository was archived by the owner on Nov 16, 2023. It is now read-only.
Microsoft-365-Defender-Hunting-Queries/M365-PowerBi Dashboard/: Table 'Software' contains a duplicate value #433
Description
Log from Power BI Desktop x64, Version: 2.99.782.0 64-bit (November 2021):
AadUsers
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
Alerts
Load was cancelled by an error in loading a previous table.
ConfigurationScore
Load was cancelled by an error in loading a previous table.
ExposureScore
Load was cancelled by an error in loading a previous table.
ExposureScoreByMachineGroups
Load was cancelled by an error in loading a previous table.
Indicators
Load was cancelled by an error in loading a previous table.
Investigations
Load was cancelled by an error in loading a previous table.
MachineActions
Load was cancelled by an error in loading a previous table.
Machines
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
Recommendations
Load was cancelled by an error in loading a previous table.
Software
Column 'name' in Table 'Software' contains a duplicate value 'chromium' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
SoftwareInventoryByMachine
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
SoftwareVulnerabilitiesByMachine
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
Vulnerabilities
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
EndpointAgentHealthStatus
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
ConnectivityFailure
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
MicrosoftEOSStatus
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
SecureConfigurationsAssessmentByMachine
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
Using M365-PowerBi Dashboard/Microsoft Threat Protection - API Dashboard.pbit, 76b3d2c
Please advise.