Forum Discussion
kattlees
Post Patron
Post PatronLimit 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...
select filter on your date column and then choose parameter as show below in below circle, and select your parameter.
Hai sanjoyleo did you solved this scenario, if yes could you please share the procedure...
kattleesPost Patron
Post PatronYes, in Query Editor under source, then under advanced you can write and SQL statement to only pull in fields you want and put limits on such as dates. Really helps limit the amount of data you can pull in.