Forum Discussion

pawlowski6132's avatar
pawlowski6132
Helper V
5 years ago

Creative Way to NOT Refresh Query in Service

Has anyone found a creative way to prevent a query from refreshing in the service.

 

In my situation, I have a query that pulls FY2020 data which is NOT changing, however, my models spends time refreshing this query.

 

I don't think incremental refresh will work in this situation (Oracle, Native Query, No Date reference field).

 

thanx

Need Help

2 Replies

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi pawlowski6132,

     

    Based on my research, maybe you can prevent a query from refreshing in the desktop as:

    But it is not supported in the service now.

    You can try to republish report after refreshing in the desktop， but it doesn't look very convenient.

     

    Best Regards,

    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.