How to connect cloud hosted environment with Data verse / Power Platform

Hello Everyone, 

By this time (now) I hope you have started using Power Platform admin center (PPAC) in your D365FO projects. A lot of new features can be enabled via Data verse on your tier-2 onwards environments. by what about our beloved dev box(es). 

Well, there are architectural difference between could hosted environments which are tier-1 , one box environment and Sandbox/Production environments which are tier-2 on wards and multi box environments. And because of this difference  Power Platform Integration cannot be configured after creating the developer environment, unlike sandbox/Production where you can enable it from LCS even after deployment. 

BUT question remain same, how to access Power platform /Data verse on my Dev box, the simple and the only answer (at the moment) is , you need to redeploy the environment and during process you need to enable Power Platform environment. 

Here are detailed steps, 

1. Navigate to LCS portal and select your project. 

2. Go to Could hosted environment. 

3. Add a new environment, and give a meaningful name. 

4. Click on Advance > Navigate to Power Platform Integration and select values as shown in below image, 

-

5. Once all detailed filled, click on Next and system will start the deployment (it may stay in Queued for some time but that's fine). 

6. On successful deployment, you will be able to have option for 'Setup Dual write application' on environment page in LCS.

7. When you click on 'Setup Dual-write Application', system will take you though wizard where you can review and procced. 

this will initiate 'Configuring Dual-write application' and may about 30 min of time. 

8. Once this step is finished, oyu will get an option to 'Enable Dual-write Connection'. So you may ask what was the previous step, will that step was to configure Dual write and this step is to enable Dual write. 

This step will link both environments. 

Note: This setup needs to be performed by the Lifecycle Services Environment Administrator.

Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

QuickFix: Issue with CAR report generation (The source for referenced module '####' is missing from the model store. Please specify the -packagesRoot parameter to instead use binary metadata for referenced modules.)

Hi Everyone, 

We have multiple ISVs and as per MS documentation I added additional parameter in cmd but While generating CAR report I got error for ISV references. 

I tried to remove reference to one ISV than next time it started giving error for another ISV. Here is the cmd I tried, 

xppbp.exe -metadata='K:\AosService\PackagesLocalDirectory' -all -model='MyModel' -xmlLog=C:\CARreport\BPCheckLogcd.xml -module='MyModel' -car='c:\CARreport\CAReport.xlsx'-packagesroot=K:\AosService\PackagesLocalDirectory


Issue and Solution: 
The issue was I used the cmd car parameter path in quotations. 

xppbp.exe -metadata='K:\AosService\PackagesLocalDirectory' -all -model='MyModel' -xmlLog=C:\CARreport\BPCheckLogcd.xml -module='MyModel' -car='c:\CARreport\CAReport.xlsx'-packagesroot=K:\AosService\PackagesLocalDirectory

The correct cmd should be as below

xppbp.exe -metadata='K:\AosService\PackagesLocalDirectory' -all -model='MyModel' -xmlLog=C:\CARreport\BPCheckLogcd.xml -module='MyModel' -car=c:\CARreport\CAReport.xlsx -packagesroot=K:\AosService\PackagesLocalDirectory

Don't miss the space after .xlsx

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

[Solved] The container will need to be recreated with the new table metadata in order to be unpacked correctly.

I got below error in development instance. 

Error message: 

A container for table (SalesTable) was packed with more fields than are currently defined on the table and cannot be safely unpacked. The container will need to be recreated with the new table metadata in order to be unpacked correctly.

Possible solutions:

Option 1: Reset uses data.

Navigate to user option and reset the usages data, I would prefer if its Dev instance you do reset for all users or just for current user. 

Option 2: Try t build your custom models and DB synch. 

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

How to Install 'Globalization Solution for Microsoft Dynamics 365 Finance' for ER reporting

Hi Folks, 

I recently been working on ER reporting was referring Microsoft documentations for Electronic reporting (ER) overview , the detaisl inthsi document have some conditions (as of today July 11, 2024) which is not clearly mentioend in this document that the repository mentieodn are only applicate till version 10.0.38, from this version onwards thigs changed (Yes changed again!!!)

In this post I will explain how to setup ER reporting for your environment. 

Thigs to note before start:

1. Admin access to Admin center of power platform

2. Admin access to D365FO

3. LCS and Operations resources are not supported any more, Regulatory Configuration Service (RCS) will be deprecated as well

4. New Solution will be deployed on Dataverse

5. This works only with Tier 2 instances 

Worth the know: 

1. If you check your ER reporting work space (with version 10.0.30 and above) you will only get two options in 'Configuration repository' which are

i. Dataverse

ii.  Operation resource

and if you try to setup data verse and open it, you may get below error,  Error when opening Data version in ER repository, 

Request to Dataverse failed. Check that solution is installed and application user has access to Dataverse tables. Error code: d02c0bcd Timestamp: 2024-07-04 13:20:10 Correlation Id: <####> Exception thrown: System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: RetrievePrivilegeForUser: The user with id <####> has not been assigned any roles. They need a role with the prvReadmsdyn_ElectronicReportingConfigurationsIndexFile privilege. (Fault Detail is equal to Exception details: ErrorCode: 0x80042F09 Message: RetrievePrivilegeForUser: The user with id <###> has not been assigned any roles. They need a role with the prvReadmsdyn_ElectronicReportingConfigurationsIndexFile privilege. TimeStamp: 2024-07-04T13:20:10.5918579Z -- Exception details: ErrorCode: 0x80042F09 Message: RetrievePrivilegeForUser: The user with id <###> has not been assigned any roles. They need a role with the prvReadmsdyn_ElectronicReportingConfigurationsIndexFile privilege. TimeStamp: 2024-07-04T13:20:10.5918579Z -- ).

2. If you have already setup some other repositores in past version and than updated your environment, you still be able to see and access these repository. But you wont be able to create new repository on same type. 

Now coming to solution: 

1. Navigate to Microsoft app source and search for  Globalization Solution for Microsoft Dynamics 365 Finance or click here

2. Click on 'Get it now', it will nevugatre you to https://admin.powerplatform.microsoft.com/ portal where you need to select further details. In select environment option you can only selelct a sanbox or productoin ( no tier 1 option by default)

(Note: To install an app, you must have a successfully provisioned environment in the region where the application is available and the environment must have a database connection)

3. After the installation you will be able to see this under solution tab, check if there are update on this solution , 

I would recommend to udpate this to latest version, 

Once these steps finished successfully , go back to your environment and select data verse and click on Open. 

You should be able to see all reporting configuration and choose what you need and import to use. 

Further references

1. Globalization Studio overview

2. Manage Dynamics 365 apps

3. Download ER configurations from the Global repository of Configuration service

Happy ER reporting, and may your data flow smoothly!