In Azure Data Factory (ADF), certain pipelines need to run at a specific time, but standard scheduling mechanisms like triggers or on-completion dependencies may not be suitable due to dependencies on upstream processes. A common challenge is ensuring that a pipeline starts at or after a predefined time while avoiding issues like premature execution, data… Continue reading Delaying Pipeline Execution Until a Specific Time in Fabric Data Pipeline by Implementing a Dynamic Wait Mechanism
Struggling with a slow Power BI report? You’re not alone. Slow performance is often caused by complex calculations, inefficient data models, or an overload of visuals. Power BI Performance Analyzer can help identify these bottlenecks and guide you toward a smoother, faster report. What is Power BI Performance Analyzer? A built-in tool in Power BI… Continue reading Optimizing Power BI Reports with Performance Analyzer
Microsoft Dynamics 365 Business Central offers a strong ERP solution adapted to streamline financial operations. One of the standout features of 2024 wave1 for collection management is the Accounts Receivable Administrator Role Center. This role center is designed to centralize and simplify collection tasks, such as creating and sending reminders and statements. By leveraging the… Continue reading How to Utilize the Accounts Receivable Administrator Role Center in Microsoft Dynamics 365 Business Central
One of the most powerful features in Power BI is Calculation Groups. They allow you to reduce redundant calculations and enhance the flexibility of your reports. If you often find yourself writing multiple measures for different time-based calculations (such as YTD, QTD, MTD, YOY), then Calculation Groups are the ultimate solution. In this blog, we… Continue reading Mastering Calculation Groups in Power BI
In today’s fast-paced digital world, understanding and leveraging metadata is key to building robust, data-driven applications. Working with CRM systems, having quick access to metadata especially for lookup fields can significantly streamline customization and integration efforts. In this blog, we’ll walk you through the process of fetching CRM metadata using API calls in Postman, with… Continue reading Lookup CRM Metadata Using API in Postman
Lakehouses combine the best features of data lakes and data warehouses, offering scalable and cost-effective solutions for storing and processing large datasets. However, they come with a notable limitation: insert, update, and delete operations on tables are not natively supported. This poses a challenge for use cases requiring data synchronization or incremental updates. To overcome… Continue reading Overcoming Lakehouse Limitations: Implementing Upserts with PySpark
For years, Microsoft Dynamics Great Plains (GP) was the go-to ERP solution for businesses looking for robust accounting and financial management tools. However, as technology evolves and business needs shift, it’s clear that Microsoft Dynamics Business Central has taken the lead as the modern, scalable alternative. If you’re still using GP, it may be time… Continue reading Dynamics Great Plains vs. Business Central: Why It’s Time to Upgrade
In today’s fast-paced business environment, organizations are constantly seeking ways to improve efficiency and productivity. Artificial intelligence (AI) is proving to be a game-changer, helping employees work smarter and faster. From automating repetitive tasks to providing insightful analytics, AI is transforming workplaces in ways that lead to significant business growth. Automating Repetitive Tasks One of… Continue reading How AI Boosts Employee Productivity and Drives Business Growth
The rapidly changing digitization world brings a lot of troubles regarding the complexities of IT infrastructure management and scaling issues for business organizations. Microsoft Azure Services offers a variety of cloud services, including computing, storage, analytics, networking, and AI. These services can be used to develop and scale applications or run existing applications in the… Continue reading Unlock Your Business’s Potential: 5 Ways Microsoft Azure Consulting Services Can Transform Your Operations
Microsoft Fabric offers a robust platform for data integration and analytics. Leveraging the wealth of data stored in your Dataverse environment within Fabric is not only possible but also highly beneficial. This blog delves into the process of linking your Dataverse environment to Microsoft Fabric, exploring prerequisites, advantages, considerations, and a detailed step-by-step integration process.… Continue reading Linking Your Dataverse Environment to Microsoft Fabric
Stripe payment integration is a key feature of Power Pages, allowing users to easily process payments directly within the portal. This integrated functionality enhances businesses by providing a simple payment solution. With just a few clicks, users can securely complete their purchases using Stripe’s trusted payment processing services. Stripe is a preview feature in Power… Continue reading Stripe Payment Integration with Power Pages
Activity timeline is time-tracking and planning control for each record. Activity controls many processes like Appointment, Email, Portal Comments and Phone call. We can enable an activity timeline for Power pages. Appointments: Scheduled meetings and events. Emails: Send and receive emails. Portal Comments: Feedback or notes added directly on the portal. Phone Calls: Records of… Continue reading Mastering Activity Tracking: Enabling the Activity Timeline in Power Pages for Better Management
Climate change is an urgent global challenge, and the need for innovative solutions has never been more critical. AI and data analysis have emerged as powerful tools in this fight, providing unprecedented insights and driving impactful actions. From understanding environmental patterns to optimizing resource use, AI is transforming how we combat climate change. Harnessing Big… Continue reading Leveraging AI and Data Analysis to Combat Climate Change
Exact matching is a critical process for identifying precise matches between text data and predefined keywords. In this blog, we’ll walk you through building an Azure ML pipeline to perform exact keyword matching using a Python script Why Perform Exact Matching? Exact matching is vital when precision is critical. It ensures: Identifying Specific Terms: Ideal… Continue reading How to Build a Pipeline for Exact Matching in Azure ML Using Python Script
In this blog, I will showcase how to seamlessly integrate Dynamics 365 CRM with Encodian to automate the creation of PDFs populated with CRM data. By leveraging Power Automate, you can map data from CRM records directly into fillable PDF forms using JSON mapping. This solution simplifies document generation for processes like contracts, invoices, and reports, ensuring… Continue reading Automating PDF Generation with Dynamics 365 CRM Data Using JSON Mapping and Encodian in Power Automate
As per the beginner’s knowledge, RPA (Robotic Process Automation) Desktop flows, also known as UI flows, are a feature within Microsoft Power Automate that allows users to automate repetitive tasks on their Windows desktop or web applications. Desktop flows are part of the broad Power Automate platform, providing a solution for automating processes that involve… Continue reading Unlocking Efficiency: A Beginner’s Guide to RPA Desktop Flows in Power Automate
Maintaining organized and meaningful data is crucial for effective management and analysis. AutoNumber fields are a popular solution for generating unique identifiers, but sometimes a simple numeric sequence isn’t enough. By adding prefixes based on specific conditions, you can enhance the context of your data, making it easier to identify and categorize records briefly. In… Continue reading How to Populate Prefix in AutoNumber fields based on conditions in Dynamics 365 Sales
As everybody knows, in Dataverse, if we need to do anything that is not available in OOTB functionality and crucial to implement, we need to use plugin. To write a plugin, we need to write a code to mitigate our functionalities. But now, we do have another option available that will help us to create… Continue reading How to use Low-No Code Plugin using Data verse accelerator in dynamics 365
These days a speedy-paced business environment and efficient reporting equipment are crucial. Dynamics 365 is a powerful CRM and ERP answer that offers robust reporting capabilities. However, exporting those reports in a consumer-friendly format, like PDF, can on occasion be difficult. Fortunately, Power Automate gives a streamlined way to automate this method. In this blog,… Continue reading How to run OOTB Report and send emails with pdf attachments using Power Automate.
Requirements: If the file size of an Excel file exceeds the specified criteria, we need to address the following: The Excel file contains multiple sheets, and these sheets contain inter-related data. We utilize SQL Views to retrieve data from these sheets using the “Get Data” activity in Excel. Although we can split the Excel file… Continue reading Split the Text files using ADF Pipelines
© All Rights Reserved. Inkey IT Solutions Pvt. Ltd. 2025
