Blank column editable and savable in Excel

[sigamtr3]

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 value in the editor.

Thanks in advance

Kind Regards

Simone

[v-yingjl]

Hi @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.

[lbendlin]

short answer is no.  Power BI has no data write back features. 

Long answer - there are various hacks and workarounds. Have a look at the PowerApps visual.  It allows you to capture user feedback and write that into an Excel file (for example).  Same with the Power Automate visual.