Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi. Asking for your help regarding transforming my table.
I wish to remove blank rows in my table based on blank cells of column 'Talk Title'
I tried to modify the code below in power query but an error occured.
#"Removed Blank Rows" = Table.SelectRows(#"Renamed Columns3", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}),each try Text.Clean(Text.Trim(_)) otherwise _ ),{""})
in
#"Removed Blank Rows"
Hoping for your help. Thank you.
-Third
Solved! Go to Solution.
Hi @third_hicana ,
Are you just trying to remove any rows where [Talk Title] is blank?
If so, then the following step should work:
Table.SelectRows(
PreviousStepName,
each [Talk Title] <> ""
)
You may need to adjust the "" bit, depending on whether your your non-null values in that column are "", " ", " " etc.
Pete
Proud to be a Datanaut!
Hi @third_hicana ,
Are you just trying to remove any rows where [Talk Title] is blank?
If so, then the following step should work:
Table.SelectRows(
PreviousStepName,
each [Talk Title] <> ""
)
You may need to adjust the "" bit, depending on whether your your non-null values in that column are "", " ", " " etc.
Pete
Proud to be a Datanaut!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.