Category: Technical Blogs
Microsoft Power BI consulting: Using Calculation Groups from Model Explorer in PBI Desktop and PBI Service (including Direct Lake Semantic Models).
Inkey, June 19, 2024620 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 […]
Read moreDynamics 365 Business Central
Inkey, June 10, 2024237 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 […]
Read morePower Automate: Track Multiple Microsoft Survey Forms Responses
Inkey, June 4, 2024366 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 […]
Read moreHow to use SecretText Data type in Business Central
Admin, May 17, 2024855 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 […]
Read moreHow to Change Auto number seed in Dynamics 365 Sales
Inkey, April 30, 2024515 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 […]
Read moreDynamics 365 Business Central: Item Variant Block Functionality
Admin, April 23, 2024412 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 […]
Read morePower BI Consulting: Switching between Aggregated Value and Break downed values using Field Parameters
Inkey, April 12, 2024545 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 […]
Read moreMicrosoft Power BI Consulting: How to get the data from the outlook attachment and load it to the Power BI report
Inkey, April 5, 2024561 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 […]
Read moreIntroducing Explore this data feature in PowerBI service
Inkey, April 2, 2024493 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 […]
Read moreCreating the Linear Gauge to Check the Status of Sales in Power BI
Inkey, March 29, 2024407 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 […]
Read more