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  ，

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I have read that document. But I have some questions.
    Do I need a domain controller when delegating Kerberos? Is it possible to substitute with Azure AD?