Microsoft Fabric Dataflow Gen2 in Power BI Service with Xtract Universal

This article shows how to use Xtract Universal with Dataflow Gen2 in Power BI Service. For more information on Dataflow Gen2, see Microsoft Documentation: What is Dataflow Gen2?

Prerequisites

The scenario described in this article requires:

• An on-premises data gateway connection between Power BI Service and Xtract Universal, see Connect to Power BI Service.
• Extractions in Xtract Universal that use the Power BI Destination.
• A Microsoft Fabric subscription.

Step-by-Step Instructions

To use Xtract Universal with Dataflow Gen2 in Power BI Service:

1. Navigate to My Workspace > New Item > Dataflow Gen2.
2. Create a new Power BI report using Home > Get Data > Blank Query as a data source.
   
3. Open the [Advanced Editor].
   
4. Copy the content of the loading_script.txt file into the editor.
   

5. Change the values for ExtractionName and ServerURL to match the name of your Xtract Universal extraction name and server URL.

   let
       ExtractionName = "mara",
       ServerUrl = "http://localhost:8065",
   
       // Record containing run parameters with corresponding values, can be empty
       // Usage: <XU parameter name>= <value or Power BI parameter>
       // MUST NOT use "name" as a record field here
       Parameters = [ /*rows= "300", myparameter= SomePowerBIParameter*/ ],
   

6. Select the appropriate data gateway from the drop-down-list.
   

7. Click [Next].
   

Your SAP data is now available for further processing.

Related Topics

• Knowledge Base Article: Connect to Power BI Service
• Documentation: Power BI Connector
• Microsoft Documentation: What is Dataflow Gen2?
• Microsoft Fabric - Creating Dataflows