Mastering Power BI Custom Visuals: The Tornado Chart Explained
In this tutorial, you will learn how to effectively utilize the Tornado custom visual in Power BI. The Tornado visual is a powerful tool for comparing two categories of data side-by-side in a vertical layout, similar to a bar chart but optimized for direct comparison. In the realm of data visualization, effectively comparing two distinct… Read More
Discover the Power BI Activity Log API: A Smarter Way to Monitor Power BI Usage
Are you still relying on the Office 365 Audit Log to track activities within Power BI? It’s time to explore a more efficient solution. The Power BI Activity Log API, introduced in December 2019 and currently in preview, offers a focused and streamlined approach to monitoring your Power BI tenant.. The Critical Importance of Monitoring… Read More
Mastering Power Query with the M Language
If you regularly use Power BI Desktop and its Query Editor, are you fully leveraging the true potential of the M language? The Query Editor offers a robust graphical interface that automatically generates M code, also known as the Power Query formula language. In a recent webinar, founder Brian Knight delved deep beyond the visual… Read More
Boosting Model-Driven Apps with Custom Pages: A Practical Guide
In a comprehensive tutorial video, Nate Halliwell reveals how to enhance your model-driven app development by leveraging canvas app capabilities. This guide explains how to seamlessly integrate custom pages into model-driven apps, enabling richer features typically found in canvas apps—without writing any custom code. Unlocking the Potential of Custom Pages in Model-Driven Power Apps Model-driven… Read More
Choosing Between SSAS Multidimensional and Tabular: An Introduction
Are you currently involved in a project where you need to decide which version of SQL Server Analysis Services (SSAS) — Multidimensional or Tabular — to use? During a recent presentation on SSAS Multidimensional best practices, an insightful question was raised: “How do I decide between SSAS Tabular and SSAS Multidimensional?” This sparked a deeper… Read More
Exploring SQL Server 2016 Security Features: Dynamic Data Masking and Always Encrypted
SQL Server 2016 introduced powerful security features designed to protect sensitive data — Dynamic Data Masking (DDM) and Always Encrypted. These technologies help organizations safeguard information by limiting data exposure and encrypting data both at rest and in transit. Dynamic Data Masking (DDM) is an advanced data protection mechanism designed to enhance security by selectively… Read More
Unlocking Paginated Reports: Connecting Lakehouse Tables in Power BI Report Builder
Austin Libal, a veteran trainer specializing in Microsoft Fabric and Power BI, recently showcased two effective methods to connect to Lakehouse tables using Power BI Report Builder. This powerful tool is essential for creating paginated reports that offer pixel-perfect formatting, ideal for printing or exporting to PDF with precise control. Connecting reports to a central… Read More
Unlocking Power BI’s Modern Visual Tooltips: A Game-Changing Feature for Drill Through and Drill Down
If you haven’t yet explored the modern visual tooltip preview feature in Power BI, now is the perfect time to start. This innovative functionality significantly enhances user experience by making drill through and drill down capabilities more intuitive and accessible within your reports. In the evolving landscape of data analytics, user interface innovation plays a… Read More
Power BI Text Search Slicer: Problem, Approach, and Solution Explained
In this edition of the “Problem, Approach, Solution” series, we’ll explore how to implement text search functionality using slicers in Power BI, mimicking a SQL “LIKE” search. For a detailed walkthrough, there is a video tutorial linked at the end under “Resources.” Addressing the Limitations of Default Slicer Functionality in Power BI Power BI is… Read More
Introduction to Azure Databricks: A Beginner’s Guide
Azure Databricks represents one of the most powerful and versatile unified analytics platforms available in the modern cloud data ecosystem, combining the distributed computing capabilities of Apache Spark with an optimized cloud-native environment built specifically for the Microsoft Azure platform, and wrapping both in a collaborative notebook-based development experience that makes sophisticated data engineering, data… Read More
Understanding Azure SQL Database Reserved Capacity for Cost Savings
Last week, I discussed the Azure Reserved VM Instances and how they help save money. Similarly, Azure offers SQL Database Reserved Capacity, a powerful option to reduce your cloud expenses by up to 33% compared to the license-included pricing model. This savings comes by pre-purchasing SQL Database v-cores for either a 1-year or 3-year commitment.… Read More
Exploring Visual Calculations in Power BI: A New Era of Data Analysis
In a recent video released on the YouTube channel, Senior Trainer Mitchell Pearson unveils the innovative visual calculations feature in Power BI, designed to simplify complex data analysis by minimizing the need for advanced DAX formulas. Unlocking the Power of Visual Calculations in Power BI Power BI has long been a frontrunner in business intelligence… Read More
How to Send Emails and Format Dates Using Power Apps and Power Automate
Power Apps provides an excellent platform for users to create new records and submit them to various data sources. A common question that arises after mastering record creation is: “Can I automate sending or receiving emails after a record is created?” The answer is a definite yes. In the contemporary digital workspace, automating communication processes… Read More
Exploring Image Recognition with Azure Computer Vision API
In this article, we dive into the powerful features of the Azure Computer Vision API and explore how it can transform your approach to image analysis and recognition. In the age of artificial intelligence and intelligent automation, image analysis has moved far beyond simple pattern recognition. Microsoft’s Azure Computer Vision API stands at the forefront… Read More
MO-200 Microsoft Excel Certification: Preview of the Ultimate Prep Course
The MO-200 Microsoft Excel Associate certification is an entry-level credential issued by Microsoft that validates a candidate’s ability to perform fundamental and intermediate Excel tasks that are expected of business professionals who use spreadsheets regularly in their daily work. It is part of the Microsoft Office Specialist certification program that has been a recognized standard… Read More