"Remove Errors" does not work on desktop

[hgorina]

Rows with errors are not being removed after applying remove errors to columns or an entire table.

let
    Source = Folder.Files("X:\Projects\DA_BIM_Resources\BIMLIST-forReports"),
    #"Filtered Rows1" = Table.SelectRows(Source, each ([Extension] = ".bldb")),
    #"Expanded Attributes1" = Table.ExpandRecordColumn(#"Filtered Rows1", "Attributes", {"Size"}, {"Attributes.Size"}),
    #"Removed Other Columns" = Table.SelectColumns(#"Expanded Attributes1",{"Name", "Date accessed", "Date modified", "Date created", "Attributes.Size", "Folder Path"}),
    #"Added Custom Path" = Table.AddColumn(#"Removed Other Columns", "Path", each [Folder Path] & [Name]),
    #"getXML Table0" = Table.AddColumn(#"Added Custom Path", "XML Data", each getXML_Table0_DatabaseInfo([Path])),
    #"Expanded XML Data" = Table.ExpandTableColumn(#"getXML Table0", "XML Data", {"ID", "Name", "LastUpdatedDate", "RemoteServerAddress", "CreatedBy", "LastUpdateBy"}, {"database.ID", "database.Name", "database.LastUpdatedDate", "database.RemoteServerAddress", "database.CreatedBy", "database.LastUpdateBy"}),
    #"getXML Table 2 - contentItems" = Table.AddColumn(#"Expanded XML Data", "Custom", each getXML_Table2_ContentItems([Path])),
    #"Expand ContentItems" = Table.ExpandTableColumn(#"getXML Table 2 - contentItems", "Custom", {"ID", "Name", "CategoryID", "Path", "AverageRating", "TotalLoadCount"}, {"ContentItem.ID", "ContentItem.Name", "ContentItem.CategoryID", "ContentItem.Path", "ContentItem.AverageRating", "ContentItem.TotalLoadCount"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expand ContentItems",{"ContentItem.AverageRating", "ContentItem.TotalLoadCount", "database.LastUpdateBy", "ContentItem.ID", "ContentItem.Name", "ContentItem.CategoryID", "database.LastUpdatedDate", "database.RemoteServerAddress", "database.CreatedBy", "Path", "database.ID", "Date created", "Attributes.Size", "Folder Path", "Name", "Date accessed", "Date modified"}),
    #"Split Column by Delimiter1" = Table.SplitColumn(#"Removed Columns","ContentItem.Path",Splitter.SplitTextByEachDelimiter({"\"}, QuoteStyle.Csv, true),{"ContentItem.Path.1", "ContentItem.Path.2"}),
    #"Removed Columns1" = Table.RemoveColumns(#"Split Column by Delimiter1",{"ContentItem.Path.2"}),
    #"Removed Duplicates" = Table.Distinct(#"Removed Columns1"),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates",{{"ContentItem.Path.1", "PathsUnique"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each Text.StartsWith([PathsUnique], "S:\_Firmwide\BIMListContent\2017") and Text.Contains([PathsUnique], "Area Tags")),
    #"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"PathsUnique", Order.Ascending}}),
    #"Added Custom" = Table.AddColumn(#"Sorted Rows", "AllFilesInAllFolders", each Folder.Files([PathsUnique])),
    #"Expanded AllFilesInAllFolders" = Table.ExpandTableColumn(#"Added Custom", "AllFilesInAllFolders", {"Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}, {"Name", "Extension", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path"}),
    #"Removed Errors" = Table.RemoveRowsWithErrors(#"Expanded AllFilesInAllFolders")
in
    #"Removed Errors"

[v-haibl-msft]

@hgorina

I’ve reported it internally to Power BI Team: CRI 39760308
I’ll post here once I get any update about it.

Best Regards,
Herbert

[hgorina]

Thanks!
I should mention that the goal of this is to determine if any files in the list were deleted/renamed. I have a list of folders the oridinal data was being reported and this query tries to get all files from all listed folders. It errors when file or folder does not exist. So deleting errors os crucial for further processing

While  this bug is being worked on, perhaps you can recommend some other method to check whether folder and file exist?

thanks again!

[Ehren]

Hi there. What error message do you see if you select one of the error cells?

Ehren

[hgorina]

hello

I am traveling and unable to answer in detail right now. However I have resolved the issue by adding a try statement before the error appears. this catches the attempt to create an attribute table from a file/folder which does not exist. Still gives an error but I can use keep or remove to get the data proccessed as needed.

Still, it is a serious bug. I will add more info when I land

Thanks!