Forum Discussion
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
You cannot. Power Query only supports 4 (really 3) number types:
- Integer, or whole number
- decimal (15 decimal precision)
- Currency (4 decimal precision, and Power BI treats this as an integer and then adjusts for you in the model)
- 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
2 Replies
You cannot. Power Query only supports 4 (really 3) number types:
- Integer, or whole number
- decimal (15 decimal precision)
- Currency (4 decimal precision, and Power BI treats this as an integer and then adjusts for you in the model)
- 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 - SQLBIthank you so much.
What about type "number" type?Best,
Jacek
