Easy Tech TutsHow to Connect to an Oracle Database in Power BI Easily 2026
By Impran M N
Connecting Power BI to an enterprise Oracle database used to mean installing heavy external clients and wrestling with unmanaged driver configurations. Power BI now bundles a Managed ODP.NET provider, which removes most of that setup friction. This guide covers activating that built-in driver and mapping your Oracle tables into a report.
01Enable the built-in Oracle driver
Turn on the bundled Oracle Managed ODP.NET provider through the preview toggle in Power BI Desktop's options rather than installing an external client.
02Choose your connection string format
Enter either an Easy Connect string or a TNS network service name to point Power BI at the correct Oracle instance.
03Authenticate with your database credentials
Provide the database username and password needed to establish a secure connection to the Oracle server.
04Map tables in the Data Navigator
Browse and select the specific warehouse tables you want to bring into your data model using the Data Navigator panel.
05Publish without gateway blockers
Publish your dashboard to the cloud workspace, relying on the Fabric direct cloud sync where applicable to avoid unnecessary gateway setup.
Frequently asked questions
Do I still need to install an external Oracle client?
No, Power BI's newer bundled Oracle Managed ODP.NET provider eliminates the need for a separate external driver installation in most cases.
What's the difference between Easy Connect and TNS names?
Easy Connect uses a simple host and service name string, while TNS names rely on a configuration file mapping named connections to Oracle instances.
Why is my Oracle connection failing after entering credentials?
Double-check that your connection string format matches what your specific Oracle instance expects, since Easy Connect and TNS syntax differ.
Do I need a gateway to refresh Oracle data on a schedule?
If the Oracle database is on-premises, a gateway is typically required for scheduled refresh in the cloud service.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
