Extract Data and Cut off Connection

[Anonymous]

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. 

[Anonymous]

has this been solved?

Is there a way to import data from a database and then remove all connection with the database?

[Greg_Deckler]

@Anonymous - 

1. Import data
2. Go to data view in Desktop, right click table, copy data
3. Paste date into excel
4. Delete table
5. Import data from Excel
6. No more connection to database

[Anonymous]

ehm... this is not M code

and we are looking for a Power BI option

[Greg_Deckler]

@Anonymous - Yeah, I just don't know of a way to do it all within Power Query.

[v-frfei-msft]

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

[Anonymous]

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... 

[Greg_Deckler]

Well, in theory you could not go through the wizard and just write the M code in the Advanced Editor perhaps?

[Anonymous]

@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! 

[Anonymous]

Sorry I'm not that familiar with Power BI, can you please expand?