ReleaseBytes
aws AWS Big Data Blog ·

Direct Power BI connectivity to SageMaker Unified Studio via Athena ODBC driver

bloganalyticsawsgaengineeraws-sagemakeraws-iam
feature

Amazon has enhanced the Athena ODBC driver (v2.2.0+) to enable direct authentication for connecting Microsoft Power BI to Amazon SageMaker Unified Studio data catalogs. This update eliminates the prior reliance on third-party bridge components, simplifying architecture and reducing licensing costs and maintenance overhead. It introduces new `SageMakerBrowserIdc` and `SageMakerIam` authentication modes to facilitate these connections for IDC-based domains. Data analysts can now access governed data in SageMaker Unified Studio through Power BI without changing existing tools or workflows.

  • →Add a connection name (for example, pbi-idcdomain). The next step depends on the method that you chose: Method 1 (DSN-based)
  • →Add the DSN (for example, pbi-idcdomain) that matches exactly the one configured on Power BI Desktop. Method 2 (DSN-less)
Features (5) ›

  • Add AWSReservedSSO_SageMakerDataAnalyst_1234example as a domain IAM user: see Managing users in the Amazon SageMaker Unified Studio Admin Guide. Choose Current account

  • Add AWSReservedSSO_SageMakerDataAnalyst_1234example as a project member: see Add project members in the Amazon SageMaker Unified Studio User Guide. Gather configuration values Gather the following connection values from your Amazon SageMaker Unified Studio project:

  • Add the IAM pbi-gateway-role role as a domain IAM user: see Managing users in the Amazon SageMaker Unified Studio Admin Guide. Choose Current account (or Associated account if your gateway is deployed in a different account). The following screenshot, from the Amazon SageMaker page of the AWS Management Console, shows the list of users of your Amazon SageMaker Unified Studio domain, including the IAM gateway role. Add the IAM pbi-gateway-role role as a project member: see Add project members in the Amazon SageMaker Unified Studio User Guide. The following screenshot shows the Amazon SageMaker

  • Add a connection name (for example, pbi-idcdomain). The next step depends on the method that you chose: Method 1 (DSN-based)
  • Add the DSN (for example, pbi-idcdomain) that matches exactly the one configured on Power BI Desktop. Method 2 (DSN-less)
Read the original announcement →

https://aws.amazon.com/blogs/big-data/connect-amazon-sagemaker-unified-studio-to-microsoft-power-bi-part-1-iam-identity-center-idc-based-domains/

Related releases