Forum Discussion

jitpbi's avatar
jitpbi
Post Patron
5 years ago
Solved

load data for specific time duration

Hi,   In my dataset, I am having a field "DateTime" (format: 9/8/2020 12:00:00 AM). I want to load the data from the source only for the time in between 10:00:00 AM to 04:00:00 PM only. Please sug...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    5 years ago

    Hi jitpbi ,

     

    If your data source is from database, you could write T-SQL to restrict data while connecting. For other data sources, it is not supported to restrict when we load data.  You could import it firstly and then filter in Query Editor.  For this situation, Jimmy801 's answer is a good solution.

     

v-xuding-msft's avatar
v-xuding-msft
Community Support
5 years ago

Hi jitpbi ,

 

If your data source is from database, you could write T-SQL to restrict data while connecting. For other data sources, it is not supported to restrict when we load data.  You could import it firstly and then filter in Query Editor.  For this situation, Jimmy801 's answer is a good solution.