Microsoft Power BI consulting: Introduction to the new Button Slicer
WebSiteAdmin, July 3, 20241005 Views
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
Read moreDynamics 365 Business Central: Retrieve Linked Sales Order Data in Assembly Orders Using AL Code
WebSiteAdmin, June 27, 2024971 Views
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
Read moreMicrosoft Power BI consulting: Using Calculation Groups from Model Explorer in PBI Desktop and PBI Service (including Direct Lake Semantic Models).
WebSiteAdmin, June 19, 20241268 Views
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).
Read moreDynamics 365 Business Central
WebSiteAdmin, June 10, 2024469 Views
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
Read morePower Automate: Track Multiple Microsoft Survey Forms Responses
WebSiteAdmin, June 4, 20241801 Views
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
Read moreMicrosoft Power BI Consulting: Unleashing the Power of Generative AI
WebSiteAdmin, May 28, 2024812 Views
In the ever-evolving landscape of data analytics and reporting, Microsoft continues to raise the bar with innovative solutions. One such groundbreaking feature is the integration of generative AI into its reporting platform, Power BI. With the Premium Capacity subscription, users can now harness the capabilities of Copilot to effortlessly create and modify reports with just… Continue reading Microsoft Power BI Consulting: Unleashing the Power of Generative AI
Read moreHow to use SecretText Data type in Business Central
WebSiteAdmin, May 17, 20242587 Views
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
Read moreRevolutionizing Data Management with Microsoft Fabric Consultants
WebSiteAdmin, May 6, 2024962 Views
In today’s fast-paced digital world, businesses are always looking for new ways to improve their data management. Before Microsoft Fabric technology came along, managing data was tough – there were silos, integration problems, and scalability issues. But with Microsoft Fabric, everything’s changed. Microsoft Fabric consultants are at the forefront of this revolution, guiding organizations to… Continue reading Revolutionizing Data Management with Microsoft Fabric Consultants
Read moreHow to Change Auto number seed in Dynamics 365 Sales
WebSiteAdmin, April 30, 20241467 Views
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
Read moreMicrosoft Business Intelligence: A Game-Changer for Multi-Sector Business Owners
WebSiteAdmin, April 23, 2024568 Views
In the dynamic/diverse sphere of multi-sector businesses, it is essential to stay ahead in the market which requires strategic decision-making backed by insightful data analysis. Microsoft Business Intelligence (BI) emerges as a hero tool set in these diverse industries from empowering entrepreneurs to even large undertakings in order to unlock valuable business insights. Microsoft Business… Continue reading Microsoft Business Intelligence: A Game-Changer for Multi-Sector Business Owners
Read moreHarnessing Innovation with Microsoft Azure Services
WebSiteAdmin, April 23, 2024765 Views
The world of cloud computing has completely transformed how businesses operate and innovate. Microsoft Azure stands out as a leading cloud platform, by offering unmatched scalability and agility to organizations all over the globe. Our Microsoft Azure services encompass a wide range of offerings, from deploying infrastructure to modernizing applications. Whether you’re migrating to Azure,… Continue reading Harnessing Innovation with Microsoft Azure Services
Read moreDynamics 365 Business Central: Item Variant Block Functionality
WebSiteAdmin, April 23, 20241751 Views
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
Read moreMicrosoft Power BI consulting: Building Your Analytics Foundation
WebSiteAdmin, April 18, 20241175 Views
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 BI… Continue reading Microsoft Power BI consulting: Building Your Analytics Foundation
Read morePower BI Consulting: Switching between Aggregated Value and Break downed values using Field Parameters
WebSiteAdmin, April 12, 20241068 Views
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
Read moreMicrosoft Power BI Consulting: How to get the data from the outlook attachment and load it to the Power BI report
WebSiteAdmin, April 5, 20241307 Views
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
Read moreIntroducing Explore this data feature in PowerBI service
WebSiteAdmin, April 2, 20242112 Views
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
Read moreCreating the Linear Gauge to Check the Status of Sales in Power BI
WebSiteAdmin, March 29, 20241020 Views
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
Read moreEnhancements in Column, Bar and Ribbon Charts in Power BI
WebSiteAdmin, March 26, 20241304 Views
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
Read moreImplementing ADF Branches and Filters for Employee Training
WebSiteAdmin, March 22, 2024667 Views
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
Read moreEnhancements in the New Card Visual in Power BI
WebSiteAdmin, March 19, 20241062 Views
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
Read moreRevolutionizing DAX with the Magic of Visual Calculation in Power BI
WebSiteAdmin, March 15, 20241529 Views
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
Read moreEnhancing Column chart for Variance Analysis in Power BI: A Step-by-Step Guide
WebSiteAdmin, March 13, 20241978 Views
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
Read moreImplementing Dynamic Cascading Slicer To Filter the Data
WebSiteAdmin, March 6, 20241054 Views
Recently, for Power BI, we encountered a requirement where we have Delivery data, and we want Slicer which gives a range of “Delivery Per Customer”(Count of Deliveries) that seamlessly integrates with all visuals in the dashboard. Specifically, a scenario where, upon selecting a date range, the “Delivery Per Customer” slicer dynamically operates on the filtered… Continue reading Implementing Dynamic Cascading Slicer To Filter the Data
Read moreDynamic page navigation in Power BI based as per User Role
WebSiteAdmin, March 1, 20242845 Views
In Power BI, providing page security and role-based access to users traditionally involves creating different workspaces or different audiences in one app workspace. However, an innovative approach is to achieve this using measures, eliminating the need for additional workspaces and audiences. In this blog post, we will explore a real-time requirement where we need to… Continue reading Dynamic page navigation in Power BI based as per User Role
Read moreHow to get direct count using Fetch XML capabilities
WebSiteAdmin, February 27, 20245109 Views
FetchXML in Dynamics 365 is a query language used to retrieve data from the system. It is a powerful and flexible tool that allows users to define complex queries to retrieve specific data from Dynamics 365 entities. An aggregate function into FetchXML queries, we can enhance data retrieval capabilities in Dynamics 365. Whether we can… Continue reading How to get direct count using Fetch XML capabilities
Read moreUnlocking Data Agility: Leveraging Databricks to Interface with Dynamics 365 Business Central’s Complex API
WebSiteAdmin, February 23, 2024945 Views
Say hello to Databricks, a dynamic platform merging the power of Apache Spark with collaborative workspaces allowing flexibility to use multiple programming languages (Python, Scala, SQL) within a single environment. This versatility surpasses the constraints of predefined transformations in pipelines, allowing for more intricate and customized data transformations. Data Pipeline Hiccups: The ‘Content-Type’ Snag Let’s… Continue reading Unlocking Data Agility: Leveraging Databricks to Interface with Dynamics 365 Business Central’s Complex API
Read moreIntegration of Business Central APIs and Web Services with OAuth
WebSiteAdmin, February 20, 20241299 Views
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 connect Business Central APIs and Web Service with OAuth. Microsoft Dynamics 365 Business Central, offers a set of powerful APIs and… Continue reading Integration of Business Central APIs and Web Services with OAuth
Read moreIs Microsoft Dynamics 365 Business Central the best ERP?
WebSiteAdmin, February 19, 2024897 Views
ERPs or Enterprise Resource Planning applications have been around for a very long time now. They started off as simple table heavy software applications leveraging computers’ ability to store data indefinitely and retrieve data at any time with speed and accuracy. Over time as databases evolved into relational databases, computers became faster and could store… Continue reading Is Microsoft Dynamics 365 Business Central the best ERP?
Read moreAchieving Hierarchical Representation for Measures in Power BI Matrix Visual: A Workaround
WebSiteAdmin, February 16, 20242591 Views
Greetings, BI enthusiasts! When working with Power BI reports and handling numerical data with multiple hierarchies, the Matrix visual is often the go-to choice. It seamlessly accommodates hierarchical data with proper modeling, allowing the use of measures as rows. However, what if you need to display measures as rows with specified indentations, sorting, and font… Continue reading Achieving Hierarchical Representation for Measures in Power BI Matrix Visual: A Workaround
Read moreAdd custom fonts in SSRS Report
WebSiteAdmin, February 13, 20244176 Views
Adding custom fonts in SSRS or SQL Server Reporting Services is a powerful way to personalize and enhance the visual appeal of your reports. This process involves selecting a distinct typeface that aligns with your brand identity and integrating it seamlessly into your SSRS environment. Let’s explore how the addition of a custom font can… Continue reading Add custom fonts in SSRS Report
Read moreParse JSON for Multi-Type Properties
WebSiteAdmin, February 6, 20243357 Views
JSON (JavaScript Object Notation) is a widely used data format for storing and exchanging data. It is easy to read, write, and parse, making it a popular choice for data interchange. However, when working with JSON data, you may encounter scenarios where a column or field can contain multiple types of data. In this blog… Continue reading Parse JSON for Multi-Type Properties
Read moreCreate apps from Figma in Power Apps
WebSiteAdmin, January 30, 20241882 Views
The ability to create PowerApps from Figma design files directly helps bridge the gap between design and development by accelerating the app UI development process. It allows developers and designers to collaborate effectively and efficiently to deliver great end user experiences with low cost and effort. Designers can create designs in Figma using the Create… Continue reading Create apps from Figma in Power Apps
Read moreStreamlining Business Operations with Microsoft Dynamics 365 Business Central, Microsoft Power BI Consulting, and Power Apps Services
WebSiteAdmin, January 24, 20241137 Views
In today’s dynamic business landscape, organizations are constantly seeking innovative solutions to enhance their operational efficiency and gain a competitive edge. One such transformative suite of services offered by Inkey IT Solutions Pvt. Ltd. includes Microsoft Dynamics 365 Business Central, coupled with Microsoft Power BI Consulting and Microsoft Power Apps Services. Let’s delve into the power-packed… Continue reading Streamlining Business Operations with Microsoft Dynamics 365 Business Central, Microsoft Power BI Consulting, and Power Apps Services
Read morePart 3: Git Integration for Content Management
WebSiteAdmin, January 19, 20242270 Views
In our previous blog, we delved into the inner workings of Deployment Pipelines. Now, we shift our focus towards a crucial aspect of Power BI development – integrating Git with workspaces in Power BI Service, especially those that play a pivotal role in your Deployment Pipelines. Integrating Git with Power BI Workspaces Our journey now… Continue reading Part 3: Git Integration for Content Management
Read morePart 2: Streamlining Power BI Deployment Pipelines
WebSiteAdmin, January 16, 20241746 Views
In our previous blog post, we delved into Power BI Projects and Git integration, catering to the needs of developers with Pro Capacity. Today, we venture further into the fascinating world of Power BI Deployment Pipelines. Our focus is on providing you with insights into how to seamlessly handle content within your development lifecycle. Unveiling… Continue reading Part 2: Streamlining Power BI Deployment Pipelines
Read morePart 1: Git Integration with Power BI
WebSiteAdmin, January 9, 20242577 Views
In a much-anticipated move, Microsoft has unveiled Git Integration in Power BI for developers who work with Power BI Desktop Projects. This ground-breaking feature which is in preview, promises to revolutionize the way developers streamline development, source control, and collaboration within their Power BI projects. In this technical blog, we’ll delve into the intricacies of… Continue reading Part 1: Git Integration with Power BI
Read moreEmail Deduplication In Customer Insights
WebSiteAdmin, January 5, 20241829 Views
The email deduplication in Customer Insights feature prevents sending of duplicate emails to the same email address, ensuring a more efficient communication process. Email deduplication is enabled in journeys through the setting of customer insight journey but is disabled by default and applies to all segment-based journeys. How to enable email deduplication Open Customer Insights… Continue reading Email Deduplication In Customer Insights
Read moreLeveraging SQL Schema Compare in Visual Studio for Efficient Database Management
WebSiteAdmin, January 2, 20243056 Views
In the dynamic landscape of database management, maintaining and evolving database schemas is a critical aspect. Visual Studio provides a powerful platform for managing these tasks efficiently. In this blog post, we’ll explore the ins and outs of using SQL Schema Compare for altering, creating, and deleting objects, and discuss why Visual Studio is a… Continue reading Leveraging SQL Schema Compare in Visual Studio for Efficient Database Management
Read moreIdentify Posted Purchase Receipt and Invoices Against Purchase Order
WebSiteAdmin, December 29, 20231207 Views
Microsoft 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 to identify posted purchase receipts and invoices against order. Prerequisites: Verify that the organization has valid licenses for Microsoft Dynamics 365 Business Central. Required Business… Continue reading Identify Posted Purchase Receipt and Invoices Against Purchase Order
Read morePower Pages Backup Using One Line PowerShell Script
WebSiteAdmin, December 26, 20231825 Views
The Power Page backup process is a very simple process using PowerShell. The command is a single line that combines three to four commands mentioned in the Microsoft documentation. This one-liner helps you export and saves you time. As per the Microsoft documentation, we can take by using a 3–4-line command. By preferring this blog,… Continue reading Power Pages Backup Using One Line PowerShell Script
Read more
