Creating an automated Language Translator in Power Apps Using AI Builder
Inkey Solutions, May 12, 202630 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, 202635 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, 202665 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, 202640 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, 202653 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, 2026106 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, 202676 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, 2026117 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, 2026235 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, 2026104 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, 2026377 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, 2026102 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, 2026144 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, 2026194 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, 2026147 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, 2026151 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, 2026454 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, 202696 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, 2026182 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, 2026497 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, 2026152 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, 2026441 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, 2026204 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, 2026448 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, 2026207 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, 2026435 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, 2026519 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, 2026454 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, 2026220 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, 2026285 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, 2026269 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 moreHow to Use FetchXML in Web Page Templates in Power Pages
Inkey Solutions, January 6, 2026294 Views
Power Pages allow us to retrieve data from Dataverse tables using FetchXML with filtering capabilities. With FetchXML, you can retrieve data from single or multiple related tables, including many-to-many (N:N) relationships. This makes it a powerful and flexible tool for querying Dataverse directly from your portal. Key Highlights: FetchXML supports filter conditions, joins, and aggregation.… Continue reading How to Use FetchXML in Web Page Templates in Power Pages
Read moreHow to Create Your First PowerApps Component Framework (PCF) Control Using VS Code
Inkey Solutions, January 2, 2026438 Views
PCF (PowerApps Component Framework) is a special feature or custom element that can be added to Microsoft PowerApps. PowerApps is a platform for building custom business applications. Developers can build their own extra features/controls/elements using web technologies. The PCF controls can be created using multiple languages i.e. TypeScript, React, Node.js, CSS and HTML. To… Continue reading How to Create Your First PowerApps Component Framework (PCF) Control Using VS Code
Read moreAI Agent vs Agentic AI vs Generative AI: Understanding the Next Wave of Intelligence
Inkey Solutions, December 30, 2025469 Views
Artificial Intelligence has evolved rapidly from simple rule-based systems to generative and autonomous agents capable of reasoning, planning, and executing complex tasks. However, with the increasing buzzwords like AI Agent, Agentic AI, and Generative AI, it can be confusing to differentiate between them. This article explains what each term means, how they relate to one… Continue reading AI Agent vs Agentic AI vs Generative AI: Understanding the Next Wave of Intelligence
Read moreThe ‘not()’ Expression in Power Automate’s Filter Array for Dynamics 365
Inkey Solutions, December 26, 2025241 Views
When you’re building flows in Power Automate, the Filter Array action is one of the most powerful tools in your arsenal for refining data. It allows you to sift through a collection of items and keep only the ones that meet your specific criteria. While most users are familiar with basic operators like equals or… Continue reading The ‘not()’ Expression in Power Automate’s Filter Array for Dynamics 365
Read moreError Handling Framework in Microsoft Fabric: Design, Logging & Alerts
Inkey Solutions, December 23, 2025419 Views
Introduction In modern data engineering workflows, reliable pipeline execution is crucial for maintaining data integrity and trust. Microsoft Fabric, with its powerful integration and orchestration capabilities, provides robust mechanisms for building such pipelines. However, without a structured error handling and logging system, failures can go unnoticed or become difficult to debug. This blog walks through… Continue reading Error Handling Framework in Microsoft Fabric: Design, Logging & Alerts
Read moreNavigating the Azure Data Ecosystem: When to Use Databricks vs. Azure Data Factory
Inkey Solutions, December 16, 2025288 Views
In the realm of data engineering and analytics, choosing the right tools can make or break your project. Azure offers two powerful options: Databricks and Azure Data Factory (ADF). While both are incredibly robust, they serve different purposes and are suited to different scenarios. In this blog, I’ll dive deep into when to use Databricks… Continue reading Navigating the Azure Data Ecosystem: When to Use Databricks vs. Azure Data Factory
Read moreMicrosoft Fabric’s Bronze-Silver-Gold Pattern: Real-World Implementation Guide
Inkey Solutions, December 12, 2025240 Views
Microsoft Fabric empowers modern data teams by offering a unified platform to build scalable and organized data pipelines. A foundational design pattern within Fabric’s ecosystem is the Bronze-Silver-Gold data architecture. This layered approach simplifies data flow management, supports modular transformation, and enables consistent delivery of trusted insights across the organization. In this blog, we’ll explore… Continue reading Microsoft Fabric’s Bronze-Silver-Gold Pattern: Real-World Implementation Guide
Read moreHigh Concurrency Session in Notebooks
Inkey Solutions, December 9, 2025258 Views
In today’s fast-paced data-driven world, real-time collaboration and efficient processing are essential. As more data engineers, analysts, and scientists work on shared platforms, the need for scalable and concurrent computing environments has never been more critical. That’s where High Concurrency Sessions in Notebooks step in. Whether you’re using Microsoft Fabric, Databricks, Azure Synapse, or Jupyter-based… Continue reading High Concurrency Session in Notebooks
Read moreData Migration: SSIS to Fabric Warehouse Using API as Source
Inkey Solutions, December 5, 2025664 Views
In today’s data-centric world, organizations rely heavily on seamless data flow across platforms. When migrating to Microsoft’s modern Fabric Warehouse, leveraging SSIS (SQL Server Integration Services) for ETL remains a powerful solution, especially when working with diverse data sources like APIs. This blog walks you through the complete step-by-step process of migrating data from an… Continue reading Data Migration: SSIS to Fabric Warehouse Using API as Source
Read more
