Percent column in json data displaying as decimal

[dickfederle]

I have a Json.Document(Web.Contents query that works great except that one of the expanded columns, which comes in as "any", I change it's data type to "percent" and it shows in the query correctly as a percentage.  However, when I pull it into any visual including tables and matrices, it shows as decimal.  This is happening for mutliple columns on two different Json.Document(Web.Contents query calls.

Any thoughts?

[dickfederle · Accepted solution]

I just found my own answer.  I have to change it in the "model" as well (or not change it in the query at all) for it to pass through to the reports.  It shows as numeric in the "model" even though I change it to percentage in the query transforms.

I would think this was a "bug"