Forum Discussion
Extract Data and Cut off Connection
Hello,
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.
Thank you.
9 Replies
Well, in theory you could not go through the wizard and just write the M code in the Advanced Editor perhaps?
Greg_Deckler : That would be *the* solution! is it possible? can you provide sample M code to show how to "remove all connection with a database" after import data from it? (:
thanx!
Hi Anonymous,
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.
https://www.fourmoo.com/2017/05/02/what-makes-up-a-power-bi-desktop-pbix-file/
Regards,
Frank
Hello, thank you for taking the time.
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...
Anonymous -
- Import data
- Go to data view in Desktop, right click table, copy data
- Paste date into excel
- Delete table
- Import data from Excel
- No more connection to database
