Forum Discussion
PowerBI Direct Query and Cache issue
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 resu...
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)