Prerequisites to use resource recommendations (preview)

Applies To: Project Operations Integrated with ERP, Project Operations Core.

Enable the resource recommendations feature

To enable resource recommendations, follow these steps:

1. Sign in to Microsoft Dynamics 365 Project Operations.
2. Ensure that you're using Project Operations version 4.91.0.X or later. The resource recommendations feature is available only in these versions. Project Operations version 4.103.0.X or later provides multi-factor recommendations. Versions before 4.91.0.X provide recommendations that are based on only one factor (Relevant past experience).
3. On the left navigation, change the area to Settings.
4. In the General section, select Parameters.
5. A list of organization units appears. Double-tap (or double-click) the Organization Units row for the columns that aren't links.
6. On the Project Parameters page, in the Feature Control field, select Feature Control.
7. Select Enable Resource Recommendation Engine Feature, and then select OK.

After you complete this procedure, activate four dataflows as described in the next section.

Have your system administrator activate dataflows

After you enable the resource recommendations feature, your system administrator must activate four dataflows. Ensure that this system administrator has Global Administrator rights. Complete this mandatory, one-time step for every new environment where you enable the feature. The four dataflows prepare the data infrastructure required to generate optimal recommendations for any new project team member.

To activate the dataflows, have your system administrator follow these steps:

1. Sign in to your Project Operations environment as System Administrator.

2. Open a new tab in the same browser window, and sign in to the Power Apps portal as System Administrator. For more information about the Power Apps portal, see Sign in to Power Apps.

3. In the Environments section in the upper right, ensure that the environment that you're signed in to is selected.

   To view the environment name, go to your environment, select the profile symbol, and copy the environment name from the upper left of the dialog box that appears.

4. On the left navigation pane, select Dataflows. If this option isn't directly visible, select More, and then select Dataflows.

5. Select the My Dataflows tab. This tab lists the following dataflows (in addition to any pre-existing items):

   • 1. Resource Recommendation - Daily KPE
   • 2. Resource Recommendation - Weekly Scoring Indexing
   • 3. Resource Recommendation - Weekly Add Time Summary
   • 4. Resource Recommendation - Weekly Update Time Summary

6. If no Dataflows are visible in My Dataflows or All Dataflows, refer to the Handling miss Dataflows section of this article.

Handling missing Dataflows

If you don't see any Dataflows in My Dataflows or All Dataflows, the problem might be that a different global system administrator account owns the Dataflow. To check who owns the Dataflow, follow these steps:

1. On the left navigation pane, select Solutions.

2. Set the filter to All and select the solution with Display Name as Project Operations (Name must be ProjectService).

3. Select Dataflows from the list of Objects on the left. You see a list of all Dataflows.

4. Find the Owner for the Dataflows you need in this feature.

5. If the owner isn't a System User, go back to Home and select Dataflows from the left navigation pane.

   Important

   You can't change ownership of these Dataflows when the current owner is a system user that provisioned the automated update of Project Operations. In this case, submit a support ticket to get immediate assistance.

6. Go to All Dataflows and search for the name of the Owner you found in the previous step.

7. Select the owner from the list that appears to make all four dataflows visible.

8. Select the overflow symbol (three dots) for each Dataflow and select Change Owner. Select your own account as the new owner and confirm.

9. When you complete these steps for all four dataflows, you see them in My Dataflows and you can continue to activate each one of them.

Activate a dataflow

1. Start with the first dataflow, 1. Resource Recommendation - Daily KPE. Select the overflow symbol (three dots), and then select Edit. You're taken to a Power Query page that shows details of the selected dataflow.

2. Select the EnvironmentName parameter. Then, in the space provided for Current Value, replace the placeholder text ({{envName}}) with the URL of the environment you're using, without the "https://" (for example, enter recommend.crm.dynamics.com).

3. In the Queries pane, select the first item after EnvironmentName and Name. This item must have a warning symbol (exclamation point) next to it. For the first dataflow, this item is msdyn_projecttask.

4. You receive the following error message: "Credentials are required to connect to the CommonDataService source." Select Configure Connection.

5. If you're following these steps for the first time, a Connect to data source dialog box appears. In this dialog box, the Connection field is set to Create a new connection, the Connection Source field is set to the name of your environment, and the Authentication Kind field is set to Organizational account. (The following image shows an example.) Select Sign in, and enter your System Administrator user credentials again. Then, after sign-in is completed, select Connect. If you receive any error messages, select Refresh on the toolbar.

   

   If you're not following these steps for the first time, no dialog box appears, and you can select Connect directly.

6. Select Next. The page that appears has a Publish button. This button might take up to two minutes to become available.

   

7. Select Publish. You're redirected back to the Dataflows page.

8. Repeat steps 1 through 7 for the remaining dataflows, in order of their numerical prefix.

Complete the prerequisites

When every dataflow has a green check mark in its Last refresh column, all prerequisites are ready to use this feature. (The following image shows an example.)

Depending on the number of projects and tasks in your environment, it might take up to 24 hours for all dataflows to complete their refresh.

If any dataflows fail to refresh, submit a support ticket to get help.

For more information about how to use the feature, see Get recommendations for a project team member.