Why don't you disable the load option? I'd like to suggest you turn off the refresh option and load option at same time, after finish these steps, current query weren't loaded/refreshes.(please ensure you haven't reference these queries at other tables)
>>When I publish the report and try to schedule a refresh (or refresh it manually in the PowerBI Workspace) it gives an error about that table.
In my opinion, even if you turn off the refresh option, power bi will at least load it once from datasource.(notice: power query not support cache history records)
Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.