PowerBI Direct Query and Cache issue

[power2kp]

We are working on a powerbi report which has a slicer apply button and when the slicer is applied , it does call a oracle stored proc (with a writeback) in one of the tables and fetch the latest result using direct query. once the results are displayed in a tabular format, when the user hits back button and choose the value from the slicer again to go back to writeback page, the data is taken from the cache and as a result even in teh writeback page, the direct query is not executed but takes the values from the cache which is not what we want. we want the latest values to be displayed by executing the direct query. we have tried few ideas in teh community like RAND function, cache settings both in the desktop and the powerbi service. we cant get this to work and its frustating. 

any ideas pls ?

[lbendlin]

DO NOT use Power Query to write back into your data source. There is absolutely no guarantee that your Power Query will be run once.  It can be run multiple times or not at all.  There is no guarantee whatsoever. None.

Chris Webb's BI Blog: Why Is Power BI Running My SQL Query Twice? (crossjoin.co.uk)