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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Data Refresh Concern

Hi,

 

I have my data set in Oracle. However i need to update my data regularly according to incremental files .

So every month I have an updated data set in database.

 

I am unable to identify a solution to the following:

 

1) Data needs to be updated monthly in the data set in oracle.

2) The updated data must then be refreshed in the Power Bi visuals.

 

How can I do the above 2 steps without running an external script .

 

What I need is -> Whenever I open my Power Bi report, in the backend oracle must update data first , once table is updated, Power bi visuals must update.

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@Anonymous,

Firstly, to update data in Oracle database from files regularly, you can consider to use SSIS, there is a blog for your reference. And as the issue is more related to Oracle, please post the question in Oracle forum to get better support.

Secondly, in Power BI Desktop, you can connect to Oracle database to import data from required tables, create report in Power BI Desktop and publish the report to Power BI Service. In Power BI Service, add the Oracle data source within gateway, and then you can set schedule refresh for the dataset. This way, once data is changed in Oracle table, the Power BI report will get updated automatically based on refresh schedule. For more details, please review this article: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-manage-oracle.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@Anonymous,

Firstly, to update data in Oracle database from files regularly, you can consider to use SSIS, there is a blog for your reference. And as the issue is more related to Oracle, please post the question in Oracle forum to get better support.

Secondly, in Power BI Desktop, you can connect to Oracle database to import data from required tables, create report in Power BI Desktop and publish the report to Power BI Service. In Power BI Service, add the Oracle data source within gateway, and then you can set schedule refresh for the dataset. This way, once data is changed in Oracle table, the Power BI report will get updated automatically based on refresh schedule. For more details, please review this article: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-manage-oracle.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.