Power Pages – New Feature with Cloud Flow Integration in Setup Navigation
Inkey Solutions, January 9, 202681 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, 202670 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, 2026208 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, 202567 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, 202567 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, 2025110 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, 2025149 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, 202585 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, 202590 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, 2025140 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 moreCreating Deep Links from Dynamics 365 CRM to Finance & Operations (F&O)
Inkey Solutions, November 28, 2025128 Views
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)
Read moreEmail Data Migration from CRM to SQL Server using Azure Data Factory
Inkey Solutions, November 25, 202592 Views
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
Read moreSeamless Power BI Integration with SharePoint/OneDrive – No More Publish, No Paid License
Inkey Solutions, November 14, 2025173 Views
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
Read moreSound architectural principles required to ensure effective performance in the cloud
Inkey Solutions, November 11, 202581 Views
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
Read moreETL in Databricks
Inkey Solutions, November 7, 202585 Views
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
Read moreHow to Use new reports and demo data for financial reporting in Microsoft Dynamics 365 Business Central
Inkey Solutions, November 4, 2025184 Views
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
Read moreHow to Get a Static IP Address for Azure Data Factory Using Self-Hosted Integration Runtime and Azure Virtual Machine
Inkey Solutions, October 31, 2025209 Views
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
Read moreHow to Use Extended Text for Project Planning Lines in Microsoft Dynamics 365 Business Central
Inkey Solutions, October 28, 2025131 Views
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
Read moreFrom De-normalized to Normalized: A Guide to Data Transformation with SSIS
Inkey Solutions, October 24, 202597 Views
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
Read moreHow to Use Default Quantity Settings for General Ledger Accounts in Microsoft Dynamics 365 Business Central
Inkey Solutions, October 20, 2025120 Views
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
Read moreHow to Create Purchase Orders from Projects in Microsoft Dynamics 365 Business Central
Inkey Solutions, October 17, 2025168 Views
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
Read moreStreamlined Operations: Automated Extraction of Email Attachments with SSIS
Inkey Solutions, October 14, 202587 Views
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
Read moreGetting Started with Power BI: Building Your Analytics Foundation
Inkey Solutions, October 10, 2025156 Views
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
Read moreHow to Archive Service Documents in Microsoft Dynamics 365 Business Central
Inkey Solutions, October 7, 202598 Views
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
Read moreUnlock the power of Microsoft Business Intelligence Software to drive decisions by data
Inkey Solutions, October 3, 202589 Views
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
Read moreHow to Use Inventory package numbers work like item tracking dimensions in Microsoft Dynamics 365 Business Central
Inkey Solutions, September 30, 2025173 Views
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
Read moreHow to Specify Default Location and Bin Codes for Projects in Microsoft Dynamics 365 Business Central
WebSiteAdmin, September 26, 2025201 Views
Introduction Microsoft Dynamics 365 Business Central is a comprehensive Enterprise Resource Planning (ERP) solution that streamlines various business processes. One notable feature of 2024 wave1 is the ability to specify default location and bin codes for projects. This functionality significantly reduces time spent on data entry, allowing users to focus more on their core tasks,… Continue reading How to Specify Default Location and Bin Codes for Projects in Microsoft Dynamics 365 Business Central
Read moreExploring the New Themes and Controls in Power Apps Canvas
Inkey Solutions, September 12, 20251037 Views
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
Read moreHow to Use service invoice posting policy for various users in Microsoft Dynamics 365 Business Central
Inkey Solutions, September 9, 2025730 Views
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
Read moreHow to Invoice a Customer for Multiple Projects in MS Dynamics 365 Business Central
Inkey Solutions, August 29, 2025829 Views
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
Read moreExplore “This Data” of the Semantic Model ( on PBI Service)
Inkey Solutions, August 26, 2025902 Views
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)
Read moreDynamically change the data type of Oracle Db and Migrate the data from Oracle to SQL using ADF
Inkey Solutions, August 22, 2025871 Views
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
Read moreHow to Use the Numbering System for Service Items and Documents in Microsoft Dynamics 365 Business Central
Inkey Solutions, August 19, 2025945 Views
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
Read moreHow to View Incoming Documents After Archiving Sales and Purchase Quotes in MS Dynamics 365 Business Central
Inkey Solutions, August 8, 20251035 Views
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
Read moreSorting Date & Month Column by Descending in Power bi Matrix Visual
Inkey Solutions, August 5, 2025786 Views
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
Read moreHow to Efficiently Handle Multiline Text with Configuration Packages in MS Dynamics 365 Business Central
Inkey Solutions, July 29, 2025598 Views
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
Read moreMicrosoft 365 Groups
Inkey Solutions, July 25, 2025476 Views
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
Read moreDataverse API Calls with Power Automate: A Step-by-Step Guide
Inkey Solutions, July 22, 20251359 Views
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
Read moreFetching High-Quality Images from Dataverse Image Field in Power Pages
Inkey Solutions, July 15, 2025749 Views
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
Read moreCopilot Form Fill Assistance in D365 CRM
Inkey Solutions, July 11, 2025716 Views
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
Read more
