Forum Discussion
Anonymous
3 years agoNot applicable
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) ?
- Anonymous3 years ago
I have found my answer here : https://carldesouza.com/power-bi-enter-data-edit-data/
You need to click on the wheel beside the step "Source"
1 Reply
- AnonymousNot applicable
I have found my answer here : https://carldesouza.com/power-bi-enter-data-edit-data/
You need to click on the wheel beside the step "Source"