Forum Discussion
JMarr123
Aug 23, 2024Copper Contributor
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...
Samuellasb
Jun 05, 2025Bronze Contributor
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.