For structured data sources, such as SQL Server, the source column data types will determine the data types applied in Power BI. For example, a money data type in SQL Server will result in a Fixed Decimal Number data type in Power BI. Likewise, the integer data types in SQL Server will result in a Whole Number data type and the numeric and decimal data types in SQL Server will result in Decimal Number data types in Power BI.
When an M query is loaded to the data model in a Power BI dataset, a Fixed Decimal Number data type is the equivalent of a (19,4) numeric or decimal data type in SQL Server. With four digits to the right of the decimal place, the use of the Fixed Decimal Number data type avoids rounding errors. The Decimal ...
