Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.