SQL Import Limit Data based on Dates

Anonymous 

You can use incremental refresh, which is most suitable for structured relational data sources, such as SQL databases, it extends scheduled refresh operations by providing automated partition creation and management for dataset tables that frequently load new and updated data, You can customize the time range to refresh the data instead of importing it in full every time.

However, it should be noted that the incremental refresh will load all the data for the first time. The loading time will be based on how much data you have. After that, the data will not be imported in full, and the data will be loaded slowly.

1. Create two date/time parameters, RangeStart and RangeEnd.

2. Configure incremental refresh on the desktop report page.

For the specific operation of incremental refresh, you can check the following link:
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#create-parameters

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-troubleshoot

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.