Conditional Load

[MStile]

Is it possible to include logic in the source query such that it will only reload information based on that condition.  I have a table which after 30 days will be historical in nature and will never change.  The table is based on a vendors Web Rest API which appears to prevent me from using incremental refresh.  I am therefor appending multiple tables (each covering a period of time) into a single fact table but I don't want to have to reload every table with every refresh nor do I want to have to update the dataset every month.

[HoangHugo]

Hi, in Power Query, right click the table you don't want to refresh, and uncheck "Include in Report refresh"

[MStile]

Thank you for the response.  My problem is that this requires manual intervention which I am trying to avoid.