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
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
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
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
In today’s connected business landscape, organizations rely on multiple Dynamics 365 applications to manage different business processes. Dynamics 365 Customer Engagement (CRM) is commonly used for managing customers, sales, and cases, while Dynamics 365 Finance & Operations (F&O) handles finance, supply chain, and operations. Often, users working in CRM need quick access to related records… Continue reading Creating Deep Links from Dynamics 365 CRM to Finance & Operations (F&O)
Problem Statement A growing enterprise needed to streamline its email data management. Email activity data, stored in the organization’s CRM system, was essential for compliance, customer service tracking, and business intelligence. However, they faced major challenges: Email data was only accessible through complex CRM APIs returning paginated JSON. There was no centralized repository for email… Continue reading Email Data Migration from CRM to SQL Server using Azure Data Factory
A revolutionary new workflow that saves time, money, and eliminates manual publishing—even for free users! Breaking Down the New Power BI Integration If you’re a Power BI user tired of the repetitive publish-save-republish cycle, there’s fantastic news. Microsoft has introduced a game-changing preview feature that directly connects Power BI Desktop with SharePoint Online and OneDrive… Continue reading Seamless Power BI Integration with SharePoint/OneDrive – No More Publish, No Paid License
Transitioning to the cloud is no longer optional for businesses—it’s a necessity to gain agility, scale, and cost savings. In the cloud, consistency and effective performance demands more than just a “lift and shift” of existing systems. Building cloud applications requires robust architectural principles. Here is the key to achieving this: Architect for Scale In… Continue reading Sound architectural principles required to ensure effective performance in the cloud
Introduction In the era of big data, transforming raw data into meaningful insights is crucial. Databricks, built on Apache Spark, provides a unified platform to perform ETL (Extract, Transform, Load) at scale. In this blog, we’ll explore what ETL is, how it works in Databricks, and walk through a hands-on practical example using a sample… Continue reading ETL in Databricks
Introduction Microsoft Dynamics 365 Business Central is a powerful ERP solution designed to improve efficiency across various business functions. Understanding your company’s financial health is crucial, and Microsoft Dynamics 365 Business Central has introduced new features in 2024 Released Wave 2 to help with this. The latest update includes new reports and demo data, making… Continue reading How to Use new reports and demo data for financial reporting in Microsoft Dynamics 365 Business Central
In today’s dynamic cloud environment, achieving a consistent and reliable IP address for your Azure Data Factory (ADF) is crucial for secure and seamless data integration processes. Utilizing a Self-Hosted Integration Runtime (SHIR) and an Azure Virtual Machine (VM) provides an effective solution to this requirement. This blog details the step-by-step process to achieve a… Continue reading How to Get a Static IP Address for Azure Data Factory Using Self-Hosted Integration Runtime and Azure Virtual Machine
Introduction Microsoft Dynamics 365 Business Central is a robust ERP solution that streamlines various business functions. A key feature in the 2024 Released Wave 2 update allows users to add detailed, customized information to project planning lines for items, resources, and general ledger accounts. This functionality enhances communication with customers, vendors, and employees by including… Continue reading How to Use Extended Text for Project Planning Lines in Microsoft Dynamics 365 Business Central
Businesses depend on databases to store and handle huge amounts of data in today’s data-driven world. One common problem is moving data from denormalized tables (like those in data centers) to normalized tables quickly and efficiently while making sure the data is organized in a way that makes it easy to use and fast to… Continue reading From De-normalized to Normalized: A Guide to Data Transformation with SSIS
Introduction Microsoft Dynamics 365 Business Central is a comprehensive ERP solution that enhances efficiency across various business functions. One of the key aspects of managing financial operations effectively is streamlining data entry. In the 2024 Released Wave 2 update, Business Central introduced a new feature that allows users to set default quantities for general ledger… Continue reading How to Use Default Quantity Settings for General Ledger Accounts in Microsoft Dynamics 365 Business Central
Introduction Microsoft Dynamics 365 Business Central is an all-in-one business management solution designed to streamline operations across various functions. Microsoft introduced a new feature in its 2024 update, Released Wave 2, that allows users to create purchase orders directly from project cards, ensuring that you have the necessary items to initiate or sustain a project… Continue reading How to Create Purchase Orders from Projects in Microsoft Dynamics 365 Business Central
Introduction: In the competitive landscape of retail, small stores rely heavily on sales data for decision-making and business growth. Recognizing the importance of timely and accurate data, small retail stores aim to automate the extraction of daily sales reports to streamline operations and enhance data accuracy. Automation is seen as a key factor in improving… Continue reading Streamlined Operations: Automated Extraction of Email Attachments with SSIS
Introduction: In today’s data-driven world, businesses rely on robust analytics platforms to extract valuable insights and make informed decisions. Among these platforms, Power BI stands out as a powerful tool that empowers organizations to visualize data, share insights, and drive business intelligence across all levels. However, embarking on the journey of setting up a Power… Continue reading Getting Started with Power BI: Building Your Analytics Foundation
Introduction: Microsoft Dynamics 365 Business Central is a robust Enterprise Resource Planning (ERP) solution that offers a range of features to enhance business operations. One key feature is the archiving capability for service documents, which enables organizations to maintain control over their service data through effective audit trails and version control. Business Value: The archiving… Continue reading How to Archive Service Documents in Microsoft Dynamics 365 Business Central
Data is the force of any company and without solutions in business intelligence offered by Microsoft, a business firm runs the risk of getting relegated in its respective industry. It means with exponential growth of data; organizations require tools which interpret heavy data. Microsoft Business Intelligence products transform unadulterated data into insight data that keeps… Continue reading Unlock the power of Microsoft Business Intelligence Software to drive decisions by data
Introduction Microsoft Dynamics 365 Business Central regularly updates its features to help businesses run more smoothly. One key update in the 2024 release Wave 1 makes it easier to track packages in your physical inventory orders. This new feature allows you to monitor inventory at the package level, which improves accuracy and gives you better… Continue reading How to Use Inventory package numbers work like item tracking dimensions in Microsoft Dynamics 365 Business Central
Microsoft has rolled out new themes and modern controls in Power Apps Canvas Apps, enhancing the app-building experience with a more interactive and polished user interface. These modern controls also come with expanded event support, reinforcing Power Apps’ commitment to low-code development. Key controls such as Button, Gallery, and Data Table have undergone major improvements.… Continue reading Exploring the New Themes and Controls in Power Apps Canvas
Introduction Managing invoices and shipments efficiently is crucial for business operations, and Microsoft Dynamics 365 Business Central has introduced a useful feature to help streamline this process. The new feature allows you to set policies for how service invoices are processed, accommodating various business needs and improving workflow efficiency. Business Value Different companies have different… Continue reading How to Use service invoice posting policy for various users in Microsoft Dynamics 365 Business Central
Introduction Microsoft Dynamics 365 Business Central offers a robust ERP solution with numerous features to enhance business operations. One such feature of 2024 released wave1 is the ability to simplify your invoicing process by consolidating multiple project invoicing into a single sales invoice. This capability reduces manual effort, minimizes errors, and improves overall invoicing accuracy.… Continue reading How to Invoice a Customer for Multiple Projects in MS Dynamics 365 Business Central
Introduction: In Power BI, users often find the need for spontaneous exploration of their data, particularly when gaining access to a new semantic model or data source. Whether it’s an analyst seeking to familiarize themselves with the dataset or a business user with a specific question requiring immediate answers for a presentation, the conventional approach… Continue reading Explore “This Data” of the Semantic Model ( on PBI Service)
Requirement: While migrating tables from one database to another, there is a possibility of invalid data being inserted into columns that are not supported by their respective column data types. Consequently, errors may arise on the source side when attempting to migrate such data to another database. The objective is to migrate tables from Oracle… Continue reading Dynamically change the data type of Oracle Db and Migrate the data from Oracle to SQL using ADF
Introduction Efficient management of service items, invoices, and other documents is vital for businesses, and Microsoft Dynamics 365 Business Central offers a robust numbering system to help streamline these processes. This system not only simplifies the identification and management of various documents but also enhances data accuracy and reduces errors. Understanding how to configure and… Continue reading How to Use the Numbering System for Service Items and Documents in Microsoft Dynamics 365 Business Central
Introduction Microsoft Dynamics 365 Business Central helps you manage your business documents effectively. A common challenge businesses face is accessing critical information from archived documents. A new feature of 2024 Released wave 1 of business central now lets you see incoming documents attached to your sales and purchase quotes and orders, even after they are… Continue reading How to View Incoming Documents After Archiving Sales and Purchase Quotes in MS Dynamics 365 Business Central
Introduction: Data analysis in Power BI is immensely powerful, and the Matrix visual is a dynamic tool that allows users to organize and analyze data efficiently. However, when it comes to date and month columns, arranging them in the desired order within the Matrix visual can pose a challenge. In this blog post, we’ll delve… Continue reading Sorting Date & Month Column by Descending in Power bi Matrix Visual
Introduction Managing multiline text can be challenging, especially when dealing with large amounts of data that need to be transferred between different companies or systems. Microsoft Dynamics 365 Business Central simplifies this process with an enhanced Configuration Packages feature, making it easy to export and import multiline text efficiently. Business Value This feature eliminates the… Continue reading How to Efficiently Handle Multiline Text with Configuration Packages in MS Dynamics 365 Business Central
Microsoft 365 Groups are a fundamental service that enables collaboration across various Microsoft 365 applications. These groups are essentially a collection of people with a common purpose, simplifying teamwork and communication within an organization. When a Microsoft 365 Group (formerly Office 365 Group) is created, whether through Microsoft Dynamics 365, Outlook, Teams, or SharePoint, several… Continue reading Microsoft 365 Groups
Power Automate to simply integrate with Dataverse API. In this blog you will get the process of making API calls to Dataverse. Dataverse database is easily accessible through app registration in Azure, providing a unique client ID and secret key. Integrating with Power Platform ensures seamless data access, particularly when granted system admin privileges. This… Continue reading Dataverse API Calls with Power Automate: A Step-by-Step Guide
Fetching Image Column from Dataverse Entity Using Portal API on Power Pages When fetching an image field from Dataverse using the Portal API, the default response provides only a thumbnail version of the image with dimensions 144px × 144px. This limitation prevents displaying the image in a larger viewport with good quality. Solution: Retrieving the… Continue reading Fetching High-Quality Images from Dataverse Image Field in Power Pages
Copilot Form Fill Assistance is an AI-powered feature in Microsoft Dynamics 365 (Model-driven apps) that helps users fill in data fields on forms by suggesting relevant values based on: Clipboard content Previously entered data Uploaded files or images (PDFs, Word docs, images) Email content It aims to save time and reduce data entry errors by… Continue reading Copilot Form Fill Assistance in D365 CRM
In today’s data-driven world, the ability to process data in real time is no longer a luxury—it’s a necessity. Whether you’re tracking website traffic, monitoring IoT sensors, or responding to financial market fluctuations, real-time analytics can give your organization a critical edge. With Eventstream in Microsoft Fabric, real-time data ingestion, transformation, and analytics have become… Continue reading Real-Time Data Processing with Eventstream in Microsoft Fabric
Introduction: Microsoft Dynamics 365 Business Central continues to evolve to meet the needs of businesses seeking improved service management. The 2024 Release Wave 2 introduces several enhancements that streamline workflows, improve tracking, and facilitate better communication for service-related tasks. Key updates include the addition of useful fields, simplified order processes, and more robust reporting options.… Continue reading Enhanced Usability for Service Management in Microsoft Dynamics 365 Business Central
© All Rights Reserved. Inkey IT Solutions Pvt. Ltd. 2026
