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

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

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

May I ask what data source you are using?

  • 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: