Forum Discussion

sigamtr3's avatar
sigamtr3
New Member
4 years ago

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

 

Thanks in advance

Kind Regards

 

Simone

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    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.

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    4 years ago

    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.