Hello,
I have an excel file and I use power query to connect to an Oracle DB, and retrieve some data. The SQL request used takes some times (several minutes).
'Load To' option is set to 'connection only' + 'Add to datamodel' check box ticked, and option 'Fast data load' is also ticked.
Problem is that each time I make an update in power query ,and the go back to Excel, data model is refreshed, and I have to wait the end! Excel specifies (in the status bar) to press 'Escape' key to cancel the refresh, but it isn't working
I would just want to refresh the data model on demand, not each time I go back to excel !
I'm probably not the only guy to have this, so do you know any trick or option to cancel / avoid data model refresh when go back to Excel (from power query)
Thank you for your help
I have an excel file and I use power query to connect to an Oracle DB, and retrieve some data. The SQL request used takes some times (several minutes).
'Load To' option is set to 'connection only' + 'Add to datamodel' check box ticked, and option 'Fast data load' is also ticked.
Problem is that each time I make an update in power query ,and the go back to Excel, data model is refreshed, and I have to wait the end! Excel specifies (in the status bar) to press 'Escape' key to cancel the refresh, but it isn't working
I would just want to refresh the data model on demand, not each time I go back to excel !
I'm probably not the only guy to have this, so do you know any trick or option to cancel / avoid data model refresh when go back to Excel (from power query)
Thank you for your help
Last edited: