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

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

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?