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

has this been solved?

 

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

  • Greg_Deckler's avatar
    Greg_Deckler
    Community 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

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        6 years ago

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