Missing Decimals with Power Query Append

Question

Hello!

I'm having some trouble with a Power Query append query I made. 

This query is the combination of 13 tables from 13 separate sheets in the workbook - each table has about 20-30 rows and 25 columns. This makes the append query over 300 rows long with about 25 columns. It's pretty involved.

The append query, combining all of these tables on a separate sheet, loads up text and decimal number information very well for the first 6 rows, no problem. It's the 7th row that's having trouble:

What should be loaded is "-16.22" in most of these cells, however it only returns "-16" in the cells for most of them. 1 table in the combined query returns the correct information but all 12 others are missing the decimal points.

I've gone into "Edit Query" -> "Data Type:..." -> made sure it was ""Decimal Number" and I made sure that under the "Trasnform" tab that it rounds to 2 decimal places.

I've revisited the original tables they're calling from and made sure they are "Number" format and are rounded to 2 decimal points too. 

On the combine query I've even added two decimal places manually from the Home tab but it just shows as "-16.00" so the 2's aren't hiding in there - something is wrong with how its calling the data from other sheets. 

Am I just dealing with too much data for it to import the 2 decimals?

These decimals are crucial, how do I get them?

Please let em know if you need more info or pictures I'll be happy to provide anything, just need help!

Thanks so much for any help!!!

Answer 1

Thank you for your response! I'm sorry, but I'm not able to send it to you as it contains sensitive information about student grades. I understand this is tough to solve otherwise, but if you have any ideas that I could Google please let me know!

Answer 2

Hi,

Share the link from where I can download the workbook with the 13 worksheets.  Please also indicate the column where you are facing the decimal number issue.