Category: Technical Blogs
Creating the Linear Gauge to Check the Status of Sales in Power BI
Inkey, March 29, 2024426 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 moreEnhancements in Column, Bar and Ribbon Charts in Power BI
Inkey, March 26, 2024471 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 […]
Read moreImplementing ADF Branches and Filters for Employee Training
Inkey, March 22, 2024390 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 […]
Read moreEnhancements in the New Card Visual in Power BI
Inkey, March 19, 2024429 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 […]
Read moreRevolutionizing DAX with the Magic of Visual Calculation in Power BI
Admin, March 15, 2024588 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 […]
Read moreEnhancing Column chart for Variance Analysis in Power BI: A Step-by-Step Guide
Inkey, March 13, 2024615 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 […]
Read moreDynamic page navigation in Power BI based as per User Role
Inkey, March 1, 20241102 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 […]
Read moreHow to get direct count using Fetch XML capabilities
Inkey, February 27, 20242358 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 […]
Read moreUnlocking Data Agility: Leveraging Databricks to Interface with Dynamics 365 Business Central’s Complex API
Inkey, February 23, 2024521 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 […]
Read moreIntegration of Business Central APIs and Web Services with OAuth
Inkey, February 20, 2024759 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 […]
Read more