Tutorial: Azure AD SSO integration with Tableau Cloud
In this tutorial, you'll learn how to integrate Tableau Cloud with Azure Active Directory (Azure AD). When you integrate Tableau Cloud with Azure AD, you can:
- Control in Azure AD who has access to Tableau Cloud.
- Enable your users to be automatically signed-in to Tableau Cloud with their Azure AD accounts.
- Manage your accounts in one central location - the Azure portal.
To get started, you need the following items:
- An Azure AD subscription. If you don't have a subscription, you can get a free account.
- Tableau Cloud single sign-on (SSO) enabled subscription.
This integration is also available to use from Azure AD US Government Cloud environment. You can find this application in the Azure AD US Government Cloud Application Gallery and configure it in the same way as you do from public cloud.
In this tutorial, you configure and test Azure AD single sign-on in a test environment.
- Tableau Cloud supports SP initiated SSO.
- Tableau Cloud supports automated user provisioning and deprovisioning (recommended).
Add Tableau Cloud from the gallery
To configure the integration of Tableau Cloud into Azure AD, you need to add Tableau Cloud from the gallery to your list of managed SaaS apps.
- Sign in to the Azure portal using either a work or school account, or a personal Microsoft account.
- On the left navigation pane, select the Azure Active Directory service.
- Navigate to Enterprise Applications and then select All Applications.
- To add new application, select New application.
- In the Add from the gallery section, type Tableau Cloud in the search box.
- Select Tableau Cloud from results panel and then add the app. Wait a few seconds while the app is added to your tenant.
Alternatively, you can also use the Enterprise App Configuration Wizard. In this wizard, you can add an application to your tenant, add users/groups to the app, assign roles, as well as walk through the SSO configuration as well. Learn more about Microsoft 365 wizards.
Configure and test Azure AD SSO for Tableau Cloud
In this section, you configure and test Azure AD single sign-on with Tableau Cloud based on a test user called Britta Simon. For single sign-on to work, a link relationship between an Azure AD user and the related user in Tableau Cloud needs to be established.
To configure and test Azure AD SSO with Tableau Cloud, perform the following steps:
- Configure Azure AD SSO - to enable your users to use this feature.
- Configure Tableau Cloud SSO - to configure the single sign-on settings on application side.
- Create Tableau Cloud test user - to have a counterpart of B.Simon in Tableau Cloud that is linked to the Azure AD representation of user.
- Test SSO - to verify whether the configuration works.
Configure Azure AD SSO
Follow these steps to enable Azure AD SSO in the Azure portal.
In the Azure portal, on the Tableau Cloud application integration page, find the Manage section and select single sign-on.
On the Select a single sign-on method page, select SAML.
On the Set up single sign-on with SAML page, click the pencil icon for Basic SAML Configuration to edit the settings.
On the Basic SAML Configuration section, perform the following steps:
a. In the Sign on URL text box, type the URL:
b. In the Identifier (Entity ID) text box, type the URL:
You will get the
<entityid>value from the Set up Tableau Cloud section in this tutorial. The entity ID value will be Azure AD identifier value in Set up Tableau Cloud section.
On the Set up Single Sign-On with SAML page, in the SAML Signing Certificate section, click Download to download the Federation Metadata XML from the given options as per your requirement and save it on your computer.
On the Set up Tableau Cloud section, copy the appropriate URL(s) as per your requirement.
Create an Azure AD test user
In this section, you'll create a test user in the Azure portal called B.Simon.
- From the left pane in the Azure portal, select Azure Active Directory, select Users, and then select All users.
- Select New user at the top of the screen.
- In the User properties, follow these steps:
- In the Name field, enter
- In the User name field, enter the firstname.lastname@example.org. For example,
- Select the Show password check box, and then write down the value that's displayed in the Password box.
- Click Create.
- In the Name field, enter
Assign the Azure AD test user
In this section, you'll enable B.Simon to use Azure single sign-on by granting access to Tableau Cloud.
- In the Azure portal, select Enterprise Applications, and then select All applications.
- In the applications list, select Tableau Cloud.
- In the app's overview page, find the Manage section and select Users and groups.
- Select Add user, then select Users and groups in the Add Assignment dialog.
- In the Users and groups dialog, select B.Simon from the Users list, then click the Select button at the bottom of the screen.
- If you are expecting a role to be assigned to the users, you can select it from the Select a role dropdown. If no role has been set up for this app, you see "Default Access" role selected.
- In the Add Assignment dialog, click the Assign button.
Configure Tableau Cloud SSO
To automate the configuration within Tableau Cloud, you need to install My Apps Secure Sign-in browser extension by clicking Install the extension.
After adding extension to the browser, click on Set up Tableau Cloud will direct you to the Tableau Cloud application. From there, provide the admin credentials to sign into Tableau Cloud. The browser extension will automatically configure the application for you and automate steps 3-7.
If you want to set up Tableau Cloud manually, in a different web browser window, sign in to your Tableau Cloud company site as an administrator.
Go to Settings and then Authentication.
To enable SAML, Under Authentication types section. Check Enable an additional authentication method and then check SAML checkbox.
Scroll down up to Import metadata file into Tableau Cloud section. Click Browse and import the metadata file, which you have downloaded from Azure AD. Then, click Apply.
In the Match assertions section, insert the corresponding Identity Provider assertion name for email address, first name, and last name. To get this information from Azure AD:
a. In the Azure portal, go on the Tableau Cloud application integration page.
b. In the User Attributes & Claims section, click on the edit icon, perform the following steps to add SAML token attribute as shown in the below table:
Name Source Attribute DispalyName user.displayname
c. Copy the namespace value for these attributes: givenname, email and surname by using the following steps:
d. Click user.givenname value
e. Copy the value from the Namespace textbox.
f. To copy the namespace values for the email and surname repeat the above steps.
g. Switch to the Tableau Cloud application, then set the User Attributes & Claims section as follows:
Email: mail or userprincipalname
Full name: displayname
Create Tableau Cloud test user
In this section, you create a user called Britta Simon in Tableau Cloud.
On Tableau Cloud, click Settings and then Authentication section. Scroll down to Manage Users section. Click Add Users and then click Enter Email Addresses.
Select Add users for (SAML) authentication. In the Enter email addresses textbox add email@example.com
Click Add Users.
In this section, you test your Azure AD single sign-on configuration with following options.
Click on Test this application in Azure portal. This will redirect to Tableau Cloud Sign-on URL where you can initiate the login flow.
Go to Tableau Cloud Sign-on URL directly and initiate the login flow from there.
You can use Microsoft My Apps. When you click the Tableau Cloud tile in the My Apps, this will redirect to Tableau Cloud Sign-on URL. For more information about the My Apps, see Introduction to the My Apps.
Once you configure Tableau Cloud you can enforce Session control, which protects exfiltration and infiltration of your organization’s sensitive data in real time. Session control extends from Conditional Access. Learn how to enforce session control with Microsoft Defender for Cloud Apps.