cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaryszek
Helper III
Helper III

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
Helper III
Helper III

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

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Kudoed Authors