Forum Discussion
Excel Table List, Property Columns disappearing in Power Query
I have a number of Source data Excel Files which all have an identical structure. All have the same queries that load into the files and the same named ranges. I have checked and all the queries ha...
First check the privacy settings of the query to see if the organization remembers not to select This Source Only. If it doesn't work, create a new query, merge the old data into it, and then reload the data in Excel using the From Table function.
Remember to update your Excel and Power Query to the latest version, or if that doesn't work, add the columns manually to make it work.