How can I preserve table data type columns from Power Query in the Power BI Data Model?
When I load data from Power Query into the Power BI Data Model, I notice that some of the data types for table columns are not preserved as expected. For instance, columns formatted as dates or text in Power Query sometimes appear differently in the model. How can I ensure that the data types defined in Power Query remain consistent when the data is loaded into the Data Model? Any tips or best practices would be helpful!