Help - Code to limit volume of data from CRM

[Laura_Saoirse]

My dash is pulling All Time data from the CRM in to PowerBI which is causing the dash to be extremely slow in development. I want to limit the amout of data flowing in to Power BI to the prior 2 years plus YTD this year. I have found a version of the code below online which I've edited to my use case however I am getting an error ('common token expected'). As a newer user to PowerBI, I dont know where I've gone wrong - any help greatly appreciated! 

let
Source = OData.Feed("https://goal.api.crm4.dynamics.com/api/data/v8.2/"),
#"Year" = Date.Year(DateTime.LocalNow())-3,
mh_donations_table = Source{[Name="mh_donations",Signature="table"]}[Data]
#"Filtered Rows" = Table.SelectRows(#"mh_donations_tablele", each Date.Year([donation date]) >= #"Year")
in
#"Filtered Rows"

[otravers]

You can add filters in an Odata URL. Not sure this applies verbatim to your specific version of Dynamics, but this should be a good place to start:

https://reenhanced.com/2020/odata-cheat-sheet-for-microsoft-dynamics-365-and-common-data-service-(cd...