Forum Discussion

niamhks's avatar
niamhks
Regular Visitor
8 years ago
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...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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

niamhks's avatar
niamhks
Regular Visitor
8 years ago

Thank you v-yulgu-msft. 

 

I will give this a go :) 

 

Thanks 

Niamh