Exercise - Set up the Retail Insights dashboard

  • 3 minutes

After deploying the Power BI package, you continue to play the role of Oscar, the IT administrator for Contoso Retail, and set up the dashboard.

Task: Set up the data source path

To enable the data to be ingested into the Retail Insights dashboard and be made available to the Store operations, perform the following steps:

  1. Go to Power BI in an InPrivate or Incognito browser session by using the credentials for this exercise.

  2. Select the ellipsis (...) next to the data set and then go to Settings.

    Screenshot of Power BI Solutions with focus on Retail summary store ops and the ellipsis menu selected with focus on the Settings option.

  3. Go to Data source credentials and then select Edit Credentials.

  4. Check for the correct extensionDataSourcePath, which should be set to https://contosoretailgrocery.crm.dynamics.com/, for example. Select Sign in with the same Power BI licensed user credentials.

  5. Select the managed workspace, and then after successful sign-in, select the Refresh button to refresh the data set.

Task: Schedule the refresh frequency for the Retail Insights dashboard

To set up a scheduled refresh to ensure that the data is refreshed regularly across all reports in the Retail Insights dashboard, perform the following steps:

  1. Select the ellipsis (...) menu next to the data set and then select Settings.

  2. Expand Refresh and then turn On the configuration flag. Set the Refresh frequency and then select the appropriate time zone and time.

    Note

    With a Power BI Premium license, you can refresh the data set eight times; hence, you can set up eight time slots.

  3. Add the required users' email addresses to get refresh failure notifications and then select Apply to finish the setup.

Task: Set up security roles for reports

To ensure that users can access the reports and view data based on their roles, perform the following steps:

  1. Select the ellipsis (...) menu next to the data set and then select Security.

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

    Note

    Add the manager user account that you're using for this exercise.

Task: Set up report access

To set up the report access for users to access the Retail Insights dashboard, perform the following steps:

  1. Select Share next to the data set.

    Screenshot of Power BI with focus on the Share button.

  2. Add all individual users and then select Send.

    Note

    Add the user account of the store manager/district manager to view the Retail Insights report.