i stumbled accross a problem when using Power BI with Redshift. I created a table with one varchar column and one numeric(15,6) column. I added the table in the Power Query editor and chose Direct Query. Then i saw my numeric column was displayed with up to 4 decimal places and my varchar column also showed up. I made sure everything is set correct (e.g. right data type of the columns in Power BI,
Then i added those to a table on a report and it showed me wrong numbers. I quickly realized that it is because there are no decimal places:
I would understand if it would round the total value in the end but it's rounding all values before summing them up. Why is it doing this and how do i avoid it?