Power Query Issue - new column not found

[BrettOlbrys1]

Hello. I have an existing query which works perfectly. I've added a new column of data to the end of the original table the query is referencing, but when I refresh the data, the query is not seeing that new column for me to be able to choose in my reordered columns function.

How do I get this new column to show up for me to be able to choose it?

Thanks

Brett

 

[zero269]

Hello. I have an existing query which works perfectly. I've added a new column of data to the end of the original table the query is referencing, but when I refresh the data, the query is not seeing that new column for me to be able to choose in my reordered columns function.

How do I get this new column to show up for me to be able to choose it?

Thanks

Brett

Hi Brett,

I'm not well versed on Power Query, but do use it from time to time.

Out of curiosity, did you add that new column within the Excel Worksheet where your data is being Refreshed, or did you add it within the Power Query Editor?
If it was the Worksheet, then that column is not part of the Query being updated. I actually use one myself like that because I have a formula in that far right column that's not part of my Query.

If you added the column within the Power Query Editor for the data that's being "loaded" into your Worksheet, then that would definitely require some assistance from someone more knowledgeable on this topic.

 

[BrettOlbrys1]

Hi Brett,

I'm not well versed on Power Query, but do use it from time to time.

Out of curiosity, did you add that new column within the Excel Worksheet where your data is being Refreshed, or did you add it within the Power Query Editor?
If it was the Worksheet, then that column is not part of the Query being updated. I actually use one myself like that because I have a formula in that far right column that's not part of my Query.

If you added the column within the Power Query Editor for the data that's being "loaded" into your Worksheet, then that would definitely require some assistance from someone more knowledgeable on this topic.

I did not add the column within the Power Query Editor, I added it to the original source table. My scenario is that I have an export of raw data that occupies columns A thru Z, but I only need the data from 6 of those columns. So, I create a "Connection Only" to the raw data and in a second sheet, I load the six columns of only the data I actually need. And both the raw data and the new sheet of data are formatted as tables with table names.

Now, let's say I want to add a column "AA" to the original raw data (that was A to Z columns) so that it will be pulled into the second sheet as a 7th column when the data is refreshed. The query for the second sheet looks to the Table Name in the first sheet, and since "AA" is now a part of the Table, Power Query should give me the option of choosing that column to add to my second sheet when I use the Choose Columns" function.

BUT, my new column "AA" does not appear in the "Choose Columns" function, and I can't figure out how to get it added so I can choose it for the second sheet as a 7th column.

 

[GraH]

PQ uses a 'historized' version of the data, even in the preview. Press the refresh inside of PQ.
Your new column should appear.
Now it is likely you have some hardcoded column names somewhere in your query statement. Reorder of columns is one of the causes. It's a bit advanced to deal with those, but it's doable.