Is there a way to import data from a database (Oracle in this case) and then remove all connection from the database? My report is connected to a secure database that will lock if there is a connection to a source for a long period of time. I've tried disabling background data preview and auto refresh but the database still locks. If I could just connect, import, extract data and kill off any connection with the database it would be very helpful.
Also, I am not using a gateway connection - I established connection with Oracle via the Client file, tnsnames.ora, ODBC etc.
As we know, If the connection type is import. Once finished, all of the data are stroed on-promise. You can refer to the blog what makes up a pbix. If you refresh the data in Power BI desktop manually, Then you need connect to the data source once again.
I understand that logically data should be stored on-premise and there won't be any connection to the database until I attempt refresh. However, if I try to edit my query and the database is affected in some way (locked etc.) I cannot access the data.
I don't understand how this could be, since after the import the data should just be available to me regardless of the data source as long as I don't refresh...