What is Drill Through? Drill-through is a feature in Power BI that allows users to navigate from one report page to another while passing context-specific filters. This is especially useful when users need detailed insights beyond summary data. Overview In this scenario, we have a Power BI report with two pages: Summary Page: Contains a… Continue reading Drill Through from Power BI Table to Paginated Report
Power BI provides powerful features to enhance user interactivity, and two of the most effective tools for this are Bookmarks and the Selection Pane. These features allow you to create interactive reports, toggle between different views, and customize user experiences without complex coding. In this blog, we will explore how to use Bookmarks and the… Continue reading Using Bookmarks and Selection Pane for Interactive Reports in Power BI
Building reports in Power BI requires the right data structure for optimal performance. The two main approaches are Star Schema and Snowflake Schema. Let’s break down their differences in a simple way. Understanding Star Schema Think of Star Schema as the simpler, faster approach. It consists of a central fact table containing numeric values (sales,… Continue reading Star Schema vs. Snowflake Schema: Choosing the Right Model for Power BI
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
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
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
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).
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
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
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
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
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
In today’s business landscape, organizations are constantly seeking ways to maximize growth while minimizing operational costs. Sharing essential information and insights with management or higher-level teams is crucial for decision-making. However, investing in Pro user or Premium per-user licenses for a limited number of users who only need access to view a specific Power BI… Continue reading Efficiently Sharing and Synchronizing Power BI Reports within Your Organization: A Cost-effective Approach
We can now embed Power BI Dashboard/Reports in PowerApps Portal with few easy steps. Prerequisite:- D365 Customer Service organization having a Global user with D365 and Power BI license. ENABLE POWER BI VISUALIZATION In the PowerApps select the environment where you have provisioned the Portal. Go to Your Apps section from Power Apps home page and locate… Continue reading Embed Power BI reports in Power Apps Portal
There are various approaches to embed Power BI Dashboard/Report in D365 Sales, but each approach comes with its own drawbacks and cons that might not complement your requirements. Earlier we have posted blogs that describe the 4 approaches but as I said they have their own pre-requisite and cons. With the advancements of Power BI… Continue reading Power BI > Embed Dashboard/Report in D365 Sales with RLS – 5
© All Rights Reserved. Inkey IT Solutions Pvt. Ltd. 2026
