Forum Discussion

sunjin122's avatar
sunjin122
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
10 years ago

warehouse data of the company

arify's avatar
arify
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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's avatar
    sunjin122
    Icon for Helper I rankHelper I
    10 years ago

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

    • AlexChen's avatar
      AlexChen
      Icon for Microsoft Employee rankMicrosoft Employee
      10 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.