Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Chafi31
New Member

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 3
saidramdani
New Member

I want to extract from a HFSQL database with power bi

rubayatyasmin
Super User
Super User

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

 

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.