Forum Discussion

alexa_0028's avatar
alexa_0028
Resolver II
4 years ago
Solved

Remove incremental refresh from the existing table

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 ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

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.