Author: InkeyINKEY is your solution partner.
Our focus is to deliver you in-time intelligent innovative solutions ("key") for the problems in hand. Maintaining a quality standard right from the inception of a project is our top most priority.
Our team of talented professionals will execute your projects with dedication and excellence. We take ownership and accountability for the effort that goes into meeting our client’s needs.
Years of experience and proven success of delivering innovative custom solutions.
Connection to Dynamics 365 and SharePoint Authentication Using ClientId & ClientSecret: Part 1
Inkey, January 8, 20214408 Views
I have come across various requirements from clients where it was more feasible to go with creating the C# console application for bulk processing the records in D365 CRM based on complex scenarios like updating the closed case entity records or uploading the files to SharePoint at specific location, or any scenarios that needed custom […]
Read moreImport data into Dataverse(CDS): Part 3
Inkey, December 4, 20201892 Views
In the previous blogs, we saw how to import data into Dataverse(CDS) using Excel here and Dataflow here. In this blog we will use a .NET console application to upload data from SharePoint file to Dataverse(CDS). We will need to create SharePoint Document Locations in Common Data Service. Here are the steps. InsertDataToDataverse : This method […]
Read morePower BI > How to make PBI Reports pointing to deleted Power BI Dataset working again?
Inkey, November 26, 20206068 Views
Recently, we had come across an issue which we thought is very common and is easily resolvable. But, we were highly mistaken. We had several reports which were using a shared Power BI Dataset. We accidentally deleted the dataset on Power BI Service. Naturally, it deleted all the other reports pointing to this dataset. The […]
Read moreImport data into Dataverse(CDS): Part 2
Inkey, October 16, 20203920 Views
In our previous blog, we saw how to import data into a Dataverse(CDS) environment using Get data from Excel option. In this blog, let’s check out another slightly different method. This time we are going to use Dataflows. If you want to know what dataflow is, you can check it out here. Let’s begin. First […]
Read morePower BI > How to handle multiple time zones?
Inkey, September 18, 20207447 Views
We have often encountered requirements that need the date and time columns to change according to the timezones of the user. Conversion according to the timezone requires to add/subtract the offset hours to the DateTime field in UTC. As this is something that is not available in Power BI out-of-box, we have found an approach […]
Read morePower BI > How to efficiently change the column names?
Inkey, September 11, 20206001 Views
While preparing our Data Model, we are often tasked to change the column names of the tables which are brought into Power BI using GetData. It is very time consuming if we change the names of each column of all the tables manually but it is equally important. The time & efforts seem futile when […]
Read moreShow OneNote IN Dynamics 365 UCI
Inkey, September 11, 20203165 Views
Recently, I got a case where I need to show uploaded OneNote in Dynamics 365’s UCI in activity tab. In this blog we will discuss below two points: How to turn on OneNote Integration How to see uploaded OneNote in Dynamics 365 UCI Let’s start with first point: How to turn on OneNote Integration Go […]
Read morePower BI > Use of ISINSCOPE()
Inkey, August 28, 20208808 Views
Power BI has advanced incredibly in the last few years. Microsoft has been working their fingers to the bone to make Power BI simple to use and easily adaptable. But at times, it gives us hard time to achieve even the simplest of requirements, or at least we think so. Recently, I faced one such […]
Read moreProvide easy access to a queue for current user
Inkey, August 26, 20202855 Views
Recently, we got a requirement which required us to easily allow a user to access their queue. After a descent amount of struggle, we finally found a way which would allow a user to see their queue without fumbling in the menu or advanced find option. So, here is what we did. Lets start. Open […]
Read moreCharts in PowerApps
Inkey, August 14, 20208192 Views
In our previous blog we have learnt embedding of Power BI tiles in PowerApps. Now, in this blog we’ll learn Charts in PowerApps. Charts are used for graphical representation of data. It can usually be read more quickly than the raw data. In PowerApps there are below types of charts: Column Chart – A column […]
Read more
