The objective is to copy various types of files, including JSON, CSV, Text, and Excel files, using a single Copy data activity in Azure Data Factory (ADF) pipeline. Implementation: Step 1: Utilize the “Get Metadata” activity to retrieve the list of files stored in the blob storage. Select the “Child Items” option from the field… Continue reading Dynamically copying all types of files, including Excels, JSON, CSV, and TXT, using a single copy data activity in ADF
Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to call (invoke) Power Automate Flows on an action via HTTP Request in Business Central Using AL Code. Integrating Power Automate Flows… Continue reading How to call (invoke) Power Automate Flows on an action via HTTP Request in Business Central Using AL Code
Microsoft Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature is the capability to archive projects (jobs) which can help keep your workspace organized and efficient. With archiving capabilities, users can manage their project data effectively, benefiting from audit trails and version… Continue reading Archiving Projects (Jobs) in Microsoft Dynamics 365 Business Central
The Power BI has introduced a new button slicer which resembles somewhat to the custom slicer, i.e., the Chiclet slicer. In this blog, as a part of Microsoft Power BI consulting we are going to explore this new button slicer. In the current report, we have imported the sample dataset i.e., Financials dataset, upon which… Continue reading Microsoft Power BI consulting: Introduction to the new Button Slicer
Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to get linked Sales order’s data in Assembly Order. This customization can be used for businesses that deal with complex assembly processes and… Continue reading Dynamics 365 Business Central: Retrieve Linked Sales Order Data in Assembly Orders Using AL Code
In this blog, we are going to explore the new feature to use the Calculation Groups using Power BI Desktop and Microsoft Power BI Services through Microsoft Power BI consulting. Currently, we are making use of the Sample dataset i.e., Financials dataset in Power BI. Also, we have created a Date table starting from minimum… Continue reading Microsoft Power BI consulting: Using Calculation Groups from Model Explorer in PBI Desktop and PBI Service (including Direct Lake Semantic Models).
Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to link Dimensions to a custom table and its Pages in D365 Business Central. Prerequisites Access to a Microsoft Dynamics 365 Business Central… Continue reading Dynamics 365 Business Central
In the realm of Microsoft Forms and Power Automate integration, “When a new response is submitted” connector serves as a reliable tool for triggering actions upon the submission of a single form response. However, a notable limitation arises when attempting to capture responses from multiple Microsoft Forms simultaneously. Considering this challenge, there emerges a need… Continue reading Power Automate: Track Multiple Microsoft Survey Forms Responses
Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of customization options to meet the unique needs of your business. One such customization is to set the shipment date as blank when creating a new sales order in Business Central. This customization can be particularly useful when… Continue reading How to use SecretText Data type in Business Central
This blog will help you with the scenario where you must reset the Auto number field seed using the Power Automate and Plugin in Dynamics 365 Sales. Suppose we have the following AutoNumber field created with, Seed value – {DATETIMEUTC:MMM-yy}_001 Using Power Automate: Here, reset the seed back to the original “001”-seed every month Using… Continue reading How to Change Auto number seed in Dynamics 365 Sales
Dynamics 365 Business Central is a powerful Enterprise Resource Planning (ERP) solution that offers a wide range of features. One such feature that can significantly enhance your process is the Block your item variant which is not in use. Requirement: How can we Specify and restrict to use old or not in use variant during… Continue reading Dynamics 365 Business Central: Item Variant Block Functionality
Switching between aggregated values and breakdown values using Field Parameters in Microsoft Power BI allows users the flexibility to choose between viewing the total amount for all categories, such as products or regions, or breaking down the amount values by specific categories. This capability through Microsoft Power BI Consulting empowers users to view aggregated sales… Continue reading Power BI Consulting: Switching between Aggregated Value and Break downed values using Field Parameters
In the dynamic realm of data analytics and Microsoft Power BI Consulting, incorporating Excel files into Microsoft Power BI reports is a common practice. Often, these files are received as email attachments in Outlook, requiring a manual download and integration process. While this approach is functional, it poses challenges when it comes to maintaining an… Continue reading Microsoft Power BI Consulting: How to get the data from the outlook attachment and load it to the Power BI report
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 of… Continue reading Introducing Explore this data feature in PowerBI service
Microsoft Power BI offers an extensive range of charts and graphs designed to visually represent data, facilitating insightful analysis for making informed business decisions. Occasionally, stakeholders prefer a broad overview of their performance and target achievements, categorized into percentage ranges, without delving into precise figures. While Power BI lacks a built-in linear gauge visual akin… Continue reading Creating the Linear Gauge to Check the Status of Sales in Power BI
Microsoft Power BI continues to be a cornerstone in the BI community, with its relentless commitment to updates catering to evolving business needs. The latest eagerly awaited enhancements in Column, Bar, and Ribbon Charts provide users unparalleled flexibility to tailor their visualizations. Enhancement in Stacked Column/Bar Charts: In recent updates we get the following options… Continue reading Enhancements in Column, Bar and Ribbon Charts in Power BI
In one organization, there is one analysis of employee’s performance on different technologies based on the technologies they know and ratings from their manager. If they don’t meet the required criteria, then that employee will get training for those technologies. Input: emp_id MSBI PowerBI ratings from the manager 101 null x 3 101 null null… Continue reading Implementing ADF Branches and Filters for Employee Training
Microsoft is always keen to bring new updates to its reporting service Power BI. Because, it has a wide user base and makes it easy for the report viewers and data analysts to easily dive into their data and analyze it. This also makes the report developers happy because they find it easy to show… Continue reading Enhancements in the New Card Visual in Power BI
The February 2024 update marks a transformative shift in DAX in Power BI writing with the introduction of visual calculations! Visual calculations entail defining and executing DAX calculations directly within a visual. These calculations have the flexibility to reference any data within the visual, be it columns, measures, or other visual calculations. This innovative approach… Continue reading Revolutionizing DAX with the Magic of Visual Calculation in Power BI
In the dynamic landscape of business analytics, tracking and comparing sales or profit variances across different categories or countries is essential. While Power BI has been a go-to tool for visualizing data, the conventional methods of representing variances were limited. In this technical blog, we will explore how to leverage the reference line feature in… Continue reading Enhancing Column chart for Variance Analysis in Power BI: A Step-by-Step Guide
© All Rights Reserved. Inkey IT Solutions Pvt. Ltd. 2025
