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

Preventing Accidental Record Deletion in Power Apps: Best Practices

In Power Apps, giving users the ability to delete data can be incredibly powerful—but it also comes with risks. Often, after demonstrating the deletion feature in an app, I notice concern from users or stakeholders. And for good reason: the ease with which records can be deleted sometimes makes it just as easy to remove… 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

Essential Guideline for Integrating Power Apps with SQL Server

Power Apps has emerged as a powerful platform for building low-code applications, particularly for organizations already using Microsoft 365. Whether you’re looking to simplify data entry, automate workflows, or build lightweight internal apps, Power Apps can connect seamlessly with various data sources—including Excel, SharePoint Lists, and SQL Server tables. Before you dive in, it’s important… Read More

How to Build a Basic PowerApp Using a SQL Server Table

If you’ve ever wanted to quickly build an internal app to communicate or write data back to a simple database—like tracking sales quotas or performance reviews—PowerApps makes it straightforward. In this first installment of our Power Platform Pro Series, we demonstrate how fast and easy it is to create a simple app by connecting PowerApps… Read More