Limitations of Business Rule with Mobile App – Nishant Rana’s Weblog
Nov14

Limitations of Business Rule with Mobile App – Nishant Rana’s Weblog

One of our customer reported that couple of Business Rules are not working in Mobile app which are working perfectly in Web application. Spent so much time to understand the problem with Mobile app and finally figured out that one tab on the contact form is not loaded in mobile app because of maximum 5 tabs allowed limitations. Some fields that we are referring in the  business rules are part of this missing tab. So, business rule...

Read More
The following job steps cannot be reached with the current job step flow logic in SSIS – Nishant Rana’s Weblog
Nov12

The following job steps cannot be reached with the current job step flow logic in SSIS – Nishant Rana’s Weblog

Recently while scheduling our SSIS Packages in SQL Server Agent Jobs we got the below error WARNING: The following job steps cannot be reached with the current job step flow logic: [1] Fashion Spend package We just need to make sure that we have set correct package in the Start Step properties in Job Properties Dialog Box To: – Hope it helps.. Like this: Like Loading… Related Continue Reading Nishant Rana’s Article on...

Read More
HideCustomAction and Display  Enable rule in Dynamics 365 – Nishant Rana’s Weblog
Nov12

HideCustomAction and Display Enable rule in Dynamics 365 – Nishant Rana’s Weblog

Imagine a scenario where we have both the disable rule and HideCustomAction implemented for a ribbon button. Let us see with an example what will happen in this scenario. First, let us implement the display rule to hide the Delete button from Contact form when it is in a disabled state. For active record à We can see the delete button in the command bar. For disabled record à The delete button is not visible. Now let us hide the...

Read More
Installation order for Solutions (Patches) in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog
Nov11

Installation order for Solutions (Patches) in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog

Let us take see a simple example of how the installation order of solution and patch works in case of Dynamics 365 CE. Suppose we have a Solution A with only Account Number field with display name renamed to Account Number from Solution A. Now this solution is exported as managed and imported into the target environment Now let us create a new solution which renames this field as “Account Number from Solution B” and then import this...

Read More
The following managed solution cannot be imported. The publisher name cannot be changed in Dynamics 365 CE – Nishant Rana’s Weblog
Nov09

The following managed solution cannot be imported. The publisher name cannot be changed in Dynamics 365 CE – Nishant Rana’s Weblog

We can change publisher of a solution using Publisher lookup field of the solution in the Information section. However, if the solution has already been imported in target environment, changing the publisher and trying to import the solution will result in the below error. Here we try renaming the publisher from “default..” to “sable37”...

Read More
QuickFindQueryRecordLimit exceeded. Cannot perform this operation error in Dynamics 365 CE – Nishant Rana’s Weblog
Nov08

QuickFindQueryRecordLimit exceeded. Cannot perform this operation error in Dynamics 365 CE – Nishant Rana’s Weblog

We would get this below error if our search returns more than 10000 records for Quick Find Query. “There are more search results than can be displayed. Try adding more search terms (such as last name) to narrow your search results. If you contact support, please provide the technical details” We can fix it by setting Enable Quick Find record limits to No in System Settings à General tab. More details...

Read More
Access denied due to invalid subscription key error while using FaceServiceClient in Microsoft Cognitive Services – Nishant Rana’s Weblog
Nov07

Access denied due to invalid subscription key error while using FaceServiceClient in Microsoft Cognitive Services – Nishant Rana’s Weblog

Recently while working with Face API we were getting the below error To get it working we had to define apiRoot along with the subscriptionkey while initializing the FaceServiceClient object. Hope it helps.. Like this: Like Loading… Related Author Nishant RanaPosted on November 8, 2018November 6, 2018Categories AI, Machine LearningTags Artificial Intelligence, FaceAPI, Machine Learning, Microsoft Cognitive Service Continue...

Read More
SiteMapName in the AppModuleSiteMap is null or empty error while importing V9 Solution in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog
Nov06

SiteMapName in the AppModuleSiteMap is null or empty error while importing V9 Solution in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog

We recently upgraded our Dev and Test environment to V 9.0. Dev Test While importing a solution from Dev to Test which had SiteMap we got the below issue. “The SiteMapName in the AppModuleSiteMap is null or empty” It turns out that the following tags were required and were missing in the Customization.xml We added that tag and were able to import the solution successfully. Interestingly if we export the same solution from Test and...

Read More
Different Updating Instance status during Dynamics 365 Upgrade – Nishant Rana’s Weblog
Nov05

Different Updating Instance status during Dynamics 365 Upgrade – Nishant Rana’s Weblog

The day has come when we had scheduled the upgrade of our Dynamics 365 instance Test Instance(from 8.2 to 9.0). We can see the below message during the scheduled time à “The update will being within 24 hours. No rescheduling is available”. The following Reschedule Update option will go missing during the scheduled time. After waiting for few minutes, we see the Update Status as Queue (Not Started) Followed by the status as “Database...

Read More
Plugin on Pre-Validation Stage in Dynamics 365 CE – Nishant Rana’s Weblog
Nov05

Plugin on Pre-Validation Stage in Dynamics 365 CE – Nishant Rana’s Weblog

Recently we had a requirement to delete the Account record without deleting the associated Contact records. If we try deleting the account record we’d get the following message box The relationship definition can’t be updated as well to achieve this So, we wrote a plugin on the pre-validation stage of pre-delete event of Account, which will retrieve and loop through all the child contact records and set its parent customer field as...

Read More
Manage CDS Entity Data – Microsoft PowerApps Office Add-In – Nishant Rana’s Weblog
Nov04

Manage CDS Entity Data – Microsoft PowerApps Office Add-In – Nishant Rana’s Weblog

Microsoft PowerApps Office Add-In enables user to read, modify and insert data in CDS environment. Add-In is available for download here for free, or you will be prompted to install Add-In for first time when you open entity data in excel from PowerApps portal. Add-In establishes connection to PowerApps OData service. Note: Add-In is compatible with Office 2016 or later versions only. Using Microsoft PowerApps Office Add-In in excel...

Read More
Earned “Top 10 in October 2018 Blog Leaderboard” badge in Dynamics 365 Community – Nishant Rana’s Weblog
Nov03

Earned “Top 10 in October 2018 Blog Leaderboard” badge in Dynamics 365 Community – Nishant Rana’s Weblog

This month I was awarded the “Top 10 in October 2018 Blog Leaderboard” badge in Microsoft Dynamics Community. https://community.dynamics.com/members/nishant-rana/userbadges Thanks to all the readers and the subscribers of the blog. Check the below post as well. https://nishantrana.me/2018/10/03/earned-top-10-in-september-2018-blog-leaderboard-badge-in-dynamics-365-community/       Like this: Like Loading… Related Continue...

Read More
Monitoring SSIS package Job Status – Nishant Rana’s Weblog
Nov02

Monitoring SSIS package Job Status – Nishant Rana’s Weblog

Suppose we have scheduled our packages through SQL Server Agent Job and we receive the notification that one of our packages has failed. To get its details, within SSISDB, we can check the Standard Reports like Integration Services Dashboard report, All Executions etc. to get the details. This will provide the information about the operation that have run or are currently executing. We can click on Failed record link to filter the...

Read More
PowerApps – New Functions Introduced – GUID, Concurrent & Notify – Nishant Rana’s Weblog
Nov01

PowerApps – New Functions Introduced – GUID, Concurrent & Notify – Nishant Rana’s Weblog

Microsoft has released many new features and enhancements for PowerApps since June 2018, part of this blog we will cover three new functions introduced which I believe would be mostly used. GUID Function: In my blog, I mentioned how to generate unique GUID using Azure function which requires us to create an azure function, a custom connector and connection between two. Microsoft has now introduced a new function GUID() which will...

Read More
Using RetrieveRecordChangeHistoryRequest to get Audit Detail in Dynamics 365 CE – Nishant Rana’s Weblog
Oct31

Using RetrieveRecordChangeHistoryRequest to get Audit Detail in Dynamics 365 CE – Nishant Rana’s Weblog

Just sharing a sample code to retrieve the Audit Detail using RetrieveRecordChangeHistoryRequest. RetrieveRecordChangeHistoryRequest changeRequest = new RetrieveRecordChangeHistoryRequest(); changeRequest.Target = new EntityReference("entitySchemaName", "entityId")); RetrieveRecordChangeHistoryResponse changeResponse = (RetrieveRecordChangeHistoryResponse)_service.Execute(changeRequest); AuditDetailCollection auditDetailCollection =...

Read More
Using the Content Access Level for KB Articles in Customer Self-Service Portal – Nishant Rana’s Weblog
Oct29

Using the Content Access Level for KB Articles in Customer Self-Service Portal – Nishant Rana’s Weblog

Suppose we have already configured Portal, created contacts and associated KB article to the Portal. Now the scenario we want to implement is we want a particular user to have access to all the KB article and another user to only specific KB Articles. For this, we will make use of Content Access Level concept of the portals. Content access level can be assigned to KB Article and can also be assigned to the Contact Users. There are 3...

Read More
The version of the Script Component is not compatible with this version of the DataFlow – Nishant Rana’s Weblog
Oct28

The version of the Script Component is not compatible with this version of the DataFlow – Nishant Rana’s Weblog

While trying to run one of our SSIS Packages from SQL Server Job, which had script component in it, we got the below error. It was running fine within the SSDT in our Dev Machine. In fact, the other packages deployed to SSISDB were also running fine, the ones which were not using the Script Component. To fix it, we updated the project version of SSDT to match the SQL Server where we were deploying the package inside Project...

Read More
Copy data from one database to another using Azure Data Factory – II – Nishant Rana’s Weblog
Oct28

Copy data from one database to another using Azure Data Factory – II – Nishant Rana’s Weblog

In the previous post, we discussed how to create Azure SQL Server and Azure SQL Database. Now that we are ready with source data/table and destination table, let’s create Azure Data Factory to copy the data. 3. Azure Data Factory: Click on Create a resource –> Analytics –> Data Factory Fill the mandatory fields and click Create After creating data factory, let’s browse it.Click on Author and Monitor. Click on Author icon on the left...

Read More
Fixed – Windows 10 Remote Desktop (RDP) not saving credentials. – Nishant Rana’s Weblog
Oct27

Fixed – Windows 10 Remote Desktop (RDP) not saving credentials. – Nishant Rana’s Weblog

Recently even after saving the credentials in connection settings to an RDP file, every time we were opening it, it was asking us to enter the password. The below steps helped us to fix the issue. Open Windows Group Policy Editor (gpedit.msc) from the command prompt. Go to Local Computer Policy – Administrative Templates – System – Credentials Delegation. Click on Allow delegating fresh credentials, select the option Enabled. Click on...

Read More
Deploying Package to SQL Server Integration Services Catalog (SSISDB) from Visual Studio (SSDT) – Nishant Rana’s Weblog
Oct27

Deploying Package to SQL Server Integration Services Catalog (SSISDB) from Visual Studio (SSDT) – Nishant Rana’s Weblog

Deploying packages to SQL Server from SSDT is straightforward. We can either deploy the project or an individual SSIS Package i.e. Project Deployment or Package Deployment. (SQL Server 2016 Onwards). Here we will see the package deployment. Right-click the package that we would like to deploy and select Deploy Package. This opens the Integration Services Deployment Wizard Click on Next and Specify Server Name and the credentials to...

Read More
Audit Information not getting retrieved using SSIS/KingswaySoft Adapter – Nishant Rana’s Weblog
Oct26

Audit Information not getting retrieved using SSIS/KingswaySoft Adapter – Nishant Rana’s Weblog

A few days back I wrote about how we can use CDS/CRM Source component of KingswaysSoft Adapter to get the audit information. https://nishantrana.me/2018/10/08/using-kingswaysofts-cds-crm-source-component-to-get-audit-information-in-dynamics-365-ce-ssis/ Recently while writing a package for getting audit details against one of the entities, we realized that the records were not getting retrieved and also, we were not getting any error...

Read More
Icebreakers section on Contact Form – Nishant Rana’s Weblog
Oct25

Icebreakers section on Contact Form – Nishant Rana’s Weblog

Recently, after upgrading our D365 V8 instance to D365 V9, we found that on Contact Form there was some discrepancy in the position of the sections. After comparing the Form Editor in both the instances(V8 and V9) we found the below differences: D365 V8: CARD DETAILS section at top right cornerD365 V9: New Icebreakers section at top right corner instead of CARD DETAILS section And, we found in upgraded instance that the actual content...

Read More
Set Up Your Workstation to Create SQL Server Reporting Services Reports for Dynamics 365 Revisited – Nishant Rana’s Weblog
Oct24

Set Up Your Workstation to Create SQL Server Reporting Services Reports for Dynamics 365 Revisited – Nishant Rana’s Weblog

Summary The process to set up a workstation to create SQL Server Reporting Services (SSRS) reports for Dynamics 365 involves a lot of steps and causes some confusion. The report authoring tool is Visual Studio, but a full licensed version of Visual Studio is not required. The Dynamics 365 Report Authoring Extensions has been recently updated to address TLS 1.2 requirements of Dynamics 365 v9 Revisited A couple of years ago I wrote a...

Read More
Uninstalling or Deleting Dynamics 365 Portals Solution – Nishant Rana’s Weblog
Oct23

Uninstalling or Deleting Dynamics 365 Portals Solution – Nishant Rana’s Weblog

Recently we wanted to remove the Community Portal Solution from one of our Development instances. Here, the solutions admin page doesn’t give the option of deleting or removing it. To remove it, we need to uninstall all the solutions installed by the Dynamics 365 Portals – Community Portal. Back in Dynamics 365 we can see so many solutions installed as part of community portal. Here we need to remove the solutions in the reverse order...

Read More
Using Script Component to specify input value to OLE DB Source Component in SSIS – Nishant Rana’s Weblog
Oct22

Using Script Component to specify input value to OLE DB Source Component in SSIS – Nishant Rana’s Weblog

Recently we had a requirement to write an SSIS package that will fetch the data from SQL Server and will insert it (or create records) into Dynamics 365 CE. For connecting and fetching data from SQL Server, we were using OLE DB Source Component with data access mode as SQL Command which had one parameter, whose value we had to fetch from Dynamics 365 CE. For passing the value to this parameter we had defined a variable within our...

Read More
Ribbon Button Enable Rule Custom JS Code gives error “Cannot read property ‘getFormContext’ of undefined” – Nishant Rana’s Weblog
Oct22

Ribbon Button Enable Rule Custom JS Code gives error “Cannot read property ‘getFormContext’ of undefined” – Nishant Rana’s Weblog

While working on upgrade activities of D365 V9 from D365 V8, we faced one weird issue related to Enable Rule of  Ribbon button. We had one form where we were using Enable Rule for a button which was defined using custom JS code. As part of client side scripting changes related to D365 V9 upgrade, we passed Primary Control as first CRM parameter in Ribbon Workbench for that Enable Rule as explained here and in JS we passed...

Read More
Using Output Timezone property of CDS/CRM Source Component in SSIS – Nishant Rana’s Weblog
Oct21

Using Output Timezone property of CDS/CRM Source Component in SSIS – Nishant Rana’s Weblog

In Dynamics 365 CE, the data time field’s value will always be returned in UTC time when retrieved through the Organization Service. Just go through this insightful article to learn more about CRM Date Time. https://www.powerobjects.com/2012/06/07/crm-2011-truths-about-datetime/ For e.g. Within application à Inside CRM Now to get it in Local Time of the User we can use LocalTimeFromUTCTimeRequest...

Read More
Unable to Login to Dynamics CRMOrganization WebProxy
Oct20

Unable to Login to Dynamics CRMOrganization WebProxy

Recently for a console application we got the below error while using CrmServiceClient. The possible reason is we haven’t specified that security protocol TLS12 to be used in our console application and it is still targeting .NET Framework 4.5.2. Add the following line of code to get it working if that is the case. If we are using Visual Studio 2017, simply change the Target Version to .NET Framework 4.6 or higher. It internally...

Read More
Blockchain as a Service (BaaS- Azure) Introduction – Nishant Rana’s Weblog
Oct19

Blockchain as a Service (BaaS- Azure) Introduction – Nishant Rana’s Weblog

Just to save you some time – read the article if you would like answers to the below questions ? What is Blockchain a solution to? Different types of Blockchain Why is Blockchain secure? How does blocks get built in a ‘Block-chain’? Happy reading! In physical terms – Blockchain is essentially a network of computers. Each computer in the network accepts, confirms and stores transactions in a synchronized chain of confirmed transaction...

Read More
Microsoft Common Data Service : CDS
Oct18

Microsoft Common Data Service : CDS

Originally posted on Upskill your Tech Skills: Before you go ahead, read this article if you would like the below questions answered: – What business problem does the CDS solve? How does the common Data Service(CDS) work? How can I get access to it? Business Pain points CDS brings together all data from different departments/… Continue Reading Nishant Rana’s Article on their...

Read More
The collection of variables locked for read and write access is not available outside of PostExecute error in SSIS – Nishant Rana’s Weblog
Oct17

The collection of variables locked for read and write access is not available outside of PostExecute error in SSIS – Nishant Rana’s Weblog

We might get this error while trying to access a ReadWrite variable within Script Component outside Post Execute. Here we were using it within ProcessInputRow method As per the official documentation – the reason for this error is because ReadWriteVariables are only available inside PostExecute method for improved performance and minimizing...

Read More
Using OverriddenCreatedOn or Record Created On field to update Created On field in Dynamics 365 – Nishant Rana’s Weblog
Oct16

Using OverriddenCreatedOn or Record Created On field to update Created On field in Dynamics 365 – Nishant Rana’s Weblog

While working in data migration project, when creating records in the target system, we would want the “created on” field to hold the original value instead of it being set to the actual value when it was created in the target system, which is set by the system or the platform itself. Suppose we are having the “created on” field in our source SQL Server Table and we are creating the lead records in our target Dynamics 365 organization...

Read More
Data Flow Transformations in SSIS – Nishant Rana’s Weblog
Oct15

Data Flow Transformations in SSIS – Nishant Rana’s Weblog

SSIS has various data flow transformation components that make it easy to manipulate the source data before it can be sent to the destination for processing. Below are some of the most frequently used one For changing the data type of the source column. Simply select the input column and then specify the data type for it. For e.g., if our source has one of the date columns as a string, we can apply Data Conversion transformation to...

Read More
Client API Change for openWebResource – Nishant Rana’s Weblog
Oct14

Client API Change for openWebResource – Nishant Rana’s Weblog

Prior to D365 V9, we were using Xrm.Utility.openWebResource() to open a web resource in a new window. However, going forward in D365 V9 we need to use Xrm.Navigation.openWebResource() to perform the same operation. Let’s take an example: D365 V8: D365 V9: Hope it helps !! Continue Reading Nishant Rana’s Article on their...

Read More
Stop SSIS Package Execution in SSISDB – Nishant Rana’s Weblog
Oct14

Stop SSIS Package Execution in SSISDB – Nishant Rana’s Weblog

Suppose a package has been running for quite a long time or has been mistakenly run and we would like to stop its execution. To do so Right Click on SSISDB Select All Execution Reports Filter it to see all the Running packages We can see our all the running packages there. Now to stop any specific package, right click SSISDB and select Active Operations From the Active Operation window, select the running job and click on Stop button...

Read More
Using Alternate Key to set Lookup in SSIS (KingswaySoft) – Nishant Rana’s Weblog
Oct13

Using Alternate Key to set Lookup in SSIS (KingswaySoft) – Nishant Rana’s Weblog

Alternate Keys which were introduced with CRM 2015 Update 1, gave us the ability to Upsert and Update records, by defining one or more fields as Alternate Key and use that field(s) instead of relying only on Primary Key. Alternate Keys can also be used for setting or updating the lookup instead of GUID. CDSCRM Destination Component in KingswaySoft SSIS Integration Toolkit allows us the option of specifying the Alternate Key for...

Read More
Create Azure Machine Learning Web Service using Azure Machine Learning Studio – Nishant Rana’s Weblog
Oct12

Create Azure Machine Learning Web Service using Azure Machine Learning Studio – Nishant Rana’s Weblog

Azure’s Machine Learning Studio makes it easy to create machine leaning based solution. To try it free, go to Machine Learning Studio’s home page and sign in with the existing Microsoft Account. (or we can make use of existing Azure Account and add Machine Learning to it) Azure Machine Learning Studio is an IDE for Machine Learning, that allows us to design, develop, test, deploy the solution easily using drag and drop functionality....

Read More
Create Azure Machine Learning Web Service using Azure Machine Learning Studio – Nishant Rana’s Weblog
Oct12

Create Azure Machine Learning Web Service using Azure Machine Learning Studio – Nishant Rana’s Weblog

Azure’s Machine Learning Studio makes it easy to create machine leaning based solution. To try it free, go to Machine Learning Studio’s home page and sign in with the existing Microsoft Account. (or we can make use of existing Azure Account and add Machine Learning to it) Azure Machine Learning Studio is an IDE for Machine Learning, that allows us to design, develop, test, deploy the solution easily using drag and drop functionality....

Read More
JavaScript and Business Rule on the same field – Nishant Rana’s Weblog
Oct11

JavaScript and Business Rule on the same field – Nishant Rana’s Weblog

Recently, on change of value of a field, we had business rule earlier and then we decided to perform the same using JavaScript to avoid hard coding of value in Business rule. The logic was to set value of 2 other fields on the form based on the value selected. The logic was working fine on DEV as we had deactivated the business rule. However, after deploying to TEST and UAT, it stopped working. We verified that the JavaScript event...

Read More
Alternate Key not getting created on solution import in Dynamics 365 – Nishant Rana’s Weblog
Oct10

Alternate Key not getting created on solution import in Dynamics 365 – Nishant Rana’s Weblog

Recently, we moved our Solution from Development to Test. Then on running one of the SSIS Packages we got the below error The specified key attributes are not a defined key for the entity [4] CRM service call returned an error: On opening the Entity for customization, and checking for the key, we saw that it was in the Status Pending. On opening the system job, there was no detail for the error. We normally get this error, if there...

Read More
Creating Power BI Report using Power Query (M) Builder plugin of XrmToolBox – Nishant Rana’s Weblog
Oct09

Creating Power BI Report using Power Query (M) Builder plugin of XrmToolBox – Nishant Rana’s Weblog

Power Query(M) Builder XrmToolBox Plugin developed by Ulrik Carlsson and Mohamed Rasheed makes it very easy to develop Power BI Reports targeting Dynamics 365 CE. Just listing down the basic steps below for quick reference à Install the Power Query (M) Builder plugin from XrmToolBox Click on Load Entities and select the Entity against which we want to write the report. Here we will be writing a report against Case entity (for e.g....

Read More
Using KingswaySoft’s CDS/CRM Source component to get Audit information in Dynamics 365 CE (SSIS) – Nishant Rana’s Weblog
Oct08

Using KingswaySoft’s CDS/CRM Source component to get Audit information in Dynamics 365 CE (SSIS) – Nishant Rana’s Weblog

Kingsway’s CDS/CRM Source component and has Source Type property having an AuditLogs value that can be used to get the Audit details from Dynamics 365 CE. Below we have set the Source Type as AuditLogs in the CDS/CRM Source Component Editor and provided the FetchXML for the entity for which we would like to retrieve the audit information. To get all the audit records, we can run it against Audit entity. For AuditLogs source type there...

Read More
Client API Change for openEntityForm – Nishant Rana’s Weblog
Oct08

Client API Change for openEntityForm – Nishant Rana’s Weblog

Prior to D365 V9, we were using Xrm.Utility.openEntityForm() to open an existing record or to open a create form of an entity providing some additional parameters. However, in D365 V9 as it has been deprecated, we need to use Xrm.Navigation.openForm() to perform the same operation. Here’s an example of the change in API along with it’s parameters.D365 V8: D365 V9: While creating a new record, we can pass values to the attributes using...

Read More
Upgrade to new Xrm client API object model (v9) smoothly using XrmToolBox plugins – Nishant Rana’s Weblog
Oct07

Upgrade to new Xrm client API object model (v9) smoothly using XrmToolBox plugins – Nishant Rana’s Weblog

We are currently in process of upgrading Dynamics from version 8.2 to 9.0. One of the major change is updating our current JavaScript to the new Xrm Client API Object Model. https://docs.microsoft.com/en-us/dynamics365/get-started/whats-new/customer-engagement/important-changes-coming#some-client-apis-are-deprecated https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/clientapi/understand-clientapi-object-model...

Read More
Ribbon button changes – Nishant Rana’s Weblog
Oct06

Ribbon button changes – Nishant Rana’s Weblog

If we have custom Ribbon button and custom JS code to perform some action on click of it or to simply display/hide Ribbon button based on some condition in JS code in version prior to D365 V9, then following changes need to be done to make them work in D365 V9. Using Ribbon Workbench, add a new parameter to the command/enable rule/display rule of type CRM Parameter: Select the value of CRM Parameter as PrimaryControl: After making...

Read More
Dealing with OptionSet inside PowerBI in Dynamics 365 CE – Nishant Rana’s Weblog
Oct06

Dealing with OptionSet inside PowerBI in Dynamics 365 CE – Nishant Rana’s Weblog

Suppose, we have created a Power BI Report which makes use of OptionSet field. It is on incident entity and we have selected priority code and state code option set fields. The problem is that we only get the value for them, so to get the label either we can manually specify it or use the plugin Power BI Option Set Assistant. We’d see both the methods. Let us take state code field first and specify label for them manually. In the...

Read More
Upgrading from Dynamics CRM 2016 On-Premise to Dynamics 365 – Nishant Rana’s Weblog
Oct05

Upgrading from Dynamics CRM 2016 On-Premise to Dynamics 365 – Nishant Rana’s Weblog

Make sure the Solution is compatible to Dynamics 365 (8.2), for this check the Version Compatibility https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/gg328109%28v%3dcrm.8%29#version-compatibility Upgrade the existing CRM 2016 On-Premise Server to CRM 2016 (8.1) for its solution to be compatible with Dynamics 365 Online using cumulative updates....

Read More
My notes on Dynamics 365 Data Export Service – Nishant Rana’s Weblog
Oct04

My notes on Dynamics 365 Data Export Service – Nishant Rana’s Weblog

Recently we configured Data Export Service in our Production environment. The idea was to export the data to Azure SQL DB that can be used for Power BI report. https://nishantrana.me/2017/03/19/configuring-data-export-service-in-microsoft-dynamics-365/ Pros: Easy to configure. Takes care of incremental changes. Easy to check the status Cons: Issues with the Failed records. For e.g. We have around 200K records failed for one entity as...

Read More
Earned “Top 10 in September 2018 Blog Leaderboard” badge in Dynamics 365 Community – Nishant Rana’s Weblog
Oct03

Earned “Top 10 in September 2018 Blog Leaderboard” badge in Dynamics 365 Community – Nishant Rana’s Weblog

I have my blog syndicated to Dynamics 365 Community. We can request our existing blog to be syndicated to Microsoft Dynamics Community which I would strongly recommend all the Dynamics 365 bloggers out there. Click the below link to get all the details à https://community.dynamics.com/w/help/136.request-a-new-blog-or-blog-to-syndicate With blog syndicated, your blog post would also be published to Dynamics community as well and active...

Read More
Error validating profile registration while configuring Microsoft Dynamics 365 Data Export Service – Nishant Rana’s Weblog
Oct02

Error validating profile registration while configuring Microsoft Dynamics 365 Data Export Service – Nishant Rana’s Weblog

While configuring the Data Export Service we got the below error while validating the profile It mostly occurs if there is some issue with the connection string specified in the PowerShell Script used for generating the key vault. Always copy the connection string from the Azure SQL Connection Strings property and double check the username and password provided there. And make sure the user specified has all the required...

Read More