Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
hello,
I want to extract from a HFSQL database and I encounter a problem with decimals if the value exceeds 4 decimal places
OLEDB connection
Example 1:
HFSQL value: 113.865546 / Value on Power QUERY: 11386.55
Example 2:
HFSQL value: 135.50 / Value on Power QUERY: 135.50
Same result with change to text type.
Thanks in advance.
I want to extract from a HFSQL database with power bi
Hi, @Chafi31
That's a bit odd, isn't it? how about you use Number.round PQ func. I know it's not a good solution but it should do the work.
refer:
Number.Round - PowerQuery M | Microsoft Learn
Proud to be a Super User!
Hi,
The same result with number.round because the change is made on the value already received.
I think the maximum of power query is 4 decimal with OLE DB connexion.
Best regards.