Forum Discussion

John1's avatar
John1
Frequent Visitor
7 years ago
Solved

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 ...
Need Help
  • v-yuta-msft's avatar
    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

     

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

John1，

 

I'm afraid the encrypted data in Binary.FromText should not be modified manually. Have you tried the workaround?

 

Regards,

Jimmy Tao

John1's avatar
John1
Frequent Visitor
7 years ago

I didnt try the workaround as the table is too large; I needed to paste it in from Excel. 

 

I didnt modify the data, just replaced it. I havent noticed an issue yet. Where I did have an error was when I pasted in the whole line of code from desktop or the whole advanced editor code from desktop. But, replacing just the encrypted part within the quotes seemed to work. Not sure why I couldnt replace the whole line of code or what the error means.