edit data in editqueries

[melina]

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.

[spuder]

Hi @melina

The question is what exactly you want to edit.

Do you have some sample data or concret example?

[melina]

Tq for your reply,

i want to update link as selected below :

[spuder]

So the variable in the link is BLUE?

you can generate a userdefined column

[melina]

No, that link is image link for blue cricle image.

i want to update the previous link with the new link.

not add a new coloum, just edit in that row.

Sorry, if i missunderstand yor previous reply.

[MarcelBeug · Accepted solution]

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":

[melina]

tq guys for your help. Really appreciate