Odata url Date Parameter

Hi I have started using Odata url links to link Power BI and Excel to MS Dynamics Business Central. I want to be able to restrict how much data comes over by date. Our Finance data is 6 million + r...