Skip to content
This repository has been 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

Open
KhaaliTurbo opened this issue Nov 30, 2021 · 0 comments

Comments

@KhaaliTurbo
Copy link

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.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant