Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Currently running a gateway with a service account on an VM on azure. I'm able to make a connection to our on-prem oracle databases and datasets refresh sucessfully, but direct query will not work. We tried using a personal gateway as a test and that is working as expected. Has anyone else come across this issue? Do you need a separate gateway just for oracle connections?
Hi, @EMartirUH
What's the error message when connecting using direct query? Can you share the screenshot?
Personal mode doesn't support DQ connection. Have you tried installing a standard gateway on your local machine to refresh?
Reference:
On-premises data gateway - Power BI | Microsoft Docs
Use virtual network (VNet) data gateway and data sources in Power BI | Microsoft Docs
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _Janey