Forum Discussion
Solved
Restrictions with Date/Time Transformations
Hi Everyone, An app developer of ours has created an app to convert reports into pdf's and refresh and send out reports to a mailing list automatically. therefore we are trying to make all the r...
Hi niamhks,
Unfortunately, it is not possible to extract only date or time part from a datetime field in Power Query with Direct Query connection. This is the limiattion of Direct Query. But we are able to extract Hour/Minute/Second from DateTime.
As a workaround, a new created calculated column in data view can also be used in report page. It works the same as custom column created in Power Query.
Best regards,
Yuliana Gu
Greg_Deckler
Community Champion
Community ChampionSo, are you saying that DATEDIFF doesn't work? Have you tried a measure like:
Measure = ([search_end_date] - [search_start_date]) * 1.