How can i delete this column from my data flow query.
let
Source = SharePoint.Tables("https://sites.bms.com/teams/DIG/", [ApiVersion = 15]),
Navigation = Source{[Id = "da0c51c3-ab2b-4238-82a9-7672cb2f06b4"]}[Items],
#"Expanded ITBP" = Table.ExpandRecordColumn(Navigation, "ITBP", {"FirstName", "LastName"}, {"ITBP.FirstName", "ITBP.LastName"}),
#"Renamed columns 1" = Table.RenameColumns(#"Expanded ITBP", {{"Benefits/Outcome Dri", "Benefits Outcome Drivers"}, {"Portfolio Governance_x0020", "PortfolioGovernanceAndDeliveryLead"}, {"Primary Delivery Tow", "Primary Delivery Tower"}}),
#"Expanded PortfolioGovernanceAndDeliveryLead" = Table.ExpandRecordColumn(#"Renamed columns 1", "PortfolioGovernanceAndDeliveryLead", {"FirstName", "LastName"}, {"PortfolioGovernanceAndDeliveryLead.FirstName", "PortfolioGovernanceAndDeliveryLead.LastName"}),
#"Expanded AncillaryDeliveryTowerS" = Table.ExpandTableColumn(#"Expanded PortfolioGovernanceAndDeliveryLead", "Ansillary Delivery T", {"Value"}, {"AncillaryDeliveryTowerS.Value"}),
#"Expanded CEO3DCM" = Table.ExpandRecordColumn(#"Expanded AncillaryDeliveryTowerS", "CEO-3 DCM", {"FirstName", "LastName"}, {"CEO3DCM.FirstName", "CEO3DCM.LastName"}),
#"Expanded PrimaryDCM" = Table.ExpandRecordColumn(#"Expanded CEO3DCM", "Primary DCM", {"FirstName", "LastName"}, {"PrimaryDCM.FirstName", "PrimaryDCM.LastName"}),
#"Expanded PortfolioDeliveryLead" = Table.ExpandRecordColumn(#"Expanded PrimaryDCM", "Portfolio Delivery L", {"FirstName", "LastName"}, {"PortfolioDeliveryLead.FirstName", "PortfolioDeliveryLead.LastName"}),
#"Expanded CEO3BP" = Table.ExpandRecordColumn(#"Expanded PortfolioDeliveryLead", "CEO-3 BP", {"FirstName", "LastName"}, {"CEO3BP.FirstName", "CEO3BP.LastName"}),
#"Renamed columns 2" = Table.RenameColumns(#"Expanded CEO3BP", {{"Functional Investment_x002", "FunctionalInvestmentCategories.Value"}}),
#"Added custom" = Table.AddColumn(#"Renamed columns 2", "CEO-3 BP", each [CEO3BP.FirstName] & " " & [CEO3BP.LastName]),
#"Removed columns 2" = Table.RemoveColumns(#"Added custom", {"CEO3BP.FirstName", "CEO3BP.LastName"}),
#"Added custom 1" = Table.AddColumn(#"Removed columns 2", "Portfolio Delivery Lead", each [PortfolioDeliveryLead.FirstName] & " " & [PortfolioDeliveryLead.LastName]),
#"Removed columns 3" = Table.RemoveColumns(#"Added custom 1", {"PortfolioDeliveryLead.FirstName", "PortfolioDeliveryLead.LastName"}),
#"Added custom 2" = Table.AddColumn(#"Removed columns 3", "Primary DCM", each [PrimaryDCM.FirstName] & " " & [PrimaryDCM.LastName]),
#"Removed columns 4" = Table.RemoveColumns(#"Added custom 2", {"PrimaryDCM.FirstName", "PrimaryDCM.LastName"}),
#"Added custom 3" = Table.AddColumn(#"Removed columns 4", "CEO-3 DCM", each [CEO3DCM.FirstName] & " " & [CEO3DCM.LastName]),
#"Removed columns 5" = Table.RemoveColumns(#"Added custom 3", {"CEO3DCM.FirstName", "CEO3DCM.LastName"}),
#"Added custom 4" = Table.AddColumn(#"Removed columns 5", "ITBP", each [ITBP.FirstName] & " " & [ITBP.LastName]),
#"Removed columns 6" = Table.RemoveColumns(#"Added custom 4", {"ITBP.FirstName", "ITBP.LastName"}),
#"Added custom 5" = Table.AddColumn(#"Removed columns 6", "Portfolio Governance And Delivery Lead", each [PortfolioGovernanceAndDeliveryLead.FirstName] & " " & [PortfolioGovernanceAndDeliveryLead.LastName]),
#"Removed columns 7" = Table.RemoveColumns(#"Added custom 5", {"PortfolioGovernanceAndDeliveryLead.FirstName", "PortfolioGovernanceAndDeliveryLead.LastName"}),
#"Transform columns" = Table.TransformColumnTypes(#"Removed columns 7", {{"CEO-3 BP", type text}, {"Portfolio Delivery Lead", type text}, {"Primary DCM", type text}, {"CEO-3 DCM", type text}, {"ITBP", type text}, {"Portfolio Governance And Delivery Lead", type text}}),
#"Replace errors" = Table.ReplaceErrorValues(#"Transform columns", {{"CEO-3 BP", null}, {"Portfolio Delivery Lead", null}, {"Primary DCM", null}, {"CEO-3 DCM", null}, {"ITBP", null}, {"Portfolio Governance And Delivery Lead", null}}),
#"Removed columns" = Table.RemoveColumns(#"Replace errors", {"ServerRedirectedEmbedUri", "ServerRedirectedEmbedUrl", "FileSystemObjectType", "OData_2020 Functional_x002", "ITBPId", "ITBPStringId", "Portfolio Governance_x0020StringId", "Portfolio Governance_x0020Id", "ContentTypeId", "ComplianceAssetId", "AuthorId", "EditorId", "CEO-3 DCMId", "CEO-3 DCMStringId", "Primary DCMId", "Primary DCMStringId", "ITBP (Temp)", "CEO-3 DCM _x00", "Primary DCM (T", "Portfolio Delivery LId", "Portfolio Delivery LStringId", "Portfolio Delivery L0", "Portfolio Governance_x00200", "CEO-3 BP _x002", "field1", "field2", "field3", "field4", "field5", "field6", "Toggle2", "ldzd", "ID", "OData__UIVersionString", "Attachments", "GUID", "FirstUniqueAncestorSecurableObject", "RoleAssignments", "AttachmentFiles", "ContentType", "GetDlpPolicyTip", "FieldValuesAsHtml", "FieldValuesAsText", "FieldValuesForEdit", "File", "Folder", "LikedByInformation", "ParentList", "Properties", "Versions", "Author", "Editor"}),
#"Renamed columns" = Table.RenameColumns(#"Removed columns", {{"Title", "Name"}, {"Business Unit _x002e", "Business Unit.Full"}, {"Regulatory (Governme", "Regulatory Government Mandated"}, {"OData_2020 $ I", "Current Year Impact"}, {"Cost to Complete", "Cost To Complete"}, {"OData_2020 Digital I", "DigitalInvestmentCategoriesValue"}, {"Projected Start Quar", "ProjectedStart"}, {"Projected End Month_", "ProjectedEnd"}, {"OData_2020 Temp _x00", "C_2020TempCapitalEstimate"}, {"OData_2020 Temp _x000", "C_2020TempExpenseEstimate"}, {"Celgene / Disc", "CelgeneDiscussionNotes"}, {"Possible Duplicate _", "Possible Duplicate"}, {"Demand ID", "DemandID"}, {"BMS Old PPM ID", "BMSOldPPMID"}, {"SN vPPM ID", "SNVPPMID"}, {"ePM ID", "EPMID"}, {"AncillaryDeliveryTowerS.Value", "Ancillary Delivery Tower"}, {"VCA ID", "VCAID"}, {"Business Unit", "BusinessUnit"}}),
#"Removed columns 1" = Table.RemoveColumns(#"Renamed columns", {"Temp Current 2020_x0", "Midpoint of 2020_x00", "Midpoint of 2020_x000", "Midpoint of 2020_x001", "Classification", "CEO-3 BPId", "CEO-3 BPStringId"}),
#"Renamed columns 3" = Table.RenameColumns(#"Removed columns 1", {{"Reporting Current 20", "ReportingMidpointIncorporatingTemp2020Est"}, {"Reporting – Mi", "ReportingMidpointIncorporatingTemp2020EstHighLevel"}, {"Reporting – Mi0", "ReportingMidpointIncorporatingTemp2020EstLowLevel"}, {"Classification (calc", "Classification"}}),
#"Transform columns 1" = Table.TransformColumnTypes(#"Renamed columns 3", {{"Id", type text}, {"Name", type text}, {"Business Unit.Full", type text}, {"Priority", type text}, {"Regulatory Government Mandated", type text}, {"Current Year Impact", type text}, {"Cost To Complete", type text}, {"Benefits Outcome Drivers", type text}, {"DigitalInvestmentCategoriesValue", type text}, {"ProjectedStart", type text}, {"ProjectedEnd", type text}, {"Status", type text}, {"C_2020TempCapitalEstimate", type text}, {"C_2020TempExpenseEstimate", type text}, {"CelgeneDiscussionNotes", type text}, {"Possible Duplicate", type text}, {"Possible RUN", type text}, {"DemandID", type text}, {"BMSOldPPMID", type text}, {"SNVPPMID", type text}, {"EPMID", type text}, {"Funded By", type text}, {"Primary Delivery Tower", type text}, {"Ancillary Delivery Tower", type text}, {"Modified", type text}, {"Created", type text}, {"VCAID", type text}, {"BusinessUnit", type text}, {"ReportingMidpointIncorporatingTemp2020Est", type text}, {"HighLevelDescription", type text}, {"ReportingMidpointIncorporatingTemp2020EstHighLevel", type text}, {"ReportingMidpointIncorporatingTemp2020EstLowLevel", type text}, {"Classification", type text}, {"FunctionalInvestmentCategories.Value", type text}, {"Comments", type text}}),
#"Replace errors 1" = Table.ReplaceErrorValues(#"Transform columns 1", {{"Id", null}, {"Name", null}, {"Business Unit.Full", null}, {"Priority", null}, {"Regulatory Government Mandated", null}, {"Current Year Impact", null}, {"Cost To Complete", null}, {"Benefits Outcome Drivers", null}, {"DigitalInvestmentCategoriesValue", null}, {"ProjectedStart", null}, {"ProjectedEnd", null}, {"Status", null}, {"C_2020TempCapitalEstimate", null}, {"C_2020TempExpenseEstimate", null}, {"CelgeneDiscussionNotes", null}, {"Possible Duplicate", null}, {"Possible RUN", null}, {"DemandID", null}, {"BMSOldPPMID", null}, {"SNVPPMID", null}, {"EPMID", null}, {"Funded By", null}, {"Primary Delivery Tower", null}, {"Ancillary Delivery Tower", null}, {"Modified", null}, {"Created", null}, {"VCAID", null}, {"BusinessUnit", null}, {"ReportingMidpointIncorporatingTemp2020Est", null}, {"HighLevelDescription", null}, {"ReportingMidpointIncorporatingTemp2020EstHighLevel", null}, {"ReportingMidpointIncorporatingTemp2020EstLowLevel", null}, {"Classification", null}, {"FunctionalInvestmentCategories.Value", null}, {"Comments", null}}),
#"Changed column type" = Table.TransformColumnTypes(#"Replace errors 1", {{"ProjectedStart", type datetime}, {"ProjectedEnd", type datetime}, {"C_2020TempCapitalEstimate", type number}, {"C_2020TempExpenseEstimate", type number}, {"Modified", type datetime}, {"Created", type datetime}, {"ReportingMidpointIncorporatingTemp2020EstHighLevel", type number}, {"ReportingMidpointIncorporatingTemp2020EstLowLevel", type number}, {"ReportingMidpointIncorporatingTemp2020Est", type number}})
in
#"Changed column type"
