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...
Connectors and driver changes For the following connectors, Power BI/Fabric will move away from the current embedded ODBC drivers and toward the replacement drivers (primarily ADBC). Databricks: Simba Spark ODBC Driver → Databricks ADBC Driver Dremio: Simba Drill ODBC Driver → FlightSQL ADBC Driver Google BigQuery: Simba Google BigQuery ODBC Driver → BigQuery ADBC Driver Hive: Simba Hive ODBC Driver → Deprecated Impala: Simba Impala ODBC Driver → HiveServer2 ADBC Driver Snowflake: Simba Snowflake ODBC Driver → Snowflake ADBC Driver Spark: Simba Spark ODBC Driver → HiveServer2 ADBC Driver Who’s impacted You are impacted if you use any of the connectors in the previous list and meet one of the following conditions: You haven’t explicitly specified an implementation for the connection Your organization wants centralized control over whether ADBC or ODBC is used by default. This default behavior is intended to apply anywhere a connection is created (e.g., semantic model...