Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.