JSON parser in Dataflow incorrectly parsing small values

[Anonymous]

In Power Query desktop, the JSON parser correctly runs the following example:

let
    Source = Json.Document("{ a: 0.000068 }")
in
    Source

Resulting in: a:6.8E-05

Unfortunately the same query in Dataflow results in: a: 0

Of course, putting the value in quotes forces it to be a string and it is returned correctly in both products. However, the JSON parser should not be rounding numeric values to zero and should be using the same JSON parser so we don't get inconsistencies in parsing.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Thanks for catching this! But sorry that I can't fix it in my side. I'd like to suggest tou raising this issue to support team for better advice.

https://powerbi.microsoft.com/en-us/support/