Forum Discussion
Do i need a gateway for a SQL Query running in the back Ground for refresh
Hi Anonymous
You would need to install and configure the gateway.
Once the dateway is done, you would then configure a scehduled refersh for your dataset.Then when a user opens the Power BI report in the service it would show the latest data.
Here are more details on how to create the gateway for Oracle: Power BI – On-Premise Gateway Configuration steps to an Oracle Database - Reporting/Analytics Made easy with FourMoo and Power BI
Super UserHi Anonymous
You would still need the Gateway if you want to use DirectQuery
You would then configure your Power BI report to use DirectQuery and not import the data. Just be aware that using DirectQuery can put a lot of load on your Oracle system
GilbertQ yes in my desktop i oped for direct query. It is just small dataset, around 200 records which keeps changing , so i need live data. I will try and update.
Thanks