today I've spend time to investigate an issues where Power BI Desktop (RS) 2018-08 returns wrong values when using an ODBC DB2 connection. When I using same ODBC connection using Excel correct values are returned, also using DB2 directly.
When I use Power BI Desktop RS to connect to DB2 via ODBC Power BI Desktop client seems to translate decimal number initiator "," or "." wrong. Excel does correctly. So when I a value e.g. "1234.23" Power BI Desktop would return "123423", Excel would return corect "1234.23" value. I've tested several settings within Power BI Desktop ODBC connection string and/or transformating and setting values to Power BI Desktop query, but every time witin Power BI Desktop (RS) wrong values are returned. I've also testet using different langauge settings within Windows Server regional profile and/or general Power BI Desktop regional setting.
DB2 query shows correct value
Power BI Desktop shoes none correct value
As you can see from screenshot, it looks like Power BI Desktop seems not to respect "," at ",80" therefore returned value is with two digest higher than it should be.
I've tested several options within Power BI Desktop ODBC connection string as well, but none used to be fitting getting rid of this issue.
Is there any known issue about it, or can you provide some kind of additional information that value is shown correctly?
Please don't hesitate to contact me for additional information.