Forum Discussion
microsoft support is lying
Just wanted to put out a PSA about microsoft support/developers.
currently have a ticket open showing that Power BI is changing my data's format output from the raw data from my server. (Text Case Sensitivity)
support says they can replicate the issue as well. (with their own data)
microsoft developers have come back saying its "Intended", which is a lie.
anytime microsoft changes their CUSTOMER data for their own reasons, its WRONG and needs to be fixed.
Also microsoft, if isn't a bug? how come powery query in Excel doesnt change my data, but only power BI?
HMMMMMMMMMMMMMM????
When i use power BI to look at my data, I WANT TO SEE MY DATA, not what power BI THINKS my data shold look like.
2 Replies
put this in power query
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCnENDlHAQijpKBkqxergVWCEW0FqcQlQgbFSbCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [TEXT = _t, ROW = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"TEXT", type text}, {"ROW", Int64.Type}})
in
#"Changed Type"the output should be
Not This
