Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hi, a somewhat general question here:
Can I remove a column from a list of tables without adding a custom column?
I have a list of tables from a sharepoint site and I want to remove the default sharepoint "Title" field from each of those tables.
What I normally do is add a step in which I write
let
Source = Sharepoint.Tables("https://mysharepointsite",[ApiVersion=15]),
#"Added Custom" = Table.AddColumn(Source, "Custom", each Table.RemoveColumns([Items],"Title")),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Items"})
in
#"Removed Columns"
But do I really have to add a custom column then remove the other one? Is there a syntax where I can just modify the list of tables more directly?
Solved! Go to Solution.
Hi @one_eon ,
you should be able to do it like so:
let
Source = Sharepoint.Tables("https://mysharepointsite",[ApiVersion=15]),
OneStep = Table.TransformColumns(Source,{{"Items", Table.RemoveColumns(_,"Title"), type table}})
in
OneStep
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @one_eon ,
you should be able to do it like so:
let
Source = Sharepoint.Tables("https://mysharepointsite",[ApiVersion=15]),
OneStep = Table.TransformColumns(Source,{{"Items", Table.RemoveColumns(_,"Title"), type table}})
in
OneStep
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 12 | |
| 11 | |
| 7 | |
| 7 | |
| 6 |