Inkey Solutions, Author at Microsoft Business Intelligence

Microsoft Fabric’s Bronze-Silver-Gold Pattern: Real-World Implementation Guide

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

High Concurrency Session in Notebooks

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

Data Migration: SSIS to Fabric Warehouse Using API as Source

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

Creating Deep Links from Dynamics 365 CRM to Finance & Operations (F&O)

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)

Email Data Migration from CRM to SQL Server using Azure Data Factory

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

Seamless Power BI Integration with SharePoint/OneDrive – No More Publish, No Paid License

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

Sound architectural principles required to ensure effective performance in the cloud

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

ETL in Databricks

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

How to Use new reports and demo data for financial reporting in Microsoft Dynamics 365 Business Central

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

How to Get a Static IP Address for Azure Data Factory Using Self-Hosted Integration Runtime and Azure Virtual Machine

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

How to Use Extended Text for Project Planning Lines in Microsoft Dynamics 365 Business Central

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

From De-normalized to Normalized: A Guide to Data Transformation with SSIS

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

How to Use Default Quantity Settings for General Ledger Accounts in Microsoft Dynamics 365 Business Central

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

How to Create Purchase Orders from Projects 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

Streamlined Operations: Automated Extraction of Email Attachments with SSIS

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

Getting Started with Power BI: Building Your Analytics Foundation

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

How to Archive Service Documents in Microsoft Dynamics 365 Business Central

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

Unlock the power of Microsoft Business Intelligence Software to drive decisions by data

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

How to Use Inventory package numbers work like item tracking dimensions in Microsoft Dynamics 365 Business Central

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

Exploring the New Themes and Controls in Power Apps Canvas

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

How to Use service invoice posting policy for various users in Microsoft Dynamics 365 Business Central

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

How to Invoice a Customer for Multiple Projects in MS 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

Explore “This Data” of the Semantic Model ( on PBI Service)

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)

Dynamically change the data type of Oracle Db and Migrate the data from Oracle to SQL using ADF

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

How to Use the Numbering System for Service Items and Documents in Microsoft Dynamics 365 Business Central

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

How to View Incoming Documents After Archiving Sales and Purchase Quotes in MS 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

Sorting Date & Month Column by Descending in Power bi Matrix Visual

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

How to Efficiently Handle Multiline Text with Configuration Packages in MS Dynamics 365 Business Central

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

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

Dataverse API Calls with Power Automate: A Step-by-Step Guide

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 High-Quality Images from Dataverse Image Field in Power Pages

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 in D365 CRM

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

Real-Time Data Processing with Eventstream in Microsoft Fabric

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

Enhanced Usability for Service Management in Microsoft Dynamics 365 Business Central

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

Parameter Binding with DirectQuery in Power BI

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

Enhanced Usability for Projects in Microsoft Dynamics 365 Business Central

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

Project Stage Timeline using 100 % Stacked Bar Chart

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

Using Matrix as a Heat Map: Visualizing Planned vs Actual Stage Dates in Power BI alternative of Gantt Chart

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

Overlapping Clustered Bar Chart for Estimating Project Completion Dates

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

New Era of Formula Fields: Replacing Calculated Fields in Dataverse and PowerApps

Formula columns in Microsoft Dataverse are special fields that display calculated values based on other fields within a table. These formulas use Power Fx. Power Fx is designed to be automatic. One of the key advantages of Formula columns is that they leverage the same Power Fx functions used across various Microsoft platforms. This means… Continue reading New Era of Formula Fields: Replacing Calculated Fields in Dataverse and PowerApps