Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
has this been solved?
Is there a way to import data from a database and then remove all connection with the database?
@Anonymous -
ehm... this is not M code
and we are looking for a Power BI option
@Anonymous - Yeah, I just don't know of a way to do it all within Power Query.
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...
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!
Sorry I'm not that familiar with Power BI, can you please expand?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |