Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi, I am new to Power BI so please help me.
I want to connect to an Oracle database from Power BI Desktop, retrieve data, and share reports I've created.
Power BI is only a reference to the database, is there no worry about writing data directly from Power BI to the database?
I would like to ask you a question because it would be a problem if the data on the database was unintentionally changed/written/deleted while creating/sharing reports.
Solved! Go to Solution.
Hello @Anonymous !
About writing back in the database, there is no button to do this. However, it is possible to use Power APPs/Power Automate or this trick (https://bielite.com/blog/write-back-to-sql-database-from-power-bi).
If I can give a council: create a user with permission just to read the database, and then use this user to connect in database.
If this posts helps, please mark as solved to help other users find quickly in our community
Regards,
Marcel
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
Hello @Anonymous !
About writing back in the database, there is no button to do this. However, it is possible to use Power APPs/Power Automate or this trick (https://bielite.com/blog/write-back-to-sql-database-from-power-bi).
If I can give a council: create a user with permission just to read the database, and then use this user to connect in database.
If this posts helps, please mark as solved to help other users find quickly in our community
Regards,
Marcel
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 37 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 89 | |
| 73 | |
| 66 | |
| 65 |