Import decimal numbers from excel to power bi without approximated

Question

I have a decimal number in Excel and the format of cell in (number with two-digit decimal) and I want to import that numbers to the power bi but with the same value and without approximated.

Below is the screenshot from Excel 

The blow screenshot from power bi, notes the values is changed

So what is the trick to avoided the issue like this in the future?

Thank you

Answer 1

Decimal data show as Integer in Power BI

If you have imported values from a database or excel sheet and the imported decimal values are showing as an integer values instead of decimal. so in this case, you should do the following:

How to import values with decimals in Power BI?

Steps

1. In Excel file, make sure that the column format is "Number".

   

2. In Power BI desktop, open "Query Editor" by clicking on the "Edit Queries".

   

3. in the Transform tab, click on the "Detect Data Type" button.

   

4. Make sure that the "Data Type" is set to "Decimal Number".

   

5. Close and Apply the changes.
6. On the right side, at Fields, Click on the field name.
7. In the Modeling tab, make sure that its data type and format are set to "Decimal Number".

8. Adjust the decimal places as you prefer.

   

---

You might also like to read

• Power BI: Whole Number Vs Decimal Number
• Missing Save To Power BI Report Server In Power BI Desktop

Answer 2

In a case like this, We have to check 3 things

1. Column Format in Excel should be "Number with decimal"
2. Power BI "Query Editor" make sure the Data type is "Decimal Number"
3. In Power BI in "Modeling" tab, make sure the Data type is "Whole Numer" and Format is "Decimal Number"

After that just refresh the data and everything should be OK.

Comments

Thanks, Mahmoud for sharing your valuable solution with the community, but I would like to add a bit note here, Changing data type again to the whole number is NOT required!

---

The above solution is not working for me.
I have got a column with No of hours but in some cases data is 1.5 for 1h and 30min. This decimals aren't shown by Power BI that only displays whole numbers in this column.