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:
arify's avatar
arify
Microsoft Employee
10 years ago

May I ask what data source you are using?

sunjin122's avatar
sunjin122
Helper I
10 years ago

warehouse data of the company

  • arify's avatar
    arify
    Microsoft 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
      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