Data Refresh Concern

[Anonymous]

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.

[v-yuezhe-msft · Accepted solution]

@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