
Expert Data Modeling with Power BI
By :

We previously discussed different Power Query types in Chapter 3, Data Preparation in Power Query Editor, in the Introduction to Power Query (M) section. We also discussed, in Chapter 5, Common Data Preparation Steps, that datatype conversion is one of the most common data preparation steps we take. In both chapters, we looked at different datatypes available in Power Query. So as a data modeler, it is crucial to understand the importance of datatype conversion. This section looks at some best practices about data conversion and how it can affect our data modeling.
As mentioned, we already discussed the datatypes in Power Query in Chapter 3, Data Preparation in Power Query Editor, and Chapter 5, Common Data Preparation Steps. However, to emphasize the importance of understanding datatypes in Power Query, it is worth recalling it briefly in this section. In Power Query, we have only one numeric datatype, which is number...