Mastering Time Intelligence Rolling Measures in Power BI

Matt Peterson dives into one of Power BI’s most powerful DAX capabilities: time series analysis. Utilizing built-in DAX time intelligence functions allows you to effortlessly report on data across different time periods, such as year-over-year comparisons, year-to-date totals, monthly closing balances, and more. Understanding how to create rolling totals for dynamic time frames is essential… Read More

Understanding ORC, Parquet, and Avro File Formats in Azure Data Lake

In this article, Bob Rubocki explores how to effectively use ORC, Parquet, and Avro files within Azure Data Lake, focusing particularly on extracting and loading data using Azure Data Factory. When orchestrating data workflows in Azure Data Factory (ADF), selecting the appropriate file formats for data storage and processing in Azure Data Lake is pivotal.… Read More

How to Insert Dynamic Tables into Word Templates Using Power Automate

Nate Halliwell demonstrates a practical technique for adding dynamic tables and repeating sections into Word templates with Power Automate. This tutorial covers the essential steps to automate document generation with personalized data, ideal for use cases like asset tracking. In today’s fast-paced organizational landscape, efficient asset management plays a pivotal role in maintaining operational fluidity… Read More

Understanding Azure Virtual WAN: An Overview of Microsoft’s Advanced Networking Solution

In this article, we explore Azure Virtual WAN, Microsoft’s latest site-to-site networking service designed to simplify and optimize branch office connectivity to Azure. While Azure has long supported traditional site-to-site VPNs, Azure Virtual WAN introduces a more scalable and automated approach, currently available in Preview. Why Azure Virtual WAN Surpasses Traditional VPN Solutions In today’s… Read More

Mastering X Functions with SUMMARIZE to Tackle Complex DAX Challenges

In this insightful tutorial, Mitchell Pearson reveals how to overcome difficult DAX problems in Power BI by effectively using X functions such as SUMX and AVERAGEX. Learn how to manipulate fact tables, understand data granularity, and leverage virtual tables to enhance your data analysis and reporting accuracy. Mastering X Functions in Power BI DAX for… Read More

Mastering the Development and Customization of Power BI Custom Visuals

Are you eager to enhance your Power BI reports by creating and tailoring custom visuals? In this insightful webinar hosted by App Development Consultant Tom Ward, you’ll gain hands-on knowledge about developing and customizing Power BI Custom Visuals using TypeScript. Unleashing the Power of Power BI Custom Visuals: A Comprehensive Guide Power BI Custom Visuals… Read More

When Should You Consider Using Cosmos DB?

As data volumes continue to surge and the variety of data types expands, many organizations face the critical decision of how best to store and manage this growing information. A common question arises: Do I need Cosmos DB or another NoSQL solution? Addressing the Complexity of Modern Data Relationships in a Dynamic World In the… Read More

Visualizing Hierarchical Data in Power BI with the Akvelon Hierarchy Chart

In this guide, we explore how to leverage the Hierarchy Chart custom visual by Akvelon in Power BI to effectively display complex relationships using a tree layout. This visual is perfect for showcasing structures like family trees, organizational charts, and any data that relies on parent-child hierarchies. Introduction to the Hierarchy Chart by Akvelon in… Read More

Unlocking Azure Relational Database Services for Modern PaaS Needs

Azure’s relational database platform powers countless cloud-based applications and services across Microsoft’s PaaS ecosystem. Offering both traditional SQL and open-source databases, it provides secure, scalable, and intelligent infrastructure for modern businesses. The Evolution of Azure’s Relational Database Services Azure’s journey into platform-as-a-service (PaaS) relational databases began with the introduction of Azure SQL Database, marking a… Read More

Understanding the Difference Between Power BI Dataflows and Shared Datasets

As Power BI continues to evolve, the addition of dataflows and the ability to share datasets across multiple reports has introduced new layers of flexibility in data modeling and reporting. However, it also raises a common question: What’s the difference between Power BI Dataflows and Shared Datasets, and when should you use each? In this… Read More

Azure SQL Managed Instance: Modernize Your SQL Server Workloads with Ease

If you’re seeking a robust and cost-effective solution to migrate your on-premises SQL Server workloads to the cloud, look no further than Azure SQL Managed Instance. As one of Microsoft’s most powerful PaaS (Platform as a Service) offerings, it delivers nearly full compatibility with the latest SQL Server Enterprise Edition—making it the ideal solution for… Read More

Visualizing Percentages with the Enlighten Waffle Chart in Power BI

Looking for a creative way to visualize percentage values in Power BI? The Enlighten Waffle Chart custom visual is a highly effective and visually appealing solution. This custom chart displays data on a 10 x 10 grid, allowing users to see how percentages break down at a glance—perfect for dashboards, surveys, and summary visuals. Exploring… Read More

Exporting Power BI Data to Excel: A Simple and Effective Guide

If you’ve ever struggled with exporting data from Power BI to Excel, you’re not alone. One common challenge users face is extracting wide crosstab tables from Power BI for use in Excel—especially when trying to print or share the full dataset beyond what is visible on-screen. While Power BI does offer export options like PDF,… Read More

PL-900 Power Platform Exam Challenge: One Wrong Answer = One Hour at Waffle House!

What happens when you mix Power Platform certification prep with waffles? In this entertaining and educational challenge, Allison Gonzalez and Matt put their Microsoft Power Platform knowledge to the test—but with a tasty twist: every incorrect answer on the PL-900 exam simulation earns one hour at Waffle House! Fortunately for Matt, there’s a loophole—he can… Read More

Understanding the Difference: Scale Up vs Scale Out in Azure Analysis Services

Managing performance and resource efficiency in Azure Analysis Services (AAS) is essential for delivering fast, consistent, and reliable analytics to your organization. Whether you’re handling real-time data queries or heavy processing workloads, knowing when to scale up or scale out can make a significant impact on performance and cost. In this guide, we’ll break down… Read More