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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jaryszek
Post Patron
Post Patron

Floating point and double in power query

Hi Guys,

how to specify floating point, double and big/small floating point in power query? 

Can anybody help?

Jacek

1 ACCEPTED SOLUTION
edhans
Super User
Super User

You cannot. Power Query only supports 4 (really 3) number types:

  1. Integer, or whole number
  2. decimal (15 decimal precision)
  3. Currency (4 decimal precision, and Power BI treats this as an integer and then adjusts for you in the model)
  4. Percentage - same as #2 above. It just looks different in the editor.

Neither Power BI nor Power Query support all of the datatypes you'd find in a true database product like SQL Server.

You can read more about it here, and how to map between SQL Server data types and Power BI Data types. Choosing Numeric Data Types in DAX - SQLBI



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

2 REPLIES 2
jaryszek
Post Patron
Post Patron

thank you so much. 


What about type "number" type? 

 

Best,
Jacek

edhans
Super User
Super User

You cannot. Power Query only supports 4 (really 3) number types:

  1. Integer, or whole number
  2. decimal (15 decimal precision)
  3. Currency (4 decimal precision, and Power BI treats this as an integer and then adjusts for you in the model)
  4. Percentage - same as #2 above. It just looks different in the editor.

Neither Power BI nor Power Query support all of the datatypes you'd find in a true database product like SQL Server.

You can read more about it here, and how to map between SQL Server data types and Power BI Data types. Choosing Numeric Data Types in DAX - SQLBI



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors