Skip to main content

Posts

Showing posts from 2020

Dualwrite tips and tricks

Development Guide Dual Write   Prerequisites  Finance and Operations apps that have build version 10.0.9 (10.0.383.20013) (Quality update) and platform update 33 or later Model-driven apps in Microsoft Dynamics 365 that have platform version 9.1.0000.11732 or later Entity Creation I’m assuming that you have already setup and configured Dual-Write in your D365 FO and Dataverse (CDS) environments. Furthermore, required entities are already created in FO and Dataverse (CDS) applications and fields are also added as per the following data type mappings. MS D365 FO Field Type MS Dataverse Field Type String Text String (Memo) Text (Multiline) Base Enum Choices Boolean Yes/No Integer / Real Decimal Date Date Only Date Time Date and Time Create Integration Key It is very important to properly create and configure table key in MS Dataverse as per F&O entity key to avoid below error during mapping. Mapping is missing for integration key - Requisition Number Following are the steps to cre

Deployment failed for file for PowerBI Tier2 Environment Dynamics 365 Finance and Operations

There is a requirement in a client to create a custom report of PowerBI and embed it in Dynamics 365 Finance and Operations. So, I started searching on google and found 3 ways to connect PowerBI with Dynamics 365 Finance and Operation. OData (Direct call data entity) Azure DB (Export from BYOD) Entity Store (Create Measure to direct query from D365 Finance and Operations) So, I saw Microsoft is using Entity Store to connect their standard (OOB) PowerBI report with D365 Finance and Operations. I have created a new PowerBI app registration in dev instance and configure in Dynamics 365 Finance and Operations. then create Measure with my required dimension and build the project to show the Measure in Entity store. After clicking refresh, I can see my Measure tables in the AxDW table. I had another issue. After refreshing Measure there was no Refresh log created in Tier 2 environment. So, I found the Full reset batch job is in Cancelled state, so I just changed the status on waiting and