Author: jaspreet2c6a5e7b03

Refresh in Power BI: Understanding Incremental Refresh in the Service and the Role of Manual and Scheduled Refresh

Byjaspreet2c6a5e7b03

Power BI offers multiple refresh mechanisms that serve different purposes. Manual and Scheduled Refresh control when data is refreshed, while Incremental Refresh controls how much data is refreshed. To clearly understand the difference, let’s walk through a single, consistent example using a sales dataset stored on OneDrive. Manual Refresh vs Scheduled Refresh vs Incremental Refresh…

Power BI CI/CD: From Manual Publishing to Automated Deployments

Byjaspreet2c6a5e7b03

Deployment to the Power BI Service can be done using both Azure DevOps and GitHub, but many teams prefer GitHub because it is open-source, widely adopted, and easy to integrate with automation tools. This often leads to common questions such as: What is CI/CD? What is a CI/CD pipeline? And why use CI/CD when manual…

Understanding SELECTEDVALUE(), HASONEVALUE() and VALUES() in Power BI

Byjaspreet2c6a5e7b03

One of the biggest reasons Power BI measures behave “unexpectedly” is that most users do not realize how strongly DAX depends on filter context. When we interact with a slicer, even a small change can completely shift the filter context, causing a measure to return a different value, sometimes dramatically different. To work confidently with…

Unlocking Data Governance with Microsoft Fabric and Purview

Unlocking Data Governance with Microsoft Fabric and Purview

Byjaspreet2c6a5e7b03

1. Understanding the Core Components : 2. Connecting Fabric to Purview : 3. Registering the Data Source : 4. Creating Your First Scan : 5. Setting Up Fabric Access for Purview : 6. Creating a Security Group in Azure : 7. Testing the Integration : 8. Initiating a Data Scan : 9. Analyzing Scan Results…

Power BI Data Modeling Best Practices

Power BI Data Modeling Best Practices

Byjaspreet2c6a5e7b03

Power BI has become one of the most powerful and widely adopted tools in the world of data analytics and business intelligence. But while Power BI’s visualizations grab the spotlight, what happens under the hood the data modeling often determines whether your reports fly or crawl. Data modeling in Power BI is like laying the…

Custom Sorts in Power BI – Step by Step Guide

Custom Sorts in Power BI – Step by Step Guide

Byjaspreet2c6a5e7b03

When working with Power BI, we often face situations where the default sorting (alphabetical or numerical) does not meet business needs. For example, you may want to display product categories in the order High → Medium → Low instead of the standard alphabetical sequence. To achieve this, Power BI allows us to create a custom…

Dynamic Classification and Filtering in Power BI

Dynamic Classification and Filtering in Power BI

Byjaspreet2c6a5e7b03

Dynamic Classification and Filtering in Power BI Context : Example Scenario : Pareto Chart & Principle : Step 1: Base Measure : Step 2: Product Ranking : Step 3: Cumulative Sales : Step 4: Percentage of Total : Step 5: Classification : Classification Filtering : Building the Pareto Plot : Colouring : Filtering : Outcome…

Tableau vs Power BI – 15 Major Differences

Tableau vs Power BI – 15 Major Differences

Byjaspreet2c6a5e7b03

Analytics tools are the lifeblood of any data-driven organization that enables companies to collect, analyze, and interpret vast amounts of data, helping them make informed decisions and derive better business development. In this article, we’ll explore contrasts between the two most used BI tools in the market: Tableau vs Power BI and discuss how they…

Related() and RelatedTable()

Related() and RelatedTable()

Byjaspreet2c6a5e7b03

RELATED() is one of the most-used DAX functions. You use RELATED() when you’re iterating a table and, within that row context, you need a value from a related table. Its companion, RELATEDTABLE(), goes the opposite way across the relationship. It’s easy to mix these up using RELATED() when it isn’t needed, or forgetting about RELATEDTABLE()….