Extraction from a HFSQL database Respond

[Chafi31]

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.

[saidramdani]

I want to extract from a HFSQL database with power bi

[rubayatyasmin]

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

[Chafi31]

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.