Floating point and double in power query

[jaryszek]

Hi Guys,

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

Can anybody help?

Jacek

[jaryszek]

thank you so much. 

What about type "number" type? 

Best,
Jacek

[edhans · Accepted solution]

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