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
Hi v-jiascu-msft, thank you so much for your prompt reply! In response to your questions:
The database is on-premise.
I understand that an automated approach for a monthly pull would be overkill for a system designed for real-time analysis. Are you aware of another more appropriate option? I'd prefer not to do it manually since I'm hoping to bring some new capability to the function & organization.
I'm happy to work the code as you've mentioned since I doubt that the company I work for would allow the use of third party software, like Postman, without some rigorous testing. Any advice on where to start?
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