Microsoft Fabric’s Bronze-Silver-Gold Pattern: Real-World Implementation Guide
Inkey Solutions, December 12, 2025252 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, 2025270 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, 2025681 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, 2025611 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, 2025419 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, 20251977 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, 2025211 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, 2025339 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, 2025319 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, 2025514 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, 2025320 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, 2025251 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, 2025271 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, 2025437 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, 2025227 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, 2025360 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, 2025291 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, 2025217 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, 2025342 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, 2025362 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, 20251435 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, 2025891 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, 2025986 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, 20251088 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, 20251013 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, 20251123 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, 20251235 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, 20251066 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, 2025741 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, 2025599 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, 20252212 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, 2025973 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, 2025931 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 moreReal-Time Data Processing with Eventstream in Microsoft Fabric
Inkey Solutions, July 8, 20253616 Views
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
Read moreEnhanced Usability for Service Management in Microsoft Dynamics 365 Business Central
Inkey Solutions, July 4, 2025604 Views
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
Read moreParameter Binding with DirectQuery in Power BI
Inkey Solutions, June 27, 20253348 Views
The Problem When working with large volumes of data in Power BI using Import mode, you may encounter long refresh times, frequent timeout errors, and sluggish performance during “Close & Apply” operations in Power Query. These issues become more prominent as the dataset grows, making it difficult to maintain responsiveness and efficiency in the report… Continue reading Parameter Binding with DirectQuery in Power BI
Read moreEnhanced Usability for Projects in Microsoft Dynamics 365 Business Central
Inkey Solutions, June 24, 2025615 Views
Introduction Microsoft Dynamics 365 Business Central continues to enhance usability and productivity by streamlining various business processes. The latest updates 2024 Released Wave 2 update allows users to improve functionalities for project management, making it easier for users to access key information quickly and efficiently. Business Value Productivity increases when processes are intuitive and efficient.… Continue reading Enhanced Usability for Projects in Microsoft Dynamics 365 Business Central
Read moreProject Stage Timeline using 100 % Stacked Bar Chart
Inkey Solutions, June 20, 20251017 Views
Managing large-scale projects often involves multiple moving parts, especially when tasks span across various project stages. To ensure smooth execution, it’s vital to track not just the progress of individual tasks, but also how much each stage of the project is progressing based on these tasks. In this blog, we’ll look at how to use… Continue reading Project Stage Timeline using 100 % Stacked Bar Chart
Read moreUsing Matrix as a Heat Map: Visualizing Planned vs Actual Stage Dates in Power BI alternative of Gantt Chart
Inkey Solutions, June 17, 20251438 Views
What is a Heat Map Matrix in Power BI? A heat map using a matrix visual in Power BI is a technique where cell backgrounds are conditionally formatted based on values or logic, allowing users to quickly identify patterns, ranges, and anomalies. This method is especially powerful when representing timelines or comparisons over a series… Continue reading Using Matrix as a Heat Map: Visualizing Planned vs Actual Stage Dates in Power BI alternative of Gantt Chart
Read moreOverlapping Clustered Bar Chart for Estimating Project Completion Dates
Inkey Solutions, June 11, 20251117 Views
What is an Overlapping Clustered Bar Chart? An overlapping clustered bar chart is a powerful visual in Power BI that helps compare planned vs. actual timelines within the same axis. By plotting Estimated End Dates and Actual End Dates as overlapping bars, project managers can visually track progress, spot delays, and identify early completions. Overview… Continue reading Overlapping Clustered Bar Chart for Estimating Project Completion Dates
Read more
