Forum Discussion
Blank column editable and savable in Excel
Hi all, I would like to know please if there is a possibility to insert a blank column in the editor of Power Query that could be fulfill in the Excel spreadsheet and then saved historicizing the...
v-yingjl
Community Support
Community SupportHi sigamtr3 ,
Power Query is used to transform data, not saving history data. Each time when you click the refresh button, Power Query would send queries to the data source to get the latest data.
If you want to save history data in Power Query editor, perhaps you need to create extra tables to save history data and try to combine them with the source table.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.