We have a report running in our Prod workspace that's hitting memory limits. It needs remodeling basically, but to give us time it has incremental policies already enabled on 6 queries (all same 6 months), we want to reduce the incremental refresh window from 6 months to 3 months to see if it will refresh as normal. We don't want to do this in PBI desktop, because as mentioned when we publish it does a full refresh it will be extremely slow and possibly hit memory limits again. Through SSMS/XMLA how do I change incremental refresh policies? i.e. changing required tables from 6 months to 3 months? Looking for XMLA examples. Can't find anything online.
Seeing as no one is able to answer this and I can't find the code to do it anywhere it looks like it's possible to apply/modify incremental policies using tabular editor if anyone gets stuck in this scenario.