Forum Discussion
edit data in editqueries
Hi All !
I had uploaded my data from CSV file as data source. Then i need to edit some of my data. Instead of i edit on CSV file then refresh in PBI, is there any other way that i can edit data through Power Bi. I have try to use edit queries, but it doesnt work if i want to change my data.
In general, editing data in "Edit Queries" is done by using the rich library of Power Query functions and other Power Query language components, e.g. adding columns, replacing values etcetera.
If you really want to edit your data, it can only be done by creating a copy of your table and paste it in "Enter Data". There you can edit the data, but the copy will not be dynamically updated with any changes in the csv files.
My suggestion would be to edit the csv files (or use the rich library..... etcetera).
Here is a video that illustrates how to copy and edit data using "Enter Data":
