Forum Discussion
Extraction from a HFSQL database Respond
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.3 Replies
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
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.
I want to extract from a HFSQL database with power bi
