DateTime.Date - PowerQuery M | Microsoft Learn
...About Returns the date component of the dateTime parameter if the parameter is a date, datetime, or datetimezone value, or null if the parameter is null....
https://learn.microsoft.com/en-us/powerquery-m/datetime-date
DateTime.Date - DateTime Function | Power Query M
...When you apply this function to a datetime column, it will transform all datetime values to date values, as shown below: The DateTime.Date function also works on datetimezone values. Here?s an example how: Similarly, date values are supported....
https://powerquery.how/datetime-date/
Convert DateTime into Date in Query Editor using M function
...You can go to Query Editor, click on the left icon of the column name, then select the Date to change DateTime type to Date type. The corresponding M query uses the Table.TransformColumnTypes () function....
https://community.fabric.microsoft.com/t5/Desktop/Convert-DateTime-into-Date-in-Query-Editor-using-M-function/m-p/711511
Date/Time To Date Data Type In Power Query From SQL Direct Query
...Solution: Use Import Mode for SQL queries. This will allow you to change the data type in the Power Query Editor without error and in some cases is faster. Thanks for all the assistance!...
https://stackoverflow.com/questions/79452816/date-time-to-date-data-type-in-power-query-from-sql-direct-query
How to convert a date time column to date only in Power BI?
...Now in the Power Query Editor, select the column that contains DateTime values. Right-click on the selected column header and select Change Type , then select Date....
https://www.easytweaks.com/convert-datetime-date-power-bi/
Solved: Power Query reading date as datetime datatype whil ...
...Right-Click the datetime column and select Change Type then click date in power query. Currently, the built-in date hierarchy is not yet available when using DirectQuery mode....
https://community.fabric.microsoft.com/t5/Desktop/Power-Query-reading-date-as-datetime-datatype-while-using-Direct/m-p/4243398
Date.From - PowerQuery M | Microsoft Learn
...Values of the following types can be converted to a date value: text: A date value from textual representation. Refer to Date.FromText for details. datetime: The date component of the value. datetimezone: The date component of the local datetime equivalent of value....
https://learn.microsoft.com/en-us/powerquery-m/date-from
Custom date and time format strings - PowerQuery M
...In parsing operations, custom date and time format strings can be used with the Date, DateTime, Time, and DateTimeZone functions. These functions require that an input string conforms exactly to a particular pattern for the parse operation to succeed....
https://learn.microsoft.com/en-us/powerquery-m/custom-date-and-time-format-strings
Solved: DirectQuery SQL Convert datetime to date - Microsoft Fabric ...
...Have you tried to change the data type from Date/Time to Date in Power Query? You can do this by selecting the column and changing the data type in the transform tab....
https://community.fabric.microsoft.com/t5/Desktop/DirectQuery-SQL-Convert-datetime-to-date/td-p/3296245
DateTime functions - PowerQuery M | Microsoft Learn
...DateTime functions These functions create and manipulate datetime and datetimezone values....
https://learn.microsoft.com/en-us/powerquery-m/datetime-functions