Forum Discussion
Dataset not refreshing from table storage
Just figured out that the dataset was refreshing, the query just wasn't showing the new columns when I chose to 'Expand' the Content column. Apparently, it won't pick up the revisions automatically, you have to go into the query editor's query line and add the new column to be expanded (e.g. new_field) manually.
= Table.ExpandRecordColumn(data_set_name, "Content", {"new_field", "existing_field1", "existing_field2"}, {"new_field", "existing_field1", "existing_field2"})
Just figured out that the dataset was refreshing, the query just wasn't showing the new columns when I chose to 'Expand' the Content column. Apparently, it won't pick up the revisions automatically, you have to go into the query editor's query line and add the new column to be expanded (e.g. new_field) manually.
= Table.ExpandRecordColumn(data_set_name, "Content", {"new_field", "existing_field1", "existing_field2"}, {"new_field", "existing_field1", "existing_field2"})
Thanks so much. Worked a treat for me