Adding column to original data, PQ

[Tigerexcel]

I thought this would be easy but I haven't been able to do this yet. If you have a table which was used to produce a query and then you add a column to the original table, this could be something like an extra month, how do you get the query to update with the new column. I thought that refresh would be sufficient but it doesn't work. The original table remains the same and I can't change the dimensions to include the new column.

Ultimately it would be nice to make the original table dynamic so that any new rows/columns would be reflected in the new query, how would this be done?

 

[sandy666]

remove Changed Type line and try again

 

[Tigerexcel]

Hi again Sandy,

What about if there is no Changed Type line?

 

[sandy666]

What about if there is no Changed Type line?

use XL2BB to post source table
post your M with code tags
describe what you want to do

 

[Tigerexcel]

use XL2BB to post source table
post your M with code tags
describe what you want to do

I haven't had much success with XL2BB but I'll try and download it again.
I've just found that if I go into Table Design I can extend the table and load it again, but there must be a more seamless way of the Query adjusting for a change in table dimension be it row or column addition.

 

[sandy666]

you can do that with excel file,
post a link to the shared excel file with source table, expected result, using onedrive, googledrive, dropbox or any similar service

it all depends on how your code works