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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Varice
New Member

Refresh and upload INTO Oracle

I need to refresh Oracle data and then upload the data INTO Oracle. 

So download Oracle data, refresh it and upload into Oracle. I cannot find any data/tutorials to upload into Oracle, only the other way areount. Is it possible? If so, how?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Power Query was never designed to write data back into data sources.  There are accidental ways to do it (bad queries, for example) but the results will not be deterministic.

 

Power BI as a whole is still very much a one way street.  For the full roundtrip use proper ETL tools like SSIS , or Power Automate or PowerApps.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Power Query was never designed to write data back into data sources.  There are accidental ways to do it (bad queries, for example) but the results will not be deterministic.

 

Power BI as a whole is still very much a one way street.  For the full roundtrip use proper ETL tools like SSIS , or Power Automate or PowerApps.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 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.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors