Forum Discussion
Helper IISUM differences between SAP HANA and Power BI
Helper IIHi tex628 thanks a lot for your reply 🙂
The differences diminish further and further the more Dimensions i take into account. The differences are quite visible at the most aggregated level (as seen in the original post) but after 2-3 Dimensions the differences get smaller and smaller.
I already thought it is a rounding error but the Datasource itself only delivers 4 decimal places which all show up in Power BI.
When I use direct query, I get exactly the same results as in the Datasource. The error only arises whenever i use import mode.
The performance of the Datasource is quite bad so direct query is no option unfortunately....
Best regards
Timo
Community ChampionI'm getting the vibe that this is an issue that should be handled from side of MS through a ticket, as Greg_Deckler previously proposed. As it's clearly visible in the images, Power BI is importing 4 decimals as well which makes me think that the issue is more complicated and technical that a simple decimal import issue. But I'm very front-end oriented so I'm not going to be much help when it comes to diving deep into query behaviour.
My advice is to build a very solid case, arguing that there is something problematic with import mode. Be careful putting too much weight on the comparison with BO. As it's not an MS system it might be hard for the supportstaff to verify the validity of the data even through you know that it's correct. I would proberby focus more on the diff between import and directquery, and identify a diff in the data on the lowest possible dimensional level.
Br,
J