--- schema_version: "1" id: acf5f35b45e2036241ae3f1779350338db869d3eec9e8afb07b2b0591001a2a2 title: Access Tableau Content in Microsoft 365 collection: tableau version: current locale: en-us portal_url: https://docs.salesforce.com/tableau/current/en-us/server-linux/teams_explore.md canonical_url: https://help.tableau.com/current/server-linux/en-us/teams_explore.htm source_site: help.tableau.com content_type: documentation content_hash: 64a62463c8f3e95e658ad04297738ac4e42cc0848e19097f8c90a552828c61b0 description: Access and share Tableau content in Microsoft Teams, Word, and PowerPoint. --- [Skip to main content](#main-content) # Access Tableau Content in Microsoft 365 The Tableau app for Microsoft 365 is available in Teams, Word, and PowerPoint. With the Teams app, you can interact with views (visualizations) and metrics and share them in messages, channels, and meetings. With the Word and PowerPoint add-ins, you can add image snapshots of views and metrics to your documents and slides and refresh those snapshots to keep them up to date. With the Excel add-in, you can export data from Tableau views and published data sources into a worksheet, refresh it on demand, and publish Excel data back to Tableau Cloud. For the Tableau app to be available in Microsoft 365, your admin must deploy it and connect it to your Tableau site. For information about installing the Tableau app as an admin, see [Set Up the Tableau App for Microsoft 365](https://help.tableau.com/current/server-linux/en-us/teams_set_up.htm). Note: If you've set the language in Tableau or Microsoft 365 to a Tableau-supported language other than English (US), you might see text in English that isn't localized. ## Use the Teams app If your admin didn’t pre-install the app for you but has deployed it for your organization, you can install the app yourself. To learn how, see [Add an app to Microsoft Teams](https://support.microsoft.com/en-us/office/add-an-app-to-microsoft-teams-b2217706-f7ed-4e64-8e96-c413afd02f77) in the Microsoft Teams documentation. The Teams app has three tabs: Tableau, Pulse, and Configuration. The Tableau tab shows the views that you’ve added as favorites. The Pulse tab shows the metrics that you follow and a summary of insights about those metrics. Be aware that the Pulse tab appears only for Tableau Cloud sites. The Configuration tab lets you set the site that Microsoft Teams checks when you search for content and, if you’re a Tableau admin, add and remove site configs. If you don’t have any favorite views or followed metrics, you won’t see any content in the app. Sign in to your Tableau site directly to add views as favorites and to follow metrics. For more information, see [Mark Favorites](https://help.tableau.com/current/pro/desktop/en-us/favorites.htm) and [Follow Metrics](https://help.tableau.com/current/online/en-us/pulse_explore_metrics.htm#follow-metrics). Though it's possible to add other types of content as favorites, none of your favorite content besides views appears in the Tableau app. If you want to see all of the views in a workbook, add each individual view to your favorites. ### Explore content in Teams On the Tableau or Pulse tab, click on the card for a view or metric to open the full interactive version. The interactive view or metric allows you to see more details about the data and filter the data based on different dimensions or time ranges. #### Search for content If you know the name of a view or metric, you can search for it in the Tableau app. You can also enter the URL to a view in the search bar to access specific content or custom views. 1. On the Tableau or Pulse tab, select the search icon. ![Tableau app search entry point](/tableau/current/en-us/server-linux/en-us/Img/teams_app_search.png) 2. Enter the name of the view or metric. 3. Select the open button next to the view or metric name to go to the interactive version. #### Follow a metric Each metric represents a unique set of filters. When you filter an existing metric, you create a new metric if one doesn’t already exist with those filters. Follow the new metric to see it on your Pulse tab and in your insight summary. 1. On a metric, select the follow (subscribe to this metric) icon. ![Follow icon on a metric](/tableau/current/en-us/server-linux/en-us/Img/teams_app_follow.png) You can unfollow the metric by selecting the button again. #### Share content 1. On a view or a metric, select the share icon. ![Share icon](/tableau/current/en-us/server-linux/en-us/Img/teams_app_share.png) 2. Select the person, group chat, or channel to share with. 3. Select Share. #### Switch sites 1. On the Tableau or Pulse tab, select the site name from the breadcrumb menu. If more than one site is connected to the Tableau app, you see a list of sites. ![Site switch options](/tableau/current/en-us/server-linux/en-us/Img/teams_app_switch_site.png) 2. Select the site that you want to switch to. ### Add Tableau content to channels and meetings #### Pin content in a channel tab 1. In the channel where you want to pin Tableau content, select the + icon to add a tab. ![Add a channel tab options](/tableau/current/en-us/server-linux/en-us/Img/teams_app_channel_tab.png) 2. From the list of apps, select the Tableau app. 3. Select the content to pin. To pin a custom view, select the search button and enter the view URL. You can pin one view and up to five metrics per tab. To pin more Tableau content, add a second tab. ![Tableau views and metrics to pin](/tableau/current/en-us/server-linux/en-us/Img/teams_app_pin_content.png) 4. Select Save. 5. Optionally, to rename the tab, select the dropdown menu on the tab, then select Rename. ![Rename option for the Tableau tab](/tableau/current/en-us/server-linux/en-us/Img/teams_app_rename_tab.png) #### Add Tableau content to a meeting You must first create a meeting and then add Tableau content. You can't add third-party apps during the creation of a meeting. 1. In the Calendar app, find the meeting that you want to add Tableau content to, then select Edit. 2. Select More options. 3. From the toolbar, select Apps. 4. From the list of apps, select the Tableau app. 5. Select the content to pin. 6. Select Save. 7. Save the changes to the meeting. 8. After you start the meeting, select the Tableau tab. This opens the Tableau content in a side panel, which is visible to only you. 9. On the side panel, select the share to stage button. This makes the content visible to others in the meeting. Be aware that the content that you share appears to others as you see it, similar to how screen sharing works. If there's row-level security on the data, everyone in the meeting sees your view of the data. ### Share Tableau content in messages If you know the URL for a view or metric, you can quickly share that content by pasting the URL into a message. The Tableau message extension turns the link into a card that shows the content title and a thumbnail, with a button to open the full interactive view or metric. If you don’t know the URL of the content that you want to send, you can search for content to share. 1. On a message, select the + (Actions and apps) icon. 2. Select the Tableau app. 3. Search your Tableau site for the view or metric that you want to share. 4. Select the view or metric. It takes a moment to generate the card for this content. ![Metric card in a Teams message](/tableau/current/en-us/server-linux/en-us/Img/teams_app_metric.png) 5. Send the message. ## Use the Word and PowerPoint add-ins The Tableau add-in appears on the Home tab in Microsoft Word and PowerPoint. To learn how to access an add-in, see [Start using your Office Add-in](https://support.microsoft.com/en-us/office/start-using-your-office-add-in-82e665c4-6700-4b56-a3f3-ef5441996862) in the Microsoft documentation. Note that for the Tableau app to be available for you to use, your Microsoft 365 admin must first deploy it and connect it to a Tableau site. ### Add a visualization or metric to documents and slides With the Tableau add-in, you can add an image snapshot of a visualization or metric to your documents and slides. Note that Tableau Pulse metrics are available only for Tableau Cloud. These images show the time at which they were added and the user who added them, and the image links to the content in Tableau Cloud or Tableau Server. The image is the same for all users, so if there’s row-level security applied to the data, the image shows the view of the data that’s specific to the user who added the image. If other users open the image link in Tableau Cloud or Tableau Server, those users see the interactive view or metric with their credentials applied. 1. From the Home tab, select the Tableau add-in. 2. Select Insert Viz Image or Insert Pulse Image. ![Insert viz or metric options for Microsoft 365 add-in](/tableau/current/en-us/server-linux/en-us/Img/microsoft_365_add_in.png) 3. Either search for the name of the view or metric that you want to add, or select from your favorite views or followed metrics. 4. On the preview of the view or metric, select Insert Image. If you have the Tableau site URL of the content that you want to add, you can instead choose Insert Content from URL. #### Use a custom view to show filtered data To add a filtered view of the data, insert a custom view. 1. Open the view in Tableau Server or Tableau Cloud. 2. Filter the view to show the data that you want to include in the snapshot, then create a custom view. For more information, see [Use Custom Views](https://help.tableau.com/current/server/en-us/customview.htm). 3. Open the Tableau add-in in Word or PowerPoint. 4. Select Insert Content from URL, then paste in the URL for the custom view. ### Refresh a visualization or metric The image is a snapshot taken at the time that you add it. If the image no longer represents the latest data, refresh it. 1. From the Home tab, select the Tableau add-in. 2. Select Refresh Data. The Tableau add-in identifies all of the Tableau images in your document or slides. 3. Select the content that you want to refresh, then select Refresh Selected. ## Use the Excel add-in The Tableau add-in for Microsoft Excel lets you move data between Tableau and your workbooks. You can pull data from Tableau views and published data sources into a worksheet, refresh it on demand, and publish Excel data back to Tableau Cloud. The add-in appears on the Home tab in Microsoft Excel and opens in a task pane, the same way the Word and PowerPoint add-ins do. Note: Importing data into Excel and publishing Excel data are supported on Tableau Cloud. Publishing to Tableau Cloud from Excel is not supported on Tableau Server. To get started, select the Tableau add-in on the Home tab, choose your Tableau site, and then choose whether to import data from Tableau or export your Excel data to Tableau Cloud. ### Import data from Tableau 1. Open Excel and select the Tableau add-in on the Home tab to open the task pane. 2. Choose your Tableau site. 3. Choose a data source type. There are two import paths: **Published data source imports** offer a full query builder with field selection and aggregation controls **Tableau View and URL imports** bring in the data as-is with no additional filtering. #### From a worksheet or view 1. Search by name or paste a URL. 2. Preview the data. 3. Choose which rows to import. Imports are subject to standard Excel worksheet limits. Data beyond that limit is truncated. For more information about Excel worksheet limits, see [Excel specifications and limits.](https://support.microsoft.com/en-us/excel/excel-specifications-and-limits) Row options include: - Autofit to capacity — fills up to the standard Excel worksheet limits. - First N rows - Last N rows **Note**: Dashboards only expose their first sheet for import. To import a specific worksheet, navigate directly to that worksheet instead. #### From a URL 1. Paste the URL and select Search. 2. Preview the data, then select Import Data from Tableau. 3. Select OK to confirm. #### From a published data source 1. Confirm the source is tagged `Excel`. Only tagged sources appear. 2. Pick the source and select Build new query. 3. Choose fields with the field selector (Select All or Select None). 4. Optionally, select Disaggregate Data for row-level detail. This may take a while or cause a timeout, and once aggregation is applied, disaggregation is no longer available. 5. Adjust field types and aggregation as needed. 6. Select Configure Import. 7. Preview, then select Import Data from Tableau. Large field sets may trigger a truncation warning. If this happens, create a smaller published data source that contains only the fields you need. #### Manage large imports Because the standard Excel limits apply broadly, filter your fields in Tableau, trim fields, or use aggregation instead of row-level detail to stay within the limits. Measures receive default aggregations based on your selections in the field picker, unless you choose disaggregation first. Large data sets are refreshed in incremental segments rather than through one large request, which avoids timeouts; progress is visible in the task pane. If a query takes longer than 30 seconds to run, a notification appears and the process continues in the background. ### Refresh data - Choose Update Data from the add-in menu. - Select the items to refresh. - Select a destination for refreshed data. You can choose to Refresh in a new sheet, or to Refresh in current sheet, which overwrites your data. - Select Refresh Data. The outcome of each refresh (user, timestamp, and status) is shown in the add-in task pane. ### Export Excel data to Tableau Cloud Exporting Excel data to Tableau Cloud relies on the Explore in Tableau API to preload a web authoring session with your worksheet data. 1. Open the add-in in Excel. 2. Choose your Tableau Cloud site. 3. Select Export Data 4. Select the sheets to export and then select Export to Tableau Cloud. 5. To complete the export process, review the data within Tableau Cloud by selecting View Data on Tableau Cloud. 6. From Tableau Cloud, select Publish to save your new workbook. **Note**: PivotTables, merged cells, and images from Excel aren't compatible with Tableau Cloud. Incompatible content is grayed out and blocks export until you remove it. #### Sharing considerations Sharing a workbook that contains embedded Tableau content doesn't carry over Tableau permissions. Each user who wants to refresh Tableau images or re-import data must have the appropriate permissions on the relevant data source or view. The underlying Tableau data permissions always apply, regardless of whether the workbook has been shared.