Deploy Retail industry data model (preview)

Important

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

The Retail industry data model is a key capability of the Retail data solutions in Azure Synapse. It helps you standardize your data from different retail applications and store it in a common format. You can then use it to generate insights that help you drive timely actions.

Prerequisites

  • You need the Fabric Administrator (Workspace Contributor) permission.

  • You should have enabled Retail Data solutions.

  • You should have created a workspace with Retail data solutions deployed. Dataset generation requires a personal workspace (not My workspace) configured with a license with Premium or Fabric capacity and XMLA endpoint to be enabled with Write permission in Admin portal.

Configure Admin portal settings to deploy Retail industry data model

  1. In a new Incognito or InPrivate browsing session, sign in to your Microsoft Power BI home page with your Fabric Administrator credentials.

  2. From the lower left, select the Power BI icon and then select Industry Solutions from the list.

    Screenshot of Power BI with the Power BI icon selected and Industry Solutions highlighted.

  3. Select Settings > Admin portal.

    Screenshot of the Settings icon selected and Admin portal highlighted on the Settings pane.

  4. In Tenant settings, in the Filter by keyword field, search for XMLA.

    Screenshot of Microsoft Fabric on the Admin portal with Tenant settings selected and XMLA entered in the search box.

  5. Under Integration settings, make sure that Allow XMLA endpoints and Analyze in Excel with on-premises semantic models is set as Enabled. If not, turn on the setting and then select Apply.

    Screenshot of Integration settings in the Admin portal with Allow XMLA endpoints set to Enabled with the Apply button highlighted.

  6. In the Admin portal, select Capacity settings > Trial and then select your capacity name.

    Screenshot of the Admin portal on the Capacity settings page with the Trial tab selected and the capacity name highlighted.

  7. Expand Power BI workloads. Under XMLA Endpoint, change the permissions to Read Write and then select Apply.

    Screenshot of XMLA Endpoint with the permissions set to Read Write.

  8. On the Update your capacity workloads pop-up window, select Yes to continue.

    Screenshot of the Update your capacity workloads pop-up window with the Yes button highlighted.

Deploy the Retail industry data model

To deploy the Retail industry data model, follow these steps:

  1. Go to the Retail solution homepage, where you can see the list of capabilities as tiles.

  2. Select Retail industry data model from the list of solution capabilities. You see the application details page, where you can view detailed information about the capability.

    Screenshot shows the homepage of the Retail industry data model.

  3. Select Deploy to workspace. This step initiates the deployment process for deploying the Retail industry data model in your tenant.

    Screenshot shows the Deploy to workspace button.

  4. Select the workspace where you want to deploy the Retail industry data model. You can select an existing Lakehouse or create a new Lakehouse. Select Next.

    Screenshot shows the Select workspace page.

  5. You can now select the entities that you want to deploy from the Retail industry data model. You can select one or more specific entities or all entities in a business area or multiple business areas that you want to configure. For example, if you would like to deploy all the entities related to Budgeting and Forecasting, you can select this business group and configure all the entities related to that business area. If you want to select only a few entities from each of the business areas, you can also do the same by individually selecting the entities from various business areas. Select Next.

    Screenshot shows the Select entities page.

  6. You can now review the selected list of entities chosen in the previous screen. Select Deploy.

    Screenshot shows the Review entities page.

  7. The selected entities are deployed in your tenant. If there's any error in deploying the entities in the customer tenant of Fabric, an appropriate error message is displayed, and you can take necessary action to fix the same. If the deployment is successful, you see a success message. Select Return to Retail solution to go back to the Retail solution homepage.

    Screenshot shows the success message.

  8. You can now verify that a new instance of Retail industry data model is displayed in the list of capabilities under Manage deployed capabilities. Select Retail industry data model.

  9. You can view the details of the artifacts that are installed as part of the Retail industry data model solution. You also see some key metrics like modified by, last updated date, etc.

    Screenshot shows the list of artifacts deployed with Retail industry data model solution.

You can select any of the deployed artifacts from the deployed solution to open the artifact within the Fabric UI.