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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors