Remove Scientific notation in measure

Hi marcos_osorio ,

Can you please check the datatype and let me know.

Thanks & regards,

-Arul

Hi marcos_osorio ,

After loading data into desktop, please change the data type to Decimal, and set decimal places to 11 or above if you want to display the whole value. 

If you only want to round the value as a integer, set decimal place to 0.

Best regards,

Yuliana Gu

Did you ever find a solution? I am struggling with the same problem. It works when I change the fomar to currency but I would like to keep the decimal and just round it. 

I found an alternative solution that fixed the issue for me. You can define a custom format in the Modeling view as shown here: 
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

Go to the Modeling view, select the field or measure you need to format, navigate to the Properties pane, pick "Custom" format from the dropdown, and then enter your desired format. 
I used a custom format of:
#,0.0;-#,0.0;0

The string is broken into three parts by each semicolon, defining the format for a positive number, negative number, and zero. In the above format I wanted commas to show and only one decimal place. If you wanted your negative number to be in parentheses, you could instead use #,0.0;(#,0.0);0