Forum Discussion
Jossy
10 years agoRegular Visitor
Phantom field removal!
Hi, I've just tried to refresh a report and it's erroring because it can't find the "Notes_1" field. The data source has never had a "Notes_1" field - only a "Notes" field - guess something has g...
Greg_Deckler
Community Champion
10 years agoCheck your query using Edit Query. Sometimes if you add steps, etc, it messes up subsequent steps and you get weird things going on. Check your Advanced View in your query, copy and paste to Notepad or something and do a find for Notes_1.
Greg_Deckler
Community Champion
10 years agoJossy - Couldn't reply to your response, I think because the M code messes up Lithium if not posted in code block, but copy and paste and backup your query then select all and try pasting in this version:
let
Source = Excel.Workbook(File.Contents("C:\Users\Philip.Joss\OneDrive for Business\Clients (Current)\Iglo\Iglo spend&opp analysis v4.xlsx"), null, true),
Projects_Sheet = Source{[Item="Projects",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Projects_Sheet),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Category", type text}, {"Sub-category", type text}, {"PRISM ID", Int64.Type}, {"Project name", type text}, {"Notes", type text}, {"Site", type text}, {"Spend", type number}, {"Addressable spend %", type number}, {"Addressable spend €", type number}, {"Typical annualised savings % (LOW)#(lf)", type number}, {"Typical annualised savings % (HIGH)", type number}, {"Annualised savings € (LOW)", type number}, {"Annualised savings € (HIGH)", type number}, {"How confident are we the HIGH savings are accessible? Don't consider feasibility/ business support/time.", type number}, {"Annualised savings € (RISKED 1)", type number}, {"How feasible is the project and/or how likely is the project to be signed off by the business?", type number}, {"Annualised savings € (RISKED 2)", type number}, {"2016 start (month)", Int64.Type}, {"In-year savings € (RISKED 2)", type number}, {"How confident are we of the timelines? Don't consider stakeholder support - that should be a given for the purposes of this risk.", type number}, {"In-year savings € (RISKED 3)", type number}, {"FTE", type number}, {"Hours per week", type number}, {"Duration (months)", Int64.Type}, {"Annualised FTE equivilent", type number}, {"Annualised FTE equivilent (Stakeholder risk)", type number}, {"Company", type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Annualised savings € (RISKED 1)", "FY savings (Max potential)"}, {"Annualised savings € (RISKED 2)", "FY savings (Risked)"}, {"In-year savings € (RISKED 2)", "In-year savings (Risked)"}, {"In-year savings € (RISKED 3)", "In-year savings (Timeline risked)"}, {"Sub-category", "Category 2"}, {"Category", "Category 1"}})
in
#"Renamed Columns"