Forum Discussion

kattlees's avatar
kattlees
Post Patron
8 years ago
Solved

Limit import based on date

I am new to Power BI and have decided to do import vs direct query.   Is there a way to limit the records imported based on date to save time/space? Our system has 20 years of data and if we only w...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    select filter on your date column and then choose parameter as show below in below circle, and select your parameter.

     

parry2k's avatar
parry2k
Super User
8 years ago

select filter on your date column and then choose parameter as show below in below circle, and select your parameter.

 

  • kriman's avatar
    kriman
    Helper I
    8 years ago

    Hi,

     

    I used the advanced filters (greater than or equal to & less than or equal to) to only get data between certain dates. For example between Sept 1st & Oct.31st of 2017.

     

    However, the filters don't seem to work, the data extraction keeps going and going trying to extract the entire table. This is not rocket science, just filters, but they don't work.

     

    Any thoughts ???

     

     

     

  • kriman's avatar
    kriman
    Helper I
    8 years ago

    Hi,

     

    I used the advanced filters (greater than or equal to & less than or equal to) to only get data between certain dates. For example between Sept 1st & Oct.31st of 2017.

     

    However, the filters don't seem to work, the data extraction keeps going and going trying to extract the entire table. This is not rocket science, just filters, but they don't work.

     

    Any thoughts ???