sunjin122Helper I10 years agohow 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: Show More
arifyMicrosoft Employee10 years agoCan you try to do it in the query editor first, and then load it to the designer?
sunjin122Helper I to arify10 years agoThis cannot be done in Query Editor since this is live data by using DirectQuery mode instead of Import data...arifyMicrosoft Employee to sunjin12210 years agoMay I ask what data source you are using?sunjin122Helper I to arify10 years agowarehouse data of the companyShow More
sunjin122Helper I to arify10 years agoThis cannot be done in Query Editor since this is live data by using DirectQuery mode instead of Import data...
Related contentExtract conditional formattingExtract Data from sharepointDate Format Direct QueryExtract AM / PM from Datetime format in direct queryData Extraction from Oracle
