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
Using Recurrence trigger in Microsoft Flow – Nishant Rana’s Weblog
Oct01

Using Recurrence trigger in Microsoft Flow – Nishant Rana’s Weblog

Schedule – Recurrence trigger inside Microsoft Flow makes it extremely easy and effective to write a recurring job specially in the context of Dynamics 365, wherein it isn’t straight forward. We can use Workflows with wait and timeout conditions but that isn’t the easiest and efficient way. Each approach has its own pros and cons though. The scenario we are going to implement is getting basic details of all the leads record created...

Read More
Could not load file or assembly ‘CrmLibraries, Version=8.0.0.0’ while using Microsoft Dynamics 365 Developer Toolkit – Nishant Rana’s Weblog
Sep30

Could not load file or assembly ‘CrmLibraries, Version=8.0.0.0’ while using Microsoft Dynamics 365 Developer Toolkit – Nishant Rana’s Weblog

While trying to deploy Plugin through Developer Toolkit we got the below error Could not load file or assembly ‘CrmLibraries, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. The system cannot find the file specified.    at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark&...

Read More
My Favorite – Visual Studio Tips and Tricks – Nishant Rana’s Weblog
Sep29

My Favorite – Visual Studio Tips and Tricks – Nishant Rana’s Weblog

Sharing some of my favorites Select entire line of code Put the cursor anywhere in that line of code and without selecting anything just press ctrl + c or ctrl + x Here I have put my cursor just before the var declaration. Pressing ctrl + x will cut the entire line Use ALT key to make selection from middle of the line spanning multiple lines and replace the content. Press and hold Alt while making the selection to select the content...

Read More
Azure Service Bus Queue Integration with D365 – Part 1 – Nishant Rana’s Weblog
Sep28

Azure Service Bus Queue Integration with D365 – Part 1 – Nishant Rana’s Weblog

In this series, we’ll see how we can integrate Azure Service Bus Queue with D365. This series has been divided into 2 parts: Part 1: How we can create a service bus queue in Azure portal and registration of service endpoint using plugin registration tool Part 2: Do some operation in D365 and the message appears in Service Bus Queue. Also, read the message from queue. Part 1: Create service bus queue in Azure portal Login to azure...

Read More
“An error occurred when verifying security for the message” in Dynamics 365 CE – Nishant Rana’s Weblog
Sep27

“An error occurred when verifying security for the message” in Dynamics 365 CE – Nishant Rana’s Weblog

While trying to connect to Dynamics 365 CE through a console application we were getting the below error. “An unsecured or incorrectly secured fault was received from the other party” “An error occurred when verifying security for the message” Changing the version of the assemblies referenced, changing the target version of the framework etc. didn’t help. Eventually we realized that the Date and time was incorrect in the machine (was...

Read More
Limitations of Duplicate Detection Rules – Nishant Rana’s Weblog
Sep27

Limitations of Duplicate Detection Rules – Nishant Rana’s Weblog

Author: Zohaib Uddin Khan Duplicate detection is one of the old and powerful feature of Dynamics family. But, I found it has some major limitations and inconsistency. I tried to use them in every implementation but reach to a point where I decided not to use them is my best bet. Anyhow, following are the ones which bother me heaps:- Duplicate detection works with Dynamics 365 for tablets, but isn’t available for Dynamics 365 for...

Read More
Completed 11 year of blogging with WordPress !
Sep26

Completed 11 year of blogging with WordPress !

Completed 11 year of blogging with WordPress ! Continue Reading Nishant Rana’s Article on their...

Read More
Changing the target runtime version of Azure Functions – Nishant Rana’s Weblog
Sep26

Changing the target runtime version of Azure Functions – Nishant Rana’s Weblog

Azure Functions 2.x runtime is based on .NET Core 2 from .NET Framework 4.7 in 1.x. So, any application migrating from 1.x to 2.x needs to make sure that they are using and referring the compatible code and libraries. We can also update our Azure Functions to target the appropriate runtime using the below steps à Inside Azure Portal, select the Function App, click on Application Settings within Platform Features tab. We can specify...

Read More
The type or namespace name Xrm could not be found (are you missing a using directive or an assembly reference?) error while using Azure Functions 2.x
Sep25

The type or namespace name Xrm could not be found (are you missing a using directive or an assembly reference?) error while using Azure Functions 2.x

Recently while working on Azure Functions (https://nishantrana.me/category/azure-functions/), we started getting the error that type or namespace Xrm could not be found. We had added the project.json file with appropriate NuGet Package reference inside it It was later we realized that project.json file have been replaced with function.proj in Azure Function 2.0. More details...

Read More
401 Not Authorized error while access project in VSTS – Nishant Rana’s Weblog
Sep25

401 Not Authorized error while access project in VSTS – Nishant Rana’s Weblog

Recently one of our users was getting the below error while trying to access the VSTS Project. 401 NOT AUTHORIZED and the following account does not have sufficient permissions to complete the operation. The following permissions are needed to perform this operation. View project level information. Here we can see the users being added to the project team and the team having all the appropriate rights. Adding the user to other groups...

Read More
LookupRecordNotAvailable error while using Configuration Migration Tool in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog
Sep24

LookupRecordNotAvailable error while using Configuration Migration Tool in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog

While trying to migrate the record using the Configuration Migration Tool, we were getting error like below in the log ImportEntity – Result: True – Entity: transactioncurrency – Adding transactioncurrency to the reprocess List as field createdonbehalfby with value 05d52058-eb35-41e8-8af7-dfb7120c4599 – LookupEntity systemuser and Record Id 2655712b-e13b-e711-80fb-5065f38b5691 (SYSTEM) – (action:Update) failed validation for reason...

Read More
Dynamics 365 and Office 365 in different tenants – How to consolidate !! – Nishant Rana’s Weblog
Sep24

Dynamics 365 and Office 365 in different tenants – How to consolidate !! – Nishant Rana’s Weblog

We have run into many scenarios where a company has Office 365 and then orders Dynamic 365 from a CSP (Cloud Service Provider) and their systems end up different tenants.  As Microsoft moves to the model where there can be more than one partner of record and various flavors of Dynamics 365 (Finance and Operations, Business Central, Customer Engagement, etc..),  I can see this problem getting more prevalent over time. When your Office...

Read More
Dynamics 365 Saturday – Dynamics 365 Top 20 Tips & Tricks – Nishant Rana’s Weblog
Sep24

Dynamics 365 Saturday – Dynamics 365 Top 20 Tips & Tricks – Nishant Rana’s Weblog

22nd-Sept-2018 – Auckland, New Zealand Today I delivered the session titled “Dynamics 365 Top 20 Tips & Tricks”. The PowerPoint presentation is available for download at the link below. https://app.box.com/s/0gvi11qd9t4pgk55daa0hmc2rum5gwu9 Enjoy! Greg Olsen YellowDuckGuy Continue Reading Nishant Rana’s Article on their...

Read More
Microsoft adds two more Dynamics 365 AI apps to its roadmap – Nishant Rana’s Weblog
Sep21

Microsoft adds two more Dynamics 365 AI apps to its roadmap – Nishant Rana’s Weblog

Microsoft is adding more AI-infused Dynamics 365 applications to its line-up. In addition toe the previously announced Dynamics 365 AI for Sales app, Microsoft also is introducing a Dynamics 365 AI for Customer Service app and a Dynamics 365 AI for Market Insights app this fall, officials said on September 18. Link: Microsoft adds two more Dynamics 365 AI apps to its roadmapvia http://www.zdnet.com Continue Reading Nishant...

Read More
Mobile-first indexing enabled for the blog – Nishant Rana’s Weblog
Sep20

Mobile-first indexing enabled for the blog – Nishant Rana’s Weblog

Today I saw this message in my inbox Below is the official announcement from Google from March 26, 2018. https://webmasters.googleblog.com/2018/03/rolling-out-mobile-first-indexing.html The below article nicely explains Mobile First Indexing https://moz.com/blog/mobile-first-indexing-seo Let us see how it impacts the number of views visitors in the blog. Hope it helps.. Like this: Like Loading… Continue Reading Nishant...

Read More
Easily map OptionSet using CRM OptionSet Mapping Editor in SSIS – Nishant Rana’s Weblog
Sep19

Easily map OptionSet using CRM OptionSet Mapping Editor in SSIS – Nishant Rana’s Weblog

Just want to share my experience of using KingswaySoft’s OptionSet Mapping Editor and how easy and efficient it makes to migrate data in Microsoft Dynamics 365 CE. Here our SQL (OLE DB Source) was having following values for Phone Code field. Here we are doing upsert for the Contact entity. However inside CRM, we were only maintaining or dealing with few of the values as shown below for the corresponding field. To deal with this...

Read More
“The application requires one of the following versions of the .NET Framework” or “.NET Framework 4.7.1 or later is already installed this computer” error while running application
Sep18

“The application requires one of the following versions of the .NET Framework” or “.NET Framework 4.7.1 or later is already installed this computer” error while running application

While trying to run an application we were getting the below message It was taking us to Microsoft Download site for downloading the framework. We downloaded the 4.7.1 Framework but while trying to install it we got the below message that said the framework or a later update is already installed on this computer. Tried uninstalling all the .NET Framework version installed including 4.7. That also didn’t work. Few of the forums talk...

Read More
Using Diff Detector component for working with incremental data in SSIS (Dynamics 365 CE) – Nishant Rana’s Weblog
Sep18

Using Diff Detector component for working with incremental data in SSIS (Dynamics 365 CE) – Nishant Rana’s Weblog

Diff Detector component of KingswaySoft’s SSIS Productivity Pack makes it extremely easy efficient to work with incremental data. Let us take a simple example to understand its usage Suppose, we have the following data in our SQL Table (source) that we have already moved to our Dynamics 365 Instance. Inside CRM à Now let us delete few records say for e.g. 5 from CRM and now we want only those 5 deleted records to be considered for...

Read More
The top attribute can’t be specified with paging attribute page in SSIS Package – Nishant Rana’s Weblog
Sep18

The top attribute can’t be specified with paging attribute page in SSIS Package – Nishant Rana’s Weblog

We might face this issue while using Dynamics CRM Source Component of SSIS Integration Toolkit [Dynamics CRM Source] Warning: An exception has occurred while processing the service request, the same request will be attempted again immediately. KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call returned an error: The top attribute can’t be specified with paging attribute page (Error Code: -2147220989,...

Read More
00 in SSIS (Dynamics 365) – Nishant Rana’s Weblog
Sep12

00 in SSIS (Dynamics 365) – Nishant Rana’s Weblog

We got the below while trying to UPSERT contact records from a SQL table to Dynamics 365 CE using Kingswaysoft Dynamics 365 Adapter. The source table had the Date of birth (DOB) as nvarchar type (string) and one of the rows had the following value stored for DOB à ‘0201-01-09 00:00:00’ Which was resulting into exception while creating record inside Dynamics 365 CE with the above date. The way we fixed it was to make use of Derived...

Read More
Cannot convert between unicode and non-unicode string data types error in SSIS – Nishant Rana’s Weblog
Sep10

Cannot convert between unicode and non-unicode string data types error in SSIS – Nishant Rana’s Weblog

While using the OLE DB Source component in SSIS, on updating its SQL Command we started getting the below error for “Phone” column in our Table. The fix is to open the Advanced Editor for the OLE DB Source component Change the Data Type (non-unicode string) for the Phone column inside Output Columns in Input and Output Properties Tab. Changing the Data Type from Unicode string [DT_WSTR] to string [DT_STR] fixed the issue. Hope it...

Read More
Publish as Azure Web Job Option missing in Visual Studio 2017 – Nishant Rana’s Weblog
Sep06

Publish as Azure Web Job Option missing in Visual Studio 2017 – Nishant Rana’s Weblog

While trying to publish one of our console application to Azure as Web Job we couldn’t find the “Publish as Azure WebJob..” option It was because Azure development tools were recently uninstalled from the system. To install it, go to Windows à Program and Features à Select Visual Studio 2017 and click on Modify. And select Azure Development for installation Select Azure Cloud Services tool. After installation it will ask for restart....

Read More
How to – convert a blank string to Null for DateTime field – SSIS – Nishant Rana’s Weblog
Sep02

How to – convert a blank string to Null for DateTime field – SSIS – Nishant Rana’s Weblog

Recently while writing an SSIS package, we were getting the below exception. System.Exception: Error: Failed to set field ‘birthdate’ value to ” for entity ‘contact’ (field type: DateTime, value type: String). System.FormatException: String was not recognized as a valid DateTime. (SSIS Integration Toolkit for Microsoft Dynamics 365, v10.2.0.6972 – DtsDebugHost, v14.0.3025.39) We were getting the exception because the source table was...

Read More
No Action header was found with namespace ‘http://www.w3.org/2005/08/addressing’ for the given message – error while calling a WCF Service through C/AL (Client/server Application Language)
Aug30

No Action header was found with namespace ‘http://www.w3.org/2005/08/addressing’ for the given message – error while calling a WCF Service through C/AL (Client/server Application Language)

While trying to call a WCF service from within the C/Al in Microsoft Dynamics NAV, we were getting the below error “No Action header was found with namespace ‘http://www.w3.org/2005/08/addressing‘ for the given message.” Strangely enough that request was working properly from within the SOAP UI. Eventually the following thread came to the rescue...

Read More
You are not authorized or do not have any subscriptions associated error while trying to access Kudo Sites in Azure – Nishant Rana’s Weblog
Aug29

You are not authorized or do not have any subscriptions associated error while trying to access Kudo Sites in Azure – Nishant Rana’s Weblog

Today for one of our Azure WebJobs when we tried checking its log, we got the below error à Seemed strange as being the Contributer of that Resource Group, I had access to all other functionality within that resource group. After much struggle, in one of threads there was a suggestion to try in a different browser or in private browsing mode. And luckily that worked. Out of all responses, this one makes the most sense for this...

Read More
The process cannot access the file .ispac because it is being used by another process error in Visual Studio (SSIS). – Nishant Rana’s Weblog
Aug28

The process cannot access the file .ispac because it is being used by another process error in Visual Studio (SSIS). – Nishant Rana’s Weblog

Recently while developing SSIS packages, the Visual Studio (SSDT) got crashed. After restarting the Visual Studio and trying to execute the package we got the below error. System.IO.IOException: The process cannot access the file ‘c:folderssisproject.ispac’ because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.Delete(String path) at… Continue Reading...

Read More
PowerApps – Secure your Azure Function and Custom Connector with Azure AD – Nishant Rana’s Weblog
Aug27

PowerApps – Secure your Azure Function and Custom Connector with Azure AD – Nishant Rana’s Weblog

In my previous blog, I explained how to create an Azure Function and consume it in PowerApps using custom connector but it was not secured (anonymous) and anyone can access this API using function URL. In this blog we will see how to secure Azure Function API and register PowerApps custom connector in Azure Active Directory. Below steps will be covered as part of this blog: Secure Azure Function with Azure AD App Registration for...

Read More
Power BI with Dynamics 365 CE – Dynamics 365 Content Pack – Nishant Rana’s Weblog
Aug24

Power BI with Dynamics 365 CE – Dynamics 365 Content Pack – Nishant Rana’s Weblog

In previous posts we covered Creating a Power BI Report using Dynamics 365 Online Service. Publishing it and Showing it inside Dynamics 365 and scheduling its Refresh. Apart from creating our own Power BI Report another way of quickly be up and running is to use the Content Packs provided by Third Party Service, for e.g. here we will be using Sales Analytics for Dynamics 365 content pack provided by Microsoft. Login to the Power BI...

Read More