Connecting a datazone project to power BI

Yes please follow the steps to Connect DataZone to Power BI:

1. Enable Authentication: o Use the Athena JDBC Driver provided by Amazon DataZone to authenticate and establish a connection between DataZone and Power BI.

2. Configure the Connection: o Copy the JDBC connection string from the DataZone portal. o In Power BI, navigate to Get Data > Other > ODBC and paste the JDBC connection string. o Authenticate using single sign-on (SSO) or other supported methods.

3. Query and Visualize Data: o Once connected, users can query the subscribed datasets directly within Power BI.

4. Ensure Governance: o DataZone ensures secure and governed access to datasets, so users can confidently analyze data while adhering to organizational policies.

Great question, and one we've seen come up a lot. The challenge with the JDBC Driver approach outlined here is that Power BI is ODBC-native, so using JDBC Driver requires a bridge layer that introduces latency and maintenance overhead.

We just released native DataZone support in the Simba Athena ODBC driver (v2.0.0.1000), which lets you connect Power BI directly to DataZone without a bridge. It supports both DataZone IAM and IDC authentication out of the box. You can grab the driver here: https://insightsoftware.com/drivers/athena-odbc-jdbc/"