Data Management: Power BI Data Types with M or Report Design UI?
Having the correct data types in your Power BI model is essential for a fast performing dashboard. For the most part, Power BI does this automatically for you in the Power Query editor when connecting to a data source. Power Query accomplishes this by scanning the first hundred or so rows to determine the most appropriate data type for each field of your table. As awesome as this is, sometimes it makes a mistake. The most common example I've encountered is that my currency fi