search

microsoft / MicrosoftDefenderForEndpoint-PowerBI

A repo for sample MDATP Power BI Templates
MIT License
177 stars 53 forks source link

Error opening .pbit file #3

Closed ratson31 closed 4 years ago

ratson31 commented 4 years ago

On opening the pbit and doing the initial refresh, this error appears

TVM_DeviceConfigurationAssesmentKB The column 'RelatedMitreTechniques' of the table wasn't found.

richlilly2004 commented 4 years ago

You can open "Transform Data", Select TVM_DeviceConfigurationAssesmentKB, Advanced Editor, and remove the following rows (including the trailing comma):

,

"Expanded RelatedMitreTechniques" = Table.ExpandListColumn(#"Expanded ConfigurationBenchmarks", "RelatedMitreTechniques"),

#"Expanded RelatedMitreTactics" = Table.ExpandListColumn(#"Expanded RelatedMitreTechniques", "RelatedMitreTactics")

and replace #"Expanded RelatedMitreTactics" at the bottom with Table"