Forum Discussion

melina's avatar
melina
Helper IV
9 years ago
Solved

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 t...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

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

spuder's avatar
spuder
Resolver IV
9 years ago

Hi melina

 

The question is what exactly you want to edit.

 

Do you have some sample data or concret example?

  • melina's avatar
    melina
    Helper IV
    9 years ago

    Tq for your reply,

     

    i want to update link as selected below :

     

    • spuder's avatar
      spuder
      Resolver IV
      9 years ago

      So the variable in the link is BLUE?

       

      you can generate a userdefined column

       

       

      • melina's avatar
        melina
        Helper IV
        9 years ago

        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.