Forum Discussion

JMarr123's avatar
JMarr123
Copper Contributor
Aug 23, 2024

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 have the same privacy setting of Organizational.

 

Previously the File Contents of the Source files would display like this in Power Query

 

 

 

And recently the file contents displays like this in Power Query. Which is missing the Columns for Item, Kind and Hidden

 

 

The result is that all the Power Queries that used to work are now breaking. If anyone can help me crack this case it would be hugely appreciated, I cant change my query because I need to combine the data from the old files and the new files. 

 

I am running Excel Version 2407 Build 16.0.17830.20056) 32-bit 

 

excel

1 Reply

  • Samuellasb's avatar
    Samuellasb
    Bronze Contributor
    Jun 05, 2025

    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.