Configure Power BI and Eventstream

Important

Some or all of this functionality is available as part of a preview release. The content and the functionality are subject to change.

After you successfully deployed Retail data solutions and Sitecore OrderCloud connector, you can configure the various features available in the solution capability.

Configure authentication for data ingestion to Power BI

You need to configure Power BI to ensure that data is refreshed in Power BI reports periodically for view.

  1. Open the deployed artifacts page and select the Dataset Semantic Model artifact.

  2. The Dataset page opens and the items used in the Dataset artifact is listed. Select File > Settings.

    Screenshot shows the settings page for the OrderCloud connector.

  3. The settings page for the OrderCloud connector opens. Under Data source credentials, select Edit credentials. Enter authentication method as OAuth2 and select Sign in. This step refreshes the data for your Power BI report and you can see the sample data in the Power BI dashboard.

    Screenshot shows the credentials page for the OrderCloud connector.

Configure data ingestion from OrderCloud to Fabric

To configure data ingestion from OrderCloud to Fabric, perform the steps in the following sections:

Configure Eventstream

To manually configure Eventstream and set up the Orders, Products, and Webhooks entities, perform the following steps:

  1. Go back to the deployed artifacts page and select the OrderSync Eventstream. Select Create a new Eventstream artifact in Microsoft Fabric.

  2. Create a new OrderCloud source in your Eventstream artifact and select Custom App as the source type.

    Screenshot shows the OrderCloud source in Eventstream.

  3. Create a new Lakehouse destination in your Eventstream artifact. Select the workspace, Lakehouse, and the Delta table you want as the destination. Leave the input data format as Json.

    Screenshot shows the OrderCloud destination in Eventstream.

Set up Delivery Configuration in OrderCloud

  1. Select the OrderCloud source in your Eventstream artifact, then select Keys in the navigation bar.

  2. Copy the Entity name and Connection string-primary key values, you need these values in a forthcoming step.

  3. Open your OrderCloud workspace and navigate to the API Console.

  4. Select the Delivery Configurations options in the left navigation bar.

  5. Change the operation to POST Create a new delivery configuration to create a new delivery configuration item.

  6. Enter the values for the following properties:

    • ID (optional, if this field is empty, a GUID is generated for you)
    • Name
    • Check the Enabled checkbox
    • Delivery Targets
    • Event Hub Name (this value is the Entity name value from the Eventstream source)
    • Connection String (this value is the Connection string-primary key value from the Eventstream source)
  7. Copy the DeliveryConfig ID since you need this value in a forthcoming step. At this point, you need to set up an Event synchronization and Webhook synchronization. The steps for each are outlined in the following sections.

Configure Event Synchronization in OrderCloud

Note

This step is only applicable to the Orders and Products entities coming from OrderCloud. Other entities will require different steps to configure and set-up.

  1. In the OrderCloud API Console, select the Order Synchronization option in the left navigation bar. Change the operation to PUT Create or update an order sync to create a new order synchronization item.

  2. Enter the Delivery Config ID created in a previous step.

  3. In the OrderCloud API Console, select the Product Synchronization option in the left navigation bar. Change the operation to PUT Create or update a product sync to create a new product synchronization item.

  4. Select both the Sync Product Changed and Sync Product Deleted checkboxes.

  5. Enter the Delivery Config ID created in a previous step. Select Sync for one-time upload of existing data.

Important

For detailed support, contact the Microsoft Cloud for Retail team at mcfrcommunity@microsoft.com.