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.
Power BI > How to deal with a Text column having a length of more than 32766 characters.
Inkey, April 1, 202216605 Views
Power BI supports up to 32766 characters of data in a column of TEXT Data Type. What if we have more data stored in the data source? Recently, we came across a requirement where we had to show the content of an email in HTML format in the Power BI report. The report was built […]
Read moreBusiness Central latest updates 2022 release Wave 1
Inkey, March 24, 20221490 Views
Here are some interesting new updates in the latest release for Business Central Blocking deletion of G/L accounts This new feature is going to be introduced to help avoid accidental deletion of general ledger (G/L) accounts, this release wave adds an extra check. An extra safeguard against accidental deletion of G/L accounts even in the […]
Read moreAccess SharePoint Online Data Using Postman Part 2
Inkey, March 11, 20223715 Views
Now, in this blog we will see how to access SharePoint online data. In this example, we will resize SharePoint Online image by using the Microsoft Graph API via SharePoint using the /_api/v2.0. We need to specify the size; large, small, and medium; in the request URL to resize the image that would give us […]
Read moreSet Default Font style and Size of Email in Dynamics 365 Sales
Inkey, February 23, 202210651 Views
In this blog we will see how we can set default font style and font size for the Email records in Dynamics 365 Sales. To achieve this, we need to follow the steps below: Create a new web resource Bind the new Web resource to the required email form where the changes need to be […]
Read morePower BI > Using slicer for just highlighting values without filtering
Inkey, December 20, 20218776 Views
The general purpose of slicer visual in Power BI is to filter the data points in the report and view only the filtered information. They provide options (single or multiple) to a user, to click on & filter the visuals on the page. Recently, in one of our projects, we were tasked with a requirement to highlight the bars of a bar chart instead of filtering the visual based on the selected value of the slicer. It sounded odd at first […]
Read morePower BI > Drill-through feature from Card visual
Inkey, November 19, 202116325 Views
In Power BI, a drill–through feature permits the report consumer to peer detailed facts associated with the primary page in the context of a particular data point applied. With drill via Power BI reports, one can create a detailed report page on your data that focuses on a particular applied data point. When the readers want to analyze a particular record or data […]
Read moreDynamics 365 Sales data import. Anomalous materials and unforeseen consequences
Inkey, October 28, 20211022 Views
We all have imported data into CRM at some point in our life. And a part of the process of importing data is cleaning up the data the is to be imported. I am sure almost all of us have encountered some unusual data that we had to clean up and some unusual data that looks […]
Read morePower BI > How to filter all the data by TODAY, by default?
Inkey, September 10, 202118639 Views
Ever wondered how we can filter the Power BI report to show only Today’s data by default but at the same time give the flexibility to change the Date filter? The approach we as developers generally take is – create a calculated column IsToday in the Calendar table and have it return “Yes” for today’s […]
Read moreLoad metadata of all entities and get Object Type Code based on Entity name in Dynamics 365 for Sales.
Inkey, August 12, 20213769 Views
In this blog I’ll be taking you over how to get the Object type Code for the particular entity based on the Entity name. Suppose we need to get object type code for different entities in a loop in an stand alone .Net application. Generally, people are writing a fetch into the loop but not […]
Read moreUpdating the SQL DataSource from Power BI using Power Automate Visual
Inkey, August 6, 20216152 Views
Ever thought of manipulating the data in your SQL data source directly from the Power BI Report? If yes, our prayers have been heard (as the use of Power Automate within Power BI is still in Preview as of writing this blog) and will be answered soon (when made GA)! An exciting new feature was […]
Read more