Remove incremental refresh from the existing table

[alexa_0028]

Hi All,

I have model already published to service . It has tables which uses incremental refresh policy.
I want to remove it so I have turned off incremental refresh policy from desktop and also deleted Range start and range end parameters and removed the transformation for filtering row.

When I am overwriting my existing model now, by deploying the file with tabular editor I am getting error.

How can I overwrite my exisiting model ?
Please help me.


Thanks,
alexa

[alexa_0028]

Hi All, thnaks for the suggestions.
I tried below approach and it worked for me.
1. Open the model in the Tabular editor and save the .bim file 
2. Again open tabular editor and open the .bim file from the local and deleted the tables with IR policy
3.Deployed the .bim file to service via tabular editor (So at this stage the IR tables are deleted from service)
4. Published the new model file by overwriting the exisiting model via tabular editor.

[v-kkf-msft · Accepted solution]

Hi @alexa_0028 ,

This is an error caused by the fact that you did not remove the partitions to which apply the incremental refresh policy.
Please try the following steps.
1. Use the Table Editor to connect to the incremental refresh dataset in the PPU/Premium workspace.

2. Select the table to which incremental refresh is applied and disable the incremental refresh policy.

3. Add a new partition and write the M-code for the partition (i.e., the M-code for full refresh).

4. Remove the incremental refresh partitions.

5. Save the changes to the connected database.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

Did you try publishing the PBIX either by uploading from within the service, or by the Publish button in Power BI Desktop? There is no need to preserve partitions since it will be a full refresh going forward.