Version 2021

Configure Scheduled Refresh for MicroStrategy for Power BI with Power BI Gateway

With the Microsoft Power BI Gateway, you can schedule the refresh of data from MicroStrategy into Power BI.

Configure the Power BI Gateway Server

  1. Run the Power BI gateway configuration app.
  2. From the left pane, go the Connectors tab.
  3. Confirm that the path to the gateways' connectors directory in the Load custom data connectors from folder field exists. A list of loaded custom connectors is available.
  4. If the custom connectors directory does not exist, create it.
  5. Drop the MicroStrategy for Power BI connector file into the custom connectors directory. The MicroStrategy for Power BI connector appears in the list of currently loaded custom connectors.
  6. To restart the gateway, go to the Service Settings tab.
  7. Click Restart Now.

Configure a Gateway Data Source in the Power BI Web App

For the on-premises data gatweway, you must create a data source for your custom connector.

  1. Open Power BI on the web.
  2. In the top right corner, click Settings > Manage gateways.

  3. In the Gateway Clusters Settings tab, select the Allow user's cloud data sources to refresh through this gateway cluster. These cloud data sources do not need to be configured under this gateway cluster and Allow user's custom data connectors to refresh through this gateway cluster (preview) checkboxes.

  4. Click Apply.
  5. In the Gateway Clusters pane, hover over your gateway cluster.

  6. Click Open menu > Add Data Source.

  7. In the Data Source Name field, enter a name for the data source.
  8. From the Data Source Type drop-down, choose MicroStrategy for Power BI.
  9. Input the MicroStrategy Library URL and appropriate credentials.

  10. Click Add.

Map a Dataset to the Gateway Data Source

  1. Open Power BI on the web.
  2. In the left pane, hover over your dataset.
  3. Click Open menu > Settings.
  4. In the Datasets tab, click Gateway connection.

  5. Click the Use a data gateway toggle to enable the setting
  6. Select your configured gateway.
  7. Click Apply.