Forum Discussion

sunjin122's avatar
sunjin122
Helper I
10 years ago

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

Can anybody tell me how to  extract just Hour from a Time column in Direct query mode? Thanks ahead:smileyhappy:
sunjin122's avatar
sunjin122
Helper I
10 years ago

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

AlexChen's avatar
AlexChen
Microsoft Employee
9 years ago

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

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thank you, Excellent soluytion I did now a Table for time to connect different table source and is working excellent.