Tableau Dataset Connector to Microstrategy REST API URL
The MicroStrategy Dataset Connector is an out‑of‑the box feature that 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.
Tableau Public 10.4 or later is needed.
- 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: 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 Connect
- Select the dataset you want to import.
- Select the attributes, metrics, and filters to include.
- Click Data Preview to preview your data.
- Click Submit.
- Click Update Now or Automatically Update to finish importing your dataset into Tableau.
All users attempting to the Tableau connector in MicroStrategy 2019 Update 2 must be assigned the Use Application Tableau privilege, directly or as part of a User Group or Security Role. This privilege can be found in the Client-Application-Tableau privilege group.
Comments
Post a Comment