Forum Discussion
Helper IIIPower BI - Override incremental refresh policy with XMLA
As there doesn't seem to be a good way of scripting an incremental policy using SSMS and I can't find any full examples online, tabular editor seems to be able to modify incremental policies. I will try this for now, if I get stuck I will contact MS support, thank you.
Community SupportHi jhowe1 ,
Thanks for reaching out to the Microsoft fabric community forum.
The existing M query is the Power Query script that controls how your table’s data is loaded and transformed. If you’re not familiar with viewing or copying that from the deployed dataset, it can be a bit tricky especially when working directly against a production model via XMLA.
Because changing this incorrectly could trigger a full refresh and cause the same memory issues you’re trying to avoid, I’d recommend also raising a Microsoft Support ticket.
Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank you.
Helper IIIAs there doesn't seem to be a good way of scripting an incremental policy using SSMS and I can't find any full examples online, tabular editor seems to be able to modify incremental policies. I will try this for now, if I get stuck I will contact MS support, thank you.
- v-menakakota
Hi jhowe1 ,
Thank you for the update.