how to extract Hour from a Time format in Direct Query Mode?

[sunjin122]

Can anybody tell me how to  extract just Hour from a Time column in Direct query mode? Thanks ahead

[arify]

Can you try to do it in the query editor first, and then load it to the designer?

[sunjin122]

This cannot be done in Query Editor since this is live data by using DirectQuery mode instead of Import data...

[arify]

May I ask what data source you are using?

[sunjin122]

warehouse data of the company

[arify]

When you go through Recent Sources button it may not ask for Direct Query, but can you try going through Get Data > ... and pick DirectQuery in there?

Or, when you load it into PBI Designer, you can right click > Edit, doesn't that work?

[sunjin122]

It is not working under Direct Query mode. Thank you for your help though

[AlexChen]

Hi,

You can extract Hour from a Time Column in Direct query mode. But you can’t change its data type.

See my screenshots below.

1.  connect database with direct query mode.

2.  import a table with a time column.

3. Go to query editor. Extract Hour from test_time column.

4. Apply and close query editor. Show data with table visual.

Best Regards

Alex