SageMaker Unified Studio Links Directly with Power BI through New IAM-Based Domain
Amazon SageMaker Unified Studio can now be connected to Microsoft Power BI using an AWS Identity and Access Management (IAM)-based domain, offering a direct connection method for users. This is part two of a two-part series on connecting Amazon SageMaker Unified Studio to Microsoft Power BI.
In this post, we walk through creating the same direct connection as in Part 1, but with an IAM-based domain. The differences lie in the console navigation paths and configuration values, as well as additional administrator setup that provides AWS credentials through AWS IAM Identity Center.
The architecture remains the same as in Part 1: Power BI Desktop connects to Amazon Athena using the ODBC driver, and the on-premises data gateway bridges the connection to Power BI Service so report viewers can access published dashboards. The key difference is in authentication: An IAM-based domain uses SageMakerIam authentication for both connection methods.
The walkthrough covers two connection methods: DSN-based connection and DSN-less connection, from Power BI Desktop through the on-premises data gateway to Power BI Service. Administrator setup involves configuring AWS IAM Identity Center to provide credentials for the SageMakerIam authentication mode.