Forum Discussion

chstead's avatar
chstead
Regular Visitor
8 years ago

PowerBI Rest Api truncates doubles

Hi all, 

I work on a tool where we embedded PowerBI and use the rest api to push data to PowerBI. I noticed that although we are specifying the type of floats/doubles as 'double', they are being truncated to 2 decimal places (as if they were reals). Double is supposed to handle many decimal places. Does anyone have a workaround or advice? We could cast it to a string but that it's really what we want to do. 

Need Help

2 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    8 years ago
    chstead wrote:

    Hi all, 

    I work on a tool where we embedded PowerBI and use the rest api to push data to PowerBI. I noticed that although we are specifying the type of floats/doubles as 'double', they are being truncated to 2 decimal places (as if they were reals). Double is supposed to handle many decimal places. Does anyone have a workaround or advice? We could cast it to a string but that it's really what we want to do. 

    chstead

    Thanks for reporting this issue. I've tested specifying the type as double or decimal, however the values are truncated to 2 decimal places as you described. I'm going to escalate this internally and I'll post back if there comes any update.