Forum Discussion
Using Push Dataset from an Oracle Database
Hi cmzp,
Seems you just want to get this work done automatically. I would suggest you do it in a normal way and set up a scheduled refresh, which can retrieve new data automatically in a predefined interval. Please refer to https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh.
Best Regards,
Dale
I am facing a simillar problem, my organization also uses an on-premise oracle database. I have to query the database on daily basis for a dashboard in PowerBI. I also dont want the dataset to inculde the enitre data from the beging of time because that would be huge, So to keep track of the performce I have to query the database daily specifing the date which makes a new dataset in PBI Service and I have to delete the old dataset on next day and querry the database again and redo the enitre process for the dashboard I want automate this process where a single query can update the dataet with the new data every day and that day's performace can be reviewed from the Dashboard.
Here is the dashbaord I am using to keep track of the daily performace.
Please help! 🙏🙏🙏