MicroStrategy for Tableau
MicroStrategy for Tableau allows you to fetch data from reports or cubes that reside in MicroStrategy projects into Tableau Public (also known as Tableau Desktop). You can import datasets with up to four million rows and 30+ columns.
Starting in MicroStrategy 2020 Update 2, you can use an independent MicroStrategy for Tableau connector as a separate web application. You can find the installer on the MicroStrategy download site.
To learn more about the MicroStrategy for Tableau connector, see KB484311: Independent MicroStrategy for Tableau connector.
Using the Tableau connector in MicroStrategy 2019 Update 2 or later requires the Use Application Tableau privilege. This privilege is located in the Client-Application-Tableau privilege group.
Starting in MicroStrategy 2021 Update 2, Java 11 is required. It is strongly recommended that you upgrade to MicroStrategy 2021 Update 2 or a later version.
To use the connector, Tableau Public 10.4 or later is needed.
- Download and extract the MicroStrategy for Tableau connector zip file.
- Run the installer.
- Deploy the .war file. See How to Set Up Application Servers for MicroStrategy for Tableau.
Import Data from MicroStrategy to Tableau
Open Tableau Desktop Public Edition. Under Connect, click Web Data Connector.
If it is not there, click More > Web Data Connector.
Enter the following URL:
- If MicroStrategForTableau.war is deployed: https://<MSTR Domain>/MicroStrategyForTableau/
- If CommunityConnectors.war is deployed: https://<MSTR Domain>/CommunityConnectors/mstr/
If the connector does not automatically detect Tableau, add the query ?mode=tableau to the end of the URL and refresh your browser.
- Enter your API Server URL and environment credentials.
Your REST API URL is your environment URL with /MicroStrategyLibrary/ added at the end.
- Click Log in with credentials.
- Select your applications.
- Click OK.
- Under Datasets, select a dataset or use the search to locate a dataset.
Select the attributes, metrics, or filters to include.
- Click Select All to either select all attributes, metrics, or filters.
- Use the View selected toggle to only see selected objects.
- Click Data Preview.
- Click Submit.
- Click Update Now or Automatically Update to finish importing your dataset into Tableau.