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

GilbertQ's avatar
GilbertQ
Super User
7 years ago

Hi there

 

You should be able to go into the dataflow, then click on Edit Entities and click on the table and select Advanced Editor

 

John1's avatar
John1
Frequent Visitor
7 years ago

Advanced Editor pulls up the M Query editer, but not a table editor to change the data on the table. You see this, not the table data within the Binary.FromText function...

 

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fZRBrsMwC.....", BinaryEncoding.Base64), Compression.Deflate)), let _t = (type text) meta [Serialized.Text = true] in type table ....

  • GilbertQ's avatar
    GilbertQ
    Super User
    7 years ago

    Hi there

     

    You could click on Source and then the Gear Icon to bring up the original table?

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    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

    • John1's avatar
      John1
      Frequent Visitor
      7 years ago

      I went back to the pbix file that I had before I was using dataflow, edited the table there and relplaced the uninterpretable characters in the function Binary.FromText("..." 

       

       

      I had to do that more selective change because when I tried just replacing the code for the whole statement, or the code for the whole table (advanced editor), I got an error "An error occured while validating your queries." and this was the only way I found past it. 

       

      This seems like a gap in data flow. 

      • 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