Configure Retail Insights dashboard in Store operations Admin

After you deploy the Power BI package, you must perform the following setup steps to ensure that you can view data analytics in the Retail Insights dashboard.

Install Power BI Template Apps

To install the Retail Insights dashboard in Store operations Admin, you need to install the following Power BI template apps. Sign in into Microsoft Appsource, search for, and install the following template apps.

For more information on how to install Template apps, see Install, share, and update template apps in your organization.

Configure in Power BI

To configure the Retail Insights dashboard in Store operations Admin, you need to perform the following steps:

  1. Sign in to Power BI with your Power BI user license.

  2. Select your workspace (which gets created when you install Template App) and perform the setup steps detailed in the following sections:

  3. After you complete these four setups, navigate to Store operations Admin > Retail Insights and verify if you're able to see the Retail Insights dashboard details.

Set up data source path and parameters

You need to ensure that the data from the appropriate source ingest into the Retail Insights dashboard.

  1. Select the three dots next to dataset and navigate to Settings.

  2. Go to Parameters section and update the details of DomainName, AppId, RangeStart, RangeEnd, and Load data for last N days.

    Note

    To find your AppID, navigate to Store operations. You can get the AppID from your browser URL. The AppID is the GUID after the /apps/ in the URL.

    Screenshot shows the datasource parameters settings.

  3. Next, go to Data source credentials section, select Edit credentials and sign in using your credentials.

    Screenshot shows the data source credentials settings.

  4. Now navigate back to your workspace and refresh the Semantic model.

    Screenshot shows how to refresh the semantic model.

Set up scheduled refresh

You need to set up a scheduled refresh to ensure that data gets refreshed regularly across all reports under the Retail Insights dashboard.

  1. Select the three dots next to dataset and navigate to Settings.

  2. Expand Refresh and toggle the configuration flag to On.

  3. Set the Refresh frequency and select the appropriate time zone and time.

    Note

    With a premium license, dataset can be refreshed eight times, hence you can configure eight time slots.

  4. Add required users to get Refresh failure notifications and select Apply to finish the setup.

    Screenshot shows the scheduled refresh configuration.

Set up security roles

You need to set up security roles to ensure that users can access the reports and view data based on their roles.

  1. Select the three dots next to dataset and navigate to Security.

  2. Add all the required users to the Manager role as per the access granted in Dataverse and select Save.

Screenshot shows the security roles settings.

Set up report access

You need to give report access to required users.

  1. Select Share next to report.

  2. Add all individual users and select Send.

    Screenshot shows how to share the report.

Configuration in Power Apps maker portal

To configure the Retail Insights dashboard in Store operations Admin, you need to update the environment variable values with the newly created report values.

  1. Open workspace and open Retail Insights report. Copy the Retail Insights report url, which is present on the browser address bar. The url contains the group ID and report ID. For example, https://app.powerbi.com/groups/1aaaaaa1-2bb2-3cc3-4dd4-5eeeeeeeeee5/reports/6ffffff6-7aa7-8bb8-9cc9-0dddddddddd0/ReportSection?experience=power-bi

  2. Now open the Power Apps maker portal and navigate to your environment.

  3. Open the default solution and update the environment variable values for Retail insights with the newly created report's values as shown in the following example.

    {"group":{"ID":"1aaaaaa1-2bb2-3cc3-4dd4-5eeeeeeeeee5","name":"Retail Store operations insights"},"component":{"ID":"6ffffff6-7aa7-8bb8-9cc9-0dddddddddd0","name":"Retail summary store ops","type":"Report","embedUrl":"https://app.powerbi.com/reportEmbed"}}

    Screenshot shows the environment variable settings.

  4. Open Store operations Admin and check that the Retail insights page under Advanced analytics is loading with correct data.

    Screenshot shows the Retail insights page in Store operations Admin.

  5. Repeat the same process to see the Survey response summary report values.

    Screenshot shows Survey response summary page in Store operations Admin.