Edit

Share via

Set up your SAP BW Message Server connection

This article outlines the steps to create an SAP BW Message Server connection.

Supported authentication types

The SAP BW Message Server connector supports the following authentication types for copy and Dataflow Gen2 respectively.

Authentication type Copy Dataflow Gen2
Basic (Username/Password) n/a √
Windows n/a √

Set up your connection for Dataflow Gen2

You can connect Dataflow Gen2 in Microsoft Fabric to SAP BW Message Server using Power Query connectors. Follow these steps to create your connection:

  1. Check capabilities to make sure your scenario is supported.
  2. Complete prerequisites for SAP BW Message Server.
  3. Get data in Fabric.
  4. Connect to an SAP BW Message Server.

Capabilities

  • Import
  • Direct Query (Power BI semantic models)
  • Advanced
    • Language code
    • Execution mode
    • Batch size
    • MDX statement
    • Enable characteristic structures

Prerequisites

Important

Version 1.0 of the SAP BW Message Server connector has been deprecated. New connections will use Implementation 2.0 of the SAP BW Message Server connector. All support for version 1.0 will be removed from the connector in the near future.

You'll need an SAP account to sign in to the website and download the drivers. If you're unsure, contact the SAP administrator in your organization.

To use the SAP BW Message Server connector in Power BI Desktop or Power Query Online, you must install the SAP .NET Connector 3.0 or 3.1. Access to the download requires a valid S-user. Contact your SAP Basis team to get the SAP .NET Connector 3.0 or 3.1. You can download the SAP .NET Connector 3.0 or 3.1 from SAP. The connector comes in 32-bit and 64-bit versions. Choose the version that matches your Power BI Desktop installation. For Power Query Online, choose the 64-bit version.

When you install, in Optional setup steps, make sure you select Install assemblies to GAC.

Select to install assemblies to GAC.

Note

As of late 2023, the SAP BW Application Server connector contains support for SAP .NET Connector 3.1.

Get data

To get data in Data Factory:

  1. On the left side of Data Factory, select Workspaces.

  2. From your Data Factory workspace, select New > Dataflow Gen2 to create a new dataflow.

    Screenshot showing the workspace where you choose to create a new dataflow.

  3. In Power Query, either select Get data in the ribbon or select Get data from another source in the current view.

    Screenshot showing the Power Query workspace with the Get data option emphasized.

  4. In the Choose data source page, use Search to search for the name of the connector, or select View more on the right hand side the connector to see a list of all the connectors available in Power BI service.

    Screenshot of the Data Factory Choose data source page with the search box and the view more selection emphasized.

  5. If you choose to view more connectors, you can still use Search to search for the name of the connector, or choose a category to see a list of connectors associated with that category.

    Screenshot of the Data Factory Choose data source page displayed after selecting view more, with the list of connectors.

Connect to an SAP BW Message Server

To connect to an SAP BW Message Server from Power Query Online:

  1. From the Data sources page, select SAP BW Message Server.

  2. Enter the server, system number, client ID, and logo group of the SAP BW Message Server you want to connect to. This example uses SAPBWTestServer as the server name, a system number of 100, a client ID of 837, and a log-on group of PURCHASING.

  3. Select the on-premises data gateway you want to use to connect to the data.

  4. Set Authentication Kind to Basic. Enter your user name and password.

    SAP BW Message Server online sign-in.

  5. You can also select from a set of advanced options to fine-tune your query.

  6. Select Next to connect.

  7. From the Navigator dialog box, select the items you want to use. When you select one or more items from the server, the Navigator dialog box creates a preview of the output table. For more information about navigating the SAP BW Message Server query objects in Power Query, go to Navigate the query objects.

  8. From the Navigator dialog box, you can transform the data in the Power Query Editor by selecting Transform Data.

    SAP BW Message Server Navigator view from Power Query Online.

Set up your connection in a pipeline

Data Factory in Microsoft Fabric doesn't currently support an SAP BW Message Server in pipelines.

Related content

  • Last updated on