How to Connect Power BI to Amazon DataZone (Without a JDBC Bridge)

Amazon DataZone is a powerful data management service that lets teams catalog, discover, and govern data across AWS environments. But when it comes to connecting your BI tools, options are limited. Data teams trying to connect Power BI to Amazon Datazone often hit the same wall when every guide, forum thread, and AWS doc points you toward a JDBC bridge or driver. However, Power BI doesn’t speak JDBC natively, which quietly costs data teams time, stability, and patience.

Here, we discuss how to connect Power BI to Amazon Datazone without needing a JDBC bridge.

The Problem With the Current Workaround

If you search for how to connect Power BI to Amazon DataZone, you’ll find the same answer everywhere. On AWS re:Post, Amazon’s community forum, the suggested approach is to grab the Athena JDBC driver, copy your JDBC connection string from the DataZone portal, and paste it into Power BI’s ODBC connector.

The problem that arises here is JDBC and ODBC aren’t interchangeable. Pointing Power BI’s ODBC connector at a JDBC connection string doesn’t work without a bridge layer sitting in between. A bridge creates instability, latency, and maintenance headaches for data teams. If you’ve ever wondered why your DataZone connection feels slower than it should, or why it breaks after an AWS update, the bridge is usually the culprit.

Why ODBC Matters for Power BI (and Every Other BI Tool)

ODBC is the foundation that most enterprise BI tools are built on. Power BI, Tableau, Excel, Qlik, and dozens of other analytics platforms all support ODBC as a first-class connection type. To bridge the gap, seek out an ODBC driver with native support for Amazon DataZone.

When your data connectivity is ODBC-native, you get:

• Better performance: data moves directly from source to tool without an intermediary translation layer
• Broader compatibility: one driver works across your entire BI stack
• Simpler maintenance: no bridge software to update, license, or troubleshoot separately
• Enterprise-grade security: full support for IAM and IDC authentication, keeping access controls consistent with the rest of your AWS environment

What Changed: Native ODBC Support for Amazon DataZone

The Simba Athena ODBC driver from insightsoftware now includes native support for Amazon DataZone. With no bridge required, the Simba Athena ODBC driver adds two new authentication methods built specifically for DataZone:

• DataZone IAM Auth Plugin: authenticate using AWS IAM credentials directly through the driver
• DataZone IDC Auth Plugin: authenticate using AWS IAM Identity Center (IDC) for organizations using centralized identity management

Both authentication types are configurable through the driver’s Auth Type setting, with full documentation available in the Installation and Configuration Guide. This is a direct, standards-based ODBC connection that works reliably at enterprise scale with no middleware standing between your data and your dashboards.

How to Connect Power BI to Amazon DataZone Using the Simba Athena ODBC Driver

Getting Power BI connected to DataZone is straightforward once you have the right driver in place.

Step 1: Download the Simba Athena ODBC Driver

Visit our Simba Athena ODBC/JDBC driver page and download the latest version (2.0.0.1000 or later). Make sure you select the version that matches your operating system and architecture.

Step 2: Install and Configure the Driver

Run the installer and open the ODBC Data Source Administrator. Under System DSN, add a new data source and select the Simba Athena ODBC Driver.

Step 3: Configure DataZone Authentication

In the Auth Type drop-down, select either DataZone IAM Auth Plugin or DataZone IDC Auth Plugin depending on your organization’s AWS identity setup. Enter the required credentials and connection details as outlined in the Installation and Configuration Guide.

Step 4: Test the Connection

Use the built-in test connection option to verify your credentials and confirm connectivity before moving to Power BI.

Step 5: Connect Power BI

Open Power BI Desktop, select Get Data, and choose ODBC as your connection type. Select the DSN you configured in the previous steps, authenticate, and you’re in. Your DataZone data is now available for reporting and visualization. No bridge, no workaround, no extra layer to maintain.

The Bigger Picture: Data Connectivity That Doesn’t Break

The Simba Athena ODBC driver is part of a portfolio of approximately 60 meticulously maintained drivers from the same team that co-created the ODBC standard with Microsoft in 1992. When AWS updates its APIs or authentication requirements, Simba updates with it. That’s not a guarantee you get from a community-built bridge or a one-time integration script.

For data teams that rely on Amazon DataZone as part of their governance and analytics infrastructure, having a stable, supported ODBC connection becomes a necessity. The Simba Athena driver delivers a strong connection with enterprise authentication support and long-term maintenance commitment that mission-critical data workflows demand.

Ready to learn more? Watch our on-demand webinar about enhancing BI with advanced data connectivity.

The post How to Connect Power BI to Amazon DataZone (Without a JDBC Bridge) appeared first on insightsoftware.