Max Nguyen

This post is our own opinion and does not necessarily reflect the opinion or view of our companies or Microsoft.

Dynamics 365 FinOps Data Integration using Microsoft Forms (Part 1)

With any D365FO users, Data Management workspace and Data Entities should have become one of the most used and well-known tools in the system. We all agree how powerful such integration framework is, especially when it comes to a large number of records that we would need to import into different tables. The classic method that we have been utilizing is to include all source data in a single (or multiple, much depending on the purpose and order of data integration) Excel sheet, trigger an import execution, pass any validation layers that present and ultimately have the data available on D365FO.

Database Sync after data type on field has been changed

You will got an error like this when doing Database Synchronization after changing the data type of the field on the table: InvalidOperationException: Table … : Converting Field ‘..’ of Type ‘..’ to ‘..’ is not support. Please drop the original field, sync the table and add new field with same name if needed. {:.error} Solution: Drop the table and delete references from SQLDictionary 1 2 3 4 5 6 7 8 9 10 DROP TABLE AXDB.

Getting onebox VHD Dynamics 365 finance and operations virtual machine

1. Download Dynamics 365 finance and operations VHD files Go to the LCS main page and select Shared asset library or go to Shared Asset Library. Select the asset type Downloadable VHD. Find the VHD you are looking for based on the desired Finance and Operation version. The VHD is divided into multiple file parts that you need to download. For example, the asset files that start with “VHD - 10.

Azure Storage Emulator 'Port conflict with existing application', Dynamics 365 finance and operations

The Microsoft Azure storage emulator is a tool that emulates the Azure Blob, Queue, and Table services for local development purposes. You can test your application against the storage services locally without creating an Azure subscription or incurring any costs. When you’re satisfied with how your application is working in the emulator, switch to using an Azure storage account in the cloud. In Dynamics 365 finance and operations onebox environment, we also use Microsoft Azure Storage Emulator for same purposes.

Dynamics 365 finance and operations ODATA consuming - Length cannot be less than zero

When you consume a custom data entity, you get an error errorSystem.ArgumentOutOfRangeException : Length cannot be less than zero” and it works fine for standard data entities. {:.error} The reason is the temporary XML file where the metadata stored which mismatches with the metadata from https://<yourenvironment>$metadata You can follow this post to understand how to create the XML file. If you try to regenerate the metadata by saving the file, the XML will be accumulated, and the error keeps happening.

Enable Power BI Embedded in cloud hosted Dynamics 365 finance and operations 8.0 +

In this article, we will go through how to enable Power BI embedded in Dynamics 365 finance and operations version 10 in a cloud-hosted environment (customer managed). From the previous version of FinOps, Power BI embedded uses workspace collections at Azure to display the report, since the workspace collections have been deprecated, Microsoft also disables power BI embedded in cloud-hosted environments. You can only enable Power BI embedded in multiple boxes environments like UAT and production.

Consuming Dynamics 365 Finance and Operations OData services from .NET

1. Authentication We need an authentication to connect Dynamics 365 finance and operations from .Net application by using service principal. How to create an app registration in Azure You also need to add required permissions for Dynamics 365 finance and operations, please follow This is what you should have 2. Register your external application a. In the FinOps application, go to System administration > Setup > Azure Active Directory applications.