BI_MI's avatar
BI_MI
Frequent Visitor
6 years ago
Status:
New

Difference between Query Editor & Desktop

Hi,   I have an issue with difference between what I see in Query Editor and what is display in Desktop. Decimal notation change from 1 000,00 to 1.000,00 for some reason. Please find below examp...
Data Modeling
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi BI_MI, 

 

I tested on my side but not able to reproduce the issue. Please update Power BI desktop to the same version. Also you can try the Power Query to create the same report as ours then test again on your side to see if the same issue occurs. 

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcnY0MNQ3MDA0MTNW0lEyVDAwMNAxMFBwdVSK1YHLGhmaGIFkYTKxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Material/ Plant(Key)" = _t, #"Base Qty for Price(Key)" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Material/ Plant(Key)", type text}, {"Base Qty for Price(Key)", type text}})
in
    #"Changed Type"

 

 

Best Regards,
Qiuyun Yu

Completed Ideas