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
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
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
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
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
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
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
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)
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
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
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?Â
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
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?
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
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
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
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
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)
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
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
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?
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Â
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Â
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
© All Rights Reserved. Inkey IT Solutions Pvt. Ltd. 2026
