Enable Power Platform Integration: Set up D365FO integration with Dataverse

 

Set up D365FO integration with Dataverse

 This document shows how to set up D365FO integration with Dataverse.

Create a security role

1. Sign in to the Power Platform admin centre and select an environment.

2. Select Settings > Users + permissions > Security roles.

3. Select + New role.

4. Enter a role name.
5. Select a business unit.
6. To allow team members to inherit the privileges of this role when it's assigned to a team, accept the default Member's privilege inheritance setting, which is Direct User (Basic) access level and Team privileges.
7. Select Save. The properties of the new role are displayed.

8. Enter your table name in the Search input field to find your app's table.

9. Select your table and set the Permission settings. Then select the Save button.
10. Assigning new role to user
1. Select user and click 3 dots.

2.      Select Manage security roles.

3.      Select newly created role and save.

Azure Hosted pipeline - Update Artifacts (NuGet) for version update

 Step-by-Step Guide to Updating or Creating Artifacts for a Hosted Pipeline

In this blog, we’ll walk you through the process of updating or creating artifacts for a hosted pipeline. Follow these steps carefully to ensure a seamless setup and deployment experience.

Step 1: Import NuGet Packages from LCS

1. Log in to Lifecycle Services (LCS) and locate the NuGet package files for the required Dynamics version.
2. Make sure to select only the PUxx version of the packages.
3. Download the NuGet package files to the following directory
4. C:\temp

 (Import the NuGet packages files from LCS for that particular version.(Pick only PU version) )

Step 2: Configure DevOps Artifacts

1. Navigate to DevOps Artifacts in your Azure DevOps project.
2. If you are updating an existing feed, click on Connect to Feed.
   • For creating a new feed, click on + Create Feed and configure it.
3. Select NuGet.exe as the tool and download the executable file to

4. Click on NuGet.exe and Get the tool and download the exe file to C:\Temp folder

Step 3: Prepare the Scripts

To proceed, you’ll need two scripts. Before running these, adjust the file paths, feed names, and credentials as necessary.

Script 1: Add the Feed Source

Replace the placeholders with the appropriate values:

C:\Temp\NuGet\nuget.exe sources Add -Name "PU42" -Source "https://pkgs.dev.azure.com/<ProjectName>/D365FO/_packaging/PU42/nuget/v3/index.json" -Username "<YourUsername>" -Password "<YourAccessToken>"

Ex:

C:\Temp\NuGet\nuget.exe sources add `

  -Name "PU70" `

  -Source "https://pkgs.dev.azure.com/myproject/73b7fb8-e15-4cc0-8f17-99c48d7532/_packaging/PU70/nuget/v3/index.json" `

  -Username "AzureDevOps" `

  -Password "<YOUR_PAT>" `

  -StorePasswordInClearText

Name: Feed name (e.g., PU42).[Azure DevOps-->Artifacts]

Source: The feed URL from DevOps: 

Azure DevOps → Artifacts → Feed → Connect to Feed → NuGet.exe

Username: Access key username (e.g., your DevOps username).

Password: Access key token (generate or use an existing token from DevOps).

Script 2: Push NuGet Packages

Update the script with the feed URL, username, and local file paths:

Script 2:

$NugetExe = "C:\Temp\NuGet\PU70\nuget.exe"

$FeedName = "PU_70"

$FeedUrl  = "https://pkgs.dev.azure.com/myproject/73b7fb8-e15-4cc0-8f17-99c48d7532/_packaging/PU70/nuget/v3/index.json"

$PAT = "<YOUR_PAT>" `

---------------

# Add source

& $NugetExe sources add `

  -Name $FeedName `

  -Source $FeedUrl `

  -Username "AzureDevOps" `

  -Password $PAT `

  -StorePasswordInClearText

# Push package

& $NugetExe push `

  "C:\Temp\NuGet\PU70\Microsoft.Dynamics.AX.ApplicationSuite.DevALM.BuildXpp.nupkg" `

  -Source $FeedName `

  -ApiKey az `

  -Timeout 300

  

# Push package

& $NugetExe push `

  "C:\Temp\NuGet\PU70\Microsoft.Dynamics.AX.Application1.DevALM.BuildXpp.nupkg" `

  -Source $FeedName `

  -ApiKey az `

  -Timeout 300

  # Push package

& $NugetExe push `

  "C:\Temp\NuGet\PU70\Microsoft.Dynamics.AX.Application2.DevALM.BuildXpp.nupkg" `

  -Source $FeedName `

  -ApiKey az `

  -Timeout 300

    # Push package

& $NugetExe push `

  "C:\Temp\NuGet\PU70\Microsoft.Dynamics.AX.Platform.DevALM.BuildXpp.nupkg" `

  -Source $FeedName `

  -ApiKey az `

  -Timeout 300

      # Push package

& $NugetExe push `

  "C:\Temp\NuGet\PU70\Microsoft.Dynamics.AX.Platform.CompilerPackage.nupkg" `

  -Source $FeedName `

  -ApiKey az `

  -Timeout 300

   

Key Notes:

• Replace <YourAccessToken> with your DevOps-generated token.
• Ensure all NuGet package file paths match the downloaded files in C:\Temp\NuGet.

   ---------------------------------------------------------------------------------------------------------------

Step 4: Update Artifacts in TFS

1. After executing the above scripts, verify that the artifacts have been successfully updated in your feed.
2. Copy the updated artifact version.
3. Update the version details in TFS to reflect the changes.

Conclusion

Following these steps ensures your artifacts are updated or created in a hosted pipeline with proper configurations. Always ensure you are using the correct credentials, feed names, and paths to avoid errors during deployment.

Feel free to leave any questions or feedback in the comments!