Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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
@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