Simplified Oracle connectivity in Power BI (Preview)
Connecting Power BI to Oracle has historically meant extra provider installations and data gateway deployment — even for cloud-hosted databases. Two new Preview capabilities change that. Power BI Desktop now includes a bundled Oracle Managed ODP.NET provider, and the Power BI service supports direct cloud connections without the need for a data gateway to Oracle data sources such as Oracle Autonomous Database. How it works in Power BI Desktop Power BI Desktop ships with the Oracle Managed ODP.NET provider built in. To turn it on, go to File > Options and settings > Options > Preview features and enable both switches: Enable using Bundled Oracle Managed ODP Provider for Import Mode Enable using Bundled Oracle Managed ODP Provider for DirectQuery Mode Figure: Enabling Oracle preview features. Restart Power BI Desktop, then connect to your Oracle database through the existing Oracle database connector. Both Import and DirectQuery work without any additional client installat...