MicroStrategy for Power BI

Note

This connector is owned and provided by Microstrategy.

Summary

Property	Value
Connector	Strategy for Power BI
Products	Power BI (semantic models) Power Query Online
Release state	General availability
Category	Other
Authentication kinds	Library/OIDC Standard/LDAP
Data source kind	MicroStrategyDataset
Function Reference Documentation	MicroStrategyDataset.Contents MicroStrategyDataset.TestConnection
Support link	Contact the connector owner.

Prerequisites

Your organization must have a configured MicroStrategy environment. The user account on the MicroStrategy environment must have access to the Power BI connector.

Supported capabilities

• Import
• Data refresh

Parameters

Entry point: MicroStrategyDataset.Contents

Required parameter count: 1

Parameter	Display name	Required	Type	Group	Description	Allowed values	Sample values	Nullable	Additional metadata	Declared allowed values
libraryUrl	Strategy REST API URL	Yes	text		Please enter a valid environment URL (by default, Library authentication is used): https://.../MicroStrategyLibrary. For OIDC authentication, add the #OIDCMode parameter to the end of your valid environment URL: https://.../MicroStrategyLibrary/#OIDCMode.		"https://mycompany.microstrategy.com/MicroStrategyLibrary/"	false	{"Documentation.Category": "", "Documentation.Examples": [], "Documentation.LongDescription": "The type that represents a text URI.", "Documentation.Name": "Uri.Type", "Documentation.Description": "The type that represents a text URI."}
authMode	Authentication Mode	No	nullable text		The authentication mode used to connect to your Intelligence Server: Standard or LDAP Default is Standard	"Standard"; "LDAP"		true		["Standard", "LDAP"]
options	Advanced Options	No	nullable record	Advanced Options				true

Fields in options

Additional fields may be accepted by this open record.

Field	Display name	Required	Type	Group	Description	Sample values	Nullable	Optional
options.limit	Rows of data retrieved per request	No	nullable number	Advanced Options	Maximum number of rows returned in a single request. Used to control paging behavior. Default is 25000	"25000 (default)"	true	true
options.timeout	Timeout duration in seconds	No	nullable number	Advanced Options	The timeout setting for HTTP request to the REST API Server. Default is 100	"100 (default)"	true	true

Connect from Power Query Desktop

To connect to MicroStrategy using Power BI Desktop:

1. In Power BI Desktop, select Home > Get Data.

2. From the categories on the left, select Other > MicroStrategy for Power BI. Then select Connect.

3. If you're connecting to the MicroStrategy for Power BI connector for the first time, a third-party notice appears. Select Don't warn me again with this connector, and then select Continue.

4. Enter a valid MicroStrategy Library URL, for example, https://.../MicroStrategyLibrary.

   

   Note

   If you want to utilize OIDC authentication, you must add a #OIDCMode string to the end of the URL.

   OIDC authentication is available starting in version 2.4.5 of the connector.

   

5. (optional) Select the authentication mode. This option only affects basic authentication.

6. (optional) Fill out the advanced options, as necessary.

7. Select OK.

8. Select the authentication mode you want to use.

   

   1. Standard/LDAP

      1. Provide user and password.

      2. Select Connect.

   2. Library/OIDC

      Important

      To utilize OIDC authentication, you must add the https://oauth.powerbi.com/views/oauthredirect.html URL to the list of reply URLs in your IdP settings.

      1. Select Sign in. A popup appears with the external sign-in site (either MicroStrategyLibrary or OIDC provider).

      2. Follow the required steps to authenticate with the chosen method.

      3. After the popup closes, select Connect.

9. Choose the report or cube you want to import to Power BI by navigating through the Navigation Table.

Additional information

Refresh data using Power BI Online

Note

The scheduled refresh functionality isn't available for Library authentication.

To refresh MicroStrategy data using Power BI Online:

1. Publish the semantic model imported with Power BI Desktop using the MicroStrategy for Power BI connector.

2. Open the Settings page for the published semantic model.

3. If you're connecting to this database for the first time, select the authentication type and enter your credentials.

4. If necessary, select the name of your on-premises data gateway.

Now follow the steps required to set up the scheduled refresh/refresh in Power BI Online.