Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

M Intellisense stops working after try expression

I have been using the try expression to add an error details column in my reports (inspired by this blog post).

 

let
    Source = #table({"SomeColumn", "AnotherColumn" }, { {1, error "help"}, { 2, "B"}, { error "bad", "C"} }),
    RowErrorsToTable =
        (row as record) as nullable table => let
            RecordToTable = Record.ToTable(row),
            AddedErrorsColumn = Table.AddColumn(RecordToTable, "Errors", each let Test = try [Value] in if Test[HasError] = true then Test[Error] else null),
            RemovedDataColumn = Table.RemoveColumns(AddedErrorsColumn, {"Value"}),
            FilteredToErrors = Table.SelectRows(RemovedDataColumn, each [Errors] <> null)
        in
            if Table.IsEmpty(FilteredToErrors) then null else FilteredToErrors,
    AddedErrorsColumn = Table.AddColumn(Source, "Errors", RowErrorsToTable)
in
    AddedErrorsColumn

 

When I add this function, M Intellisense stops working. It no longer appears or provides relevant AutoFill suggestions. If I remove the function, Intellisense resumes. If I open another file, that doesn't have this function, then Intellisense works for that file.

 

I have tried this on different files and computers, both Excel and Power BI, and it consistently happens.

 

I am on the latest versions of Power BI and Excel (as of 15/04/2025 20:28 UTC).

 

I tried my best to post this in the correct area, but please let me know if I need to repost elsewhere.

Status: New