I am struggling with a question I can't solve.
I made a query from an Excel data sheet to an Excel analysis sheet.
When data are uploaded in the query, decimal are automatically rounded.
It means :
My Excel data sheet displays 0,19 for a value that is 0,188
My Query displays 0,19 and the data behind is 0,19
The difference at the end is quite huge, and I really don't understand why PowerQuery is doing that.
The only way (stupid one) I found is to go inside the Excel data sheet and expand the numbers displayed after the comma...
I tried :
- Change Type (decimal numbers don't change anything it seems the data at the moment it is read is rounded)
- Query options
- Modification of the "File.Contents" and "Excel.Workbook" functions
- Try the Excel data sheet from a "csv/txt" query : same result
If you can you help on that it would be great 🙂