How to Avoid Document Number Errors When Posting Project Journals in Microsoft Dynamics 365 Business Central?
Inkey Solutions, June 12, 202633 Views
Introduction Posting project journals in Microsoft Dynamics 365 Business Central requires correct document numbering to ensure smooth transactions. If the document numbers in a journal are not in consecutive order, posting can fail, causing delays and additional corrections. The 2025 Released wave 1 update helps users avoid this issue by providing tools to automatically fix… Continue reading How to Avoid Document Number Errors When Posting Project Journals in Microsoft Dynamics 365 Business Central?
Read moreUse Edit in Excel on Output, Consumption, and Item Journals in Microsoft Dynamics 365 Business Central
Inkey Solutions, June 9, 202650 Views
Introduction: Microsoft Dynamics 365 Business Central continues to enhance its usability by expanding the Edit in Excel capability. With the 2025 Release Wave 1 update, users can now edit item tracking details directly in Excel for Item Journals, Consumption Journals, and Output Journals. This provides a simple way to handle bulk data entry, especially when… Continue reading Use Edit in Excel on Output, Consumption, and Item Journals in Microsoft Dynamics 365 Business Central
Read moreDesigning Scalable KPI Matrices in Power BI: Dynamic Row-Level Logic with Clean Architecture
Inkey Solutions, June 5, 202643 Views
A Scalable Approach for Handling Multiple KPIs with Independent Logic Introduction In Power BI, measures are designed to apply a single calculation logic within a given filter context. This works well for most reporting scenarios. However, challenges arise when a requirement demands a matrix visual where: Each row represents a different KPI Each KPI follows… Continue reading Designing Scalable KPI Matrices in Power BI: Dynamic Row-Level Logic with Clean Architecture
Read moreWrite Once, Reuse Everywhere: DAX UDFs in Power BI
Inkey Solutions, June 2, 202658 Views
Power BI’s DAX (Data Analysis Expressions) language has long been a cornerstone for creating dynamic calculations in data models. With the introduction of DAX User-Defined Functions (UDFs) in the September 2025 preview update, Power BI users can now create reusable, parameterized functions to streamline and enhance their analytics workflows. In this blog, we’ll explore what… Continue reading Write Once, Reuse Everywhere: DAX UDFs in Power BI
Read moreAutomatically Create Contacts for Customers, Vendors, and Bank Accounts in Business Central
Inkey Solutions, May 29, 202646 Views
Introduction Microsoft Dynamics 365 Business Central tightly integrates master data with its marketing and relationship management features. One built-in capability is the automatic creation of contact records when users create customers, vendors, or bank accounts. Many users notice this behavior but are unsure why it happens or where it can be controlled, as the option… Continue reading Automatically Create Contacts for Customers, Vendors, and Bank Accounts in Business Central
Read moreHow to Define Item Attributes for Item Variants in Microsoft Dynamics 365 Business Central?
Inkey Solutions, May 26, 202660 Views
Introduction In the latest updates of Microsoft Dynamics 365 Business Central (Release Wave 2026), Microsoft introduced improved functionality for managing item attributes at the variant level. This feature allows users to define and customize attributes—such as color, size, or material—for each item variant. It also ensures that variants automatically inherit attributes from the main item,… Continue reading How to Define Item Attributes for Item Variants in Microsoft Dynamics 365 Business Central?
Read moreNever Use an Outdated Report Again: Version Tracking in Power BI
Inkey Solutions, May 22, 202657 Views
Introduction In Power BI development, maintaining version control of reports is essential to ensure that all changes are applied to the latest version only. Without proper tracking, developers may unknowingly work on outdated reports, while stakeholders may end up reviewing or making decisions based on older Report, leading to inconsistencies and rework. To address this,… Continue reading Never Use an Outdated Report Again: Version Tracking in Power BI
Read moreFrom Prompt to Flow: Generating Power Automate Workflows Using AI
Inkey Solutions, May 19, 202667 Views
Problem Statement Creating flows in Microsoft Power Automate using the traditional approach can take a lot of time. Developers need to manually find connectors, configure conditions, write expressions, and test the flow multiple times to make sure it works correctly. With the new AI prompt feature, developers can simply describe their automation requirement in natural… Continue reading From Prompt to Flow: Generating Power Automate Workflows Using AI
Read moreGenerating PDF/Excel, or SSRS Reports for Selected Records Using Power Automate in Dynamics 365
Inkey Solutions, May 15, 202672 Views
When you’re working with reports in Microsoft Dynamics 365, one common challenge is generating SSRS reports for only selected records. Out-of-the-box capabilities often require predefined filters or manual effort, making the process inefficient for dynamic business needs. This is where Power Automate steps in to bridge the gap. By combining Power Automate with SSRS, you… Continue reading Generating PDF/Excel, or SSRS Reports for Selected Records Using Power Automate in Dynamics 365
Read moreCreating an automated Language Translator in Power Apps Using AI Builder
Inkey Solutions, May 12, 202678 Views
In multilingual business environments, data consistency is one of the most underestimated challenges. When users work across languages, especially CRM and business apps, manual translation quickly becomes a bottleneck, introducing inconsistencies, user fatigue, and data quality issues. This blog will walk you through a real-world Canvas App solution that uses AI Builder’s prompt-based translation to… Continue reading Creating an automated Language Translator in Power Apps Using AI Builder
Read moreHow to Combine Service Shipments into a Single Invoice in Microsoft Dynamics 365 Business Central
Inkey Solutions, May 8, 202675 Views
Introduction: Microsoft Dynamics 365 Business Central is constantly improving as an all-in-one business management solution. With the 2025 Release Wave 1 update, Microsoft has introduced a powerful new feature that brings service and sales invoicing workflows even closer. This feature, called Combine Service Shipment, allows users to consolidate multiple un-invoiced service shipments into one or… Continue reading How to Combine Service Shipments into a Single Invoice in Microsoft Dynamics 365 Business Central
Read morePower BI Web API Integration with Bearer Token & Refresh Configuration
Inkey Solutions, May 5, 2026158 Views
Introduction Power BI provides robust capabilities to integrate external data sources, including REST APIs, through Power Query. This enables organizations to bring real-time or near-real-time data into their reporting layer for enhanced decision-making. In enterprise scenarios, APIs often require secure authentication mechanisms such as Bearer Tokens, along with structured request handling large datasets through pagination.… Continue reading Power BI Web API Integration with Bearer Token & Refresh Configuration
Read moreHiding Sales Order Agent and Payables Agent Icons in Microsoft Dynamics 365 Business Central
Inkey Solutions, May 1, 202672 Views
Introduction: Microsoft Dynamics 365 Business Central continues to evolve by introducing new AI-driven capabilities that simplify business operations and enhance automation. With the addition of Copilot and Agent capabilities, Microsoft has introduced intelligent assistants like the Sales Order Agent and Payables Agent to help automate routine business tasks. While these agents offer significant value, not… Continue reading Hiding Sales Order Agent and Payables Agent Icons in Microsoft Dynamics 365 Business Central
Read more🚀 End-to-End Guide: Building a Fivetran Custom Connector (Keap → BigQuery)
Inkey Solutions, April 28, 2026117 Views
1. Introduction In today’s data-driven world, businesses rely heavily on automated data pipelines. While Fivetran provides many pre-built connectors, there are scenarios where your data source is simply not supported out-of-the-box. That’s where Fivetran Custom Connectors (Connector SDK) come into play. This guide is based on a real-world implementation: Keap API → BigQuery. In… Continue reading 🚀 End-to-End Guide: Building a Fivetran Custom Connector (Keap → BigQuery)
Read moreHow to Efficiently Use Deferral Codes in Sales and Purchase Journals in MS Dynamics 365 Business Central
Inkey Solutions, April 24, 2026137 Views
Introduction Entering sales and purchase journals often involves transactions that require deferrals. In New Released 2024 Wave 2 updates Microsoft Dynamics 365 Business Central now simplifies this process by allowing users to specify a Deferral Code directly on sales and purchase journal lines. This eliminates the need to create a separate general journal for deferrals,… Continue reading How to Efficiently Use Deferral Codes in Sales and Purchase Journals in MS Dynamics 365 Business Central
Read moreHow to Use standard terminology for project management in Microsoft Dynamics 365 Business Central
Inkey Solutions, April 21, 2026112 Views
Introduction: We’re excited to share an important update aimed at improving your experience with project accounting in Microsoft Dynamics 365 Business Central. We are updating the terminology we use for project accounting features. Specifically, we’re replacing the term “jobs” with “projects”. This change is designed to enhance clarity, improve documentation, and ensure consistency throughout the… Continue reading How to Use standard terminology for project management in Microsoft Dynamics 365 Business Central
Read moreHow to Manage Document Attachments from Customer to Service Order in Service Management in Microsoft Dynamics 365 Business Central?
Inkey Solutions, April 17, 2026152 Views
Introduction Managing important documents is crucial for service operations. Microsoft Dynamics 365 Business Central 2024 update Released Wave 1 now let’s user attach essential documents—like maintenance manuals and warranty certificates—directly to service items, contracts, and invoices. This makes it easier to access important information on the go, improving service delivery. Business Value By digitizing document… Continue reading How to Manage Document Attachments from Customer to Service Order in Service Management in Microsoft Dynamics 365 Business Central?
Read morePower BI Matrix: Remove Bold Row Headers & Achieve Table-Like Formatting Without Losing Drill-Down
Inkey Solutions, April 14, 2026314 Views
Problem Statement In Power BI’s Matrix visual, adding multiple fields to the Rows section causes parent row headers to appear bold by default — only the lowest drill-down level renders in normal weight. This creates a hierarchical tree-like appearance that conflicts with client expectations for a clean, uniform table view, even though drill-down functionality must… Continue reading Power BI Matrix: Remove Bold Row Headers & Achieve Table-Like Formatting Without Losing Drill-Down
Read moreHow to Resize Columns in Microsoft Dynamics 365 Business Central Without Personalization?
Inkey Solutions, April 10, 2026137 Views
Introduction Microsoft Dynamics 365 Business Central continues to improve user experience by offering greater flexibility in working with data. With the 2024 Release Wave 2, users can now resize columns in list pages even when personalization is disabled. This makes it easier to view, compare, and enter data efficiently without relying on UI customization. Business… Continue reading How to Resize Columns in Microsoft Dynamics 365 Business Central Without Personalization?
Read moreDynamic Rating Sentences in Power BI
Inkey Solutions, April 7, 2026411 Views
Introduction In many Power BI reports, especially those capturing user feedback or survey responses, you may want to display a contextual sentence that reflects a given rating — something more human and insightful than just a number on a scale. But showing the same sentence, every time can feel repetitive. What if the report could… Continue reading Dynamic Rating Sentences in Power BI
Read moreGenerating QR Code via a direct API call
Inkey Solutions, April 3, 2026132 Views
Problem Statement Power Apps does not have a built-in feature to generate QR codes. Because of this, creating QR codes from text or URLs inside the app becomes difficult and usually requires additional setup like connectors. Please follow the steps below to generate QR codes directly within Power Apps. Step 1: Create a Blank… Continue reading Generating QR Code via a direct API call
Read moreHow to Use Print Function in Canvas App
Inkey Solutions, March 31, 2026177 Views
Problem Statement: Developers working with Power Apps in Dynamics 365 CRM often need to generate printable outputs such as reports, forms, or records. The following steps will guide you on how to use the Print() function to print screens or create print-friendly content from your app. Solution Steps: Create a sample canvas app and add… Continue reading How to Use Print Function in Canvas App
Read moreHow to Use Modern Search in Lists in Microsoft Dynamics 365 Business Central
Inkey Solutions, March 27, 2026226 Views
Introduction: Microsoft Dynamics 365 Business Central continues to enhance user productivity with each release. With the 2024 Release Wave 2 update, a powerful new feature has been introduced—Modern Search in Lists. This feature provides a faster and more accurate way to search within list pages by focusing only on columns that are optimized for full-text… Continue reading How to Use Modern Search in Lists in Microsoft Dynamics 365 Business Central
Read moreWhy Microsoft Fabric Dataflow Loads Partial Data When Triggered from Pipeline (But Works on Rerun)
Inkey Solutions, March 17, 2026187 Views
Introduction If you are working with Microsoft Fabric Dataflow Gen2 triggered through a Pipeline, you might encounter a confusing scenario: The first pipeline run loads only partial data The Dataflow shows success There are no errors When you rerun the Dataflow (manually or via pipeline), it loads complete data correctly This behavior can be frustrating… Continue reading Why Microsoft Fabric Dataflow Loads Partial Data When Triggered from Pipeline (But Works on Rerun)
Read moreTurning a Matrix Visual into a Calendar View in Power BI
Inkey Solutions, March 13, 2026187 Views
Introduction In Power BI, there is no out-of-the-box calendar visual available by default. To build calendar-style views, users often have to rely on external or custom visuals. While some of these visuals can be useful, not all are Microsoft-certified, and many come with limitations such as restricted functionality or additional licensing costs. This can raise… Continue reading Turning a Matrix Visual into a Calendar View in Power BI
Read moreAlternative way of Navigation for Power BI’s Table Visuals Using Pagination
Inkey Solutions, March 10, 2026509 Views
Introduction In many Power BI reports, table visuals are often designed with scroll bars, even when the amount of data being displayed is relatively small. To fit tables within limited report space, scrolling becomes the default interaction, requiring users to move up and down just to view the complete set of records. Table pagination provides… Continue reading Alternative way of Navigation for Power BI’s Table Visuals Using Pagination
Read moreHow to Block Items or Variants from Service Transactions in Microsoft Dynamics 365 Business Central?
Inkey Solutions, March 6, 2026127 Views
Introduction Managing service transactions efficiently is crucial for maintaining smooth service operations. With the latest Released 2024 Wave 1 updates in Microsoft Dynamics 365 Business Central, users can now block certain items, item variants, or service items from being used in service transactions. This helps prevent discontinued, limited-stock, or contractually restricted items from being used… Continue reading How to Block Items or Variants from Service Transactions in Microsoft Dynamics 365 Business Central?
Read moreFull load and Incremental load in Microsoft Fabric
Inkey Solutions, March 3, 2026234 Views
In any data platform, especially in Microsoft Fabric, which provides a unified analytics environment across Data Engineering, Data Factory, Data Warehousing, and Power BI, loading data efficiently is crucial to ensure performance, cost-effectiveness, and data accuracy. Two common data loading techniques are: Full Load Incremental Load Let’s explore what they are, when to use each other, and how to… Continue reading Full load and Incremental load in Microsoft Fabric
Read moreDesign Smarter Power BI Matrices with Conditional Formatting for Row and Column Totals
Inkey Solutions, February 24, 2026541 Views
Introduction: The Resource Allocation Challenge in IT Effective resource planning is vital for IT project success, but over-allocating team members or under-allocating projects often creates unnoticed bottlenecks. Traditional project management tools display matrix-style reports but lack visual cues to highlight imbalances. This blog explores how Power BI’s matrix visuals, enhanced with DAX-based conditional formatting, empower project managers… Continue reading Design Smarter Power BI Matrices with Conditional Formatting for Row and Column Totals
Read moreSolving Data Access Limitations in Power BI Using Service Principal and Cloud Connection
Inkey Solutions, February 20, 2026183 Views
Overview Power BI’s default behavior—respecting CRM security roles via OAuth—works well when users should see only their own data. But what happens when a report needs to show everything, and changing CRM permissions isn’t an option? We faced this exact challenge: stakeholders needed a report with full visibility into a CRM table, but their access… Continue reading Solving Data Access Limitations in Power BI Using Service Principal and Cloud Connection
Read moreDeployment Pipelines in MS Fabric
Inkey Solutions, February 17, 2026493 Views
Microsoft Fabric’s deployment pipelines tool provides developers with a production environment where they can collaborate with others to manage the lifecycle of organizational content. Deployment pipelines enable creators to develop and test content in the service before it reaches the users. When you deploy content from one pipeline stage to another, there are limited items… Continue reading Deployment Pipelines in MS Fabric
Read moreDynamics GP to Business Central in 2026
Inkey Solutions, February 13, 2026238 Views
Turning End of Life Into a Smart Growth Opportunity This article is intended for finance leaders, IT managers, and Dynamics GP users planning their ERP roadmap. Microsoft Dynamics GP has been a dependable system for many organizations. It is stable, familiar, and deeply embedded in finance operations. That reliability is exactly why many businesses continue… Continue reading Dynamics GP to Business Central in 2026
Read moreThe Ultimate Guide to Microsoft Fabric Variable Libraries
Inkey Solutions, February 10, 2026542 Views
Centralize configuration, automate deployments, and master the “Value Set” workflow in Microsoft Fabric. If you have built data pipelines in Azure Data Factory (ADF) or Synapse, you know the pain of “Configuration Drift.” You hardcode a path like raw/sales_data in development, but when you deploy to production, you have to manually find and replace it… Continue reading The Ultimate Guide to Microsoft Fabric Variable Libraries
Read moreHow To Download SharePoint List Attachment Without Power Automate in Canvas App or Custom Page
Inkey Solutions, February 6, 2026242 Views
Downloading Attachments from a SharePoint List Record We have created a SharePoint list where we added two records, each containing attached files. To download different types of files from SharePoint list attachments without using Power Automate, we use the Out-of-the-Box (OOB) Download function. The Download function requires the URL path of the file. Since the… Continue reading How To Download SharePoint List Attachment Without Power Automate in Canvas App or Custom Page
Read moreDesigning a Seamless User Journey with Multistep Forms
Inkey Solutions, February 3, 2026460 Views
Power Pages provides a very important feature called the Multistep Form. This feature allows you to break down complex processes into step-by-step validations on a single page. It uses out-of-the-box (OOB) forms and Dataverse tables to guide users through each stage of the process. The multistep form acts like a series of steps or stages… Continue reading Designing a Seamless User Journey with Multistep Forms
Read moreCreating Basic Forms in Power Pages: A Beginner’s Guide
Inkey Solutions, January 30, 2026573 Views
Power Pages offers a Basic Form feature that supports low-code/no-code development, making it easier for users to interact with data from the Dataverse. A Basic Form allows users to create, read, and update records in a Dataverse table through a user-friendly interface on the portal. These forms are directly connected to Dataverse tables and always… Continue reading Creating Basic Forms in Power Pages: A Beginner’s Guide
Read moreDesigning the Perfect List with Best Practices for Displaying Dataverse Data
Inkey Solutions, January 27, 2026477 Views
Power Pages List is a data display UI component that connects to a Dataverse table in Dynamics 365. It displays data using views defined in Dataverse, allowing users to see multiple columns of real-time data. With Lists, you can apply filters based on conditions or the logged-in user. Additionally, standard out-of-the-box (OOB) functionality enables users… Continue reading Designing the Perfect List with Best Practices for Displaying Dataverse Data
Read moreReusable Content Made Easy – Power Pages Content Snippets Guide
Inkey Solutions, January 23, 2026258 Views
Content Snippet is a global content declaration component in Power Pages that allows developers to manage and reuse content efficiently across the website. Snippets can be used in header, footer, webpages, and web templates. Developers can also insert content snippets using Liquid code, making it flexible and dynamic. Why Use Content Snippets? Developers need to… Continue reading Reusable Content Made Easy – Power Pages Content Snippets Guide
Read moreLevel Up Your Basic Forms with Metadata and JavaScript Customization in Power Pages
Inkey Solutions, January 20, 2026333 Views
Power Pages basic forms are used to connect with a single Dataverse table. They allow users to create, update, and view records directly within the site. Basic forms are mostly embedded with lists to perform CRUD (Create, Read, Update, Delete) operations on Dataverse tables. Form Action Button Configuration Under Additional Settings of a basic… Continue reading Level Up Your Basic Forms with Metadata and JavaScript Customization in Power Pages
Read morePower Pages – New Feature with Cloud Flow Integration in Setup Navigation
Inkey Solutions, January 9, 2026299 Views
Microsoft Power Pages has introduced a new feature that allows you to create Cloud Flows (Power Automate Flows) directly from the Power Pages Designer Studio under the Setup navigation. This enhancement simplifies the process of integrating automation into your portal. With this feature: Cloud Flows can now be created and managed directly within Power Pages,… Continue reading Power Pages – New Feature with Cloud Flow Integration in Setup Navigation
Read more
