Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

ehm... this is not M code

and we are looking for a Power BI option