Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Will Power BI make updates to OracleDB?

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.

 

1 ACCEPTED SOLUTION
marcelsmaglhaes
Super User
Super User

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

If I've helped, don't forget to mark my post as a solution!



View solution in original post

1 REPLY 1
marcelsmaglhaes
Super User
Super User

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

If I've helped, don't forget to mark my post as a solution!



Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.