How do you edit a blank table in dataflow?

I created a blank table data source in a dataflow, and am trying to figure out how to edit it now. In desktop, the applied step/source has a gears icon you can select that opens a window to edit the table. Data flow doesnt have the same icon, or at least I dont see anything obvious on how to edit it. Its not like other steps where you can just edit the m query - this has embedded the table data in binary, and then wrapped that with a bunch of m query commands to deflate the binary and make a table. Desktop does it in the same way, but you can still edit the table.

Am I missing something?

Need Help

v-yuta-msft

7 years ago

John1,

Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fZRBrsMwC.....", BinaryEncoding.Base64)

I can reproduce this. This kind of function will exist when you use "Enter Data" button in power bi desktop, however, it seems like dataflow doesn't allow user to change data they entered currently. I would suggest you to submit your idea here. As a workaround, you can create a blank query and use power query language below to generate or modify a table:

let
  Source = Table.FromRecords({  
            [CustomerID = 1, Name = "Bob", Phone = "123-4567"],  
            [CustomerID = 2, Name = "Jim", Phone = "987-6543"] ,  
            [CustomerID = 3, Name = "Paul", Phone = "543-7890"] ,  
            [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]  
      })
in
  Source