Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PowerBI data gateway with Azure AD SSO

Azure SQL Databaseを東日本と西日本のリージョンに作成する予定です。東日本のAzureSQLがプライマリで、西日本のAzureSQLはGeoレプリカとなります。 PowerBIワークスペース上に PBIX/RDLのレポートを作成したいと考えています。東日本と西日本の各リージョンにdata gatewayを作成します。データゲートウェイを作成するのは、Azure SQLのFire...
data protection
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    Hi Anonymous  ，

    You need to configure the Kerberos Constrained Delegation carefully. Please follow the document closely. 

    You can download and install it as before(You can download the on-premise data gateway here: https://www.microsoft.com/en-us/download/details.aspx?id=53127), just add a new feature to the data gateway. Once the data gateway in online and you create a SQL Server data source, you will see the SSO option under Advanced Settings. But you need to configure the Kerberos Constrained Delegation carefully. Please follow the document closely. 

     

     

    Wish it is helpful for you!

     

    Best Regards

    Lucien

     

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

I find an article tells more details, and i tink it is helpful for you!

Configure Kerberos-based SSO from Power BI service to on-premises data sources

If Azure AD Connect is configured and user accounts are synchronized, the gateway service doesn't need to perform local Azure AD lookups at runtime. Instead, you can simply use the local service SID for the gateway service to complete all required configuration in Azure AD. The Kerberos constrained delegation configuration steps outlined in this article are the same as the configuration steps required in the Azure AD context. They are applied to the gateway's computer object (as identified by the local service SID) in Azure AD instead of the domain account.

 

 

Best Regards

Lucien