Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

how to edit created data in Power BI ?

Hello,

In Power BI, we can enter data like this :

But once we click OK, it transforms into compressed text in a query like this :

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKilR0lGqrKwEkmZKsTpQgdLSUiBpqRQbCwA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Colonne 1" = _t, #"Colonne 2" = _t, #"Colonne 3" = _t]),
    #"Type modifié" = Table.TransformColumnTypes(Source,{{"Colonne 1", type text}, {"Colonne 2", type text}, {"Colonne 3", Int64.Type}})
in
    #"Type modifié"

When I want to later add/modify data to this, I have to go to a website like https://www.multiutil.com/text-to-deflate-compress/ in order to replace the compressed text.

Isn't there a way to edit that text directly in Power BI (without adding steps to the query) ?