Understanding Paginated Reports in Power BI

Have you explored the benefits of implementing paginated reports within Power BI? Recently, clients have asked about options for operational reporting optimized for printing, alongside their interactive, self-service Power BI dashboards. Some were hesitant about adopting new tools for their critical reporting needs. Understanding the Power of Paginated Reports in Modern Business Intelligence Paginated reports… Read More

Comparing Azure Data Factory Copy: Folder-Level vs File-Level Loading

In this article, I’ll share insights gained from recent projects involving Azure Data Factory (ADF) performance when transferring data from Azure Data Lake to a database, focusing specifically on the Copy Activity. The key topic here is understanding the performance differences between loading data one file at a time versus loading an entire folder of… Read More

Discover the Power of Power BI Custom Visuals

Welcome to an exciting, completely free training series launching today! Over the next year, I will release one detailed module each week, guiding you through how to maximize all the amazing Power BI visuals available in the Custom Visuals Gallery. You may wonder why I’m dedicating so much time to this. Well, Microsoft’s Power BI… Read More

Understanding Azure Subscriptions: How They Work

Steve Hughes breaks down the essential structure behind Azure subscriptions in this Azure Every Day feature. Navigating through tenants, subscriptions, and user accounts in Microsoft Azure can be confusing, but grasping the organizational hierarchy is key to managing your cloud resources effectively. Foundational Framework: Understanding Your Azure Hierarchy In the intricate world of cloud architecture,… Read More

Introducing the New Outlook Activity in Azure Data Factory Pipelines

Austin Libal,trainer, presents the exciting new Outlook activity feature within Azure Data Factory pipelines, now integrated into Microsoft Fabric. This addition greatly enhances data orchestration and monitoring by bridging Data Factory with Microsoft Outlook email capabilities, complementing services like Synapse Analytics, real-time analytics, data science, and Power BI. Unlocking the Benefits of Microsoft Fabric Integration… Read More

Modern Data Architecture for Azure Business Intelligence Programs

Back in 2012, when terms like “road map” and “blueprint” were common, I first created a data architecture diagram focused on traditional BI tools like SSIS, SSAS-MultiD, and SSRS. Today, with the rise of cloud computing, our data landscape has shifted dramatically—even though we still operate on the core principle of moving data from source… Read More

Optimizing SSIS Performance within Azure Data Factory

If you’re starting out with SQL Server Integration Services (SSIS) in Azure Data Factory (ADF), you might notice that some SSIS packages take longer to execute compared to running on-premises. In this guide, I’ll share effective and straightforward techniques to boost the performance of your SSIS packages in ADF based on real-world experience. Maximizing SSIS… Read More

Comprehensive On-Premises Reporting with SQL Server Reporting Services 2016

Microsoft SQL Server Reporting Services (SSRS) 2016 delivers an all-in-one reporting platform that supports traditional paginated reports, mobile reports, and business intelligence (BI) analytics. This latest version introduces numerous improvements that make it the most robust release to date. Revolutionizing Reporting with the Modernized SSRS 2016 Web Portal The release of SQL Server Reporting Services… Read More

Explore the Circle KPI Gauge Custom Visual for Power BI

In this comprehensive tutorial, you will discover how to utilize the Circle KPI Gauge, a powerful Power BI custom visual designed to represent a single measure value through a visually appealing circular gauge. This guide will walk you through the core features, customization options, and practical applications of this visual. Comprehensive Guide to Mastering the… Read More

Enhancing Data Governance with Power BI Premium

Data governance has become a crucial focus for organizations, especially those managing complex BI environments. During my recent BI engagement in New York’s financial district, the importance of well-governed data stood out more than ever. Fortunately, Microsoft offers robust features in Power BI Premium that support enterprise-scale data governance strategies. In this guide, we’ll explore… Read More

Understanding When to Use Azure Logic Apps vs Azure Functions

If you’re new to the Azure cloud platform, choosing between Azure Logic Apps and Azure Functions can be confusing at first. Both are powerful tools used for automation and integration in cloud workflows, but they serve different purposes. This guide provides clarity on what makes each service unique, how they work together, and when to… Read More

Step-by-Step Guide: Connecting Azure Databricks to Azure Blob Storage

In this continuation of the Azure Every Day series, we’re diving into how to seamlessly connect Azure Databricks to an Azure Storage Account, specifically using Blob Storage. Whether you’re new to Databricks or expanding your Azure knowledge, understanding this connection is critical for managing files and datasets within your data pipeline. This tutorial will walk… Read More

Visualizing Data Distributions with Dot Plot by MAQ Software in Power BI

Custom visuals are a powerful way to extend the capabilities of Power BI, and one such visual worth exploring is the Dot Plot by MAQ Software. This visual offers a unique and intuitive method for showcasing the distribution of data points across multiple categories using individual dots, making it ideal for comparative visual analysis. Understanding… Read More

A Deep Dive into Azure Data Factory Pipelines and Activities

Azure Data Factory (ADF) is a powerful cloud-based ETL and data integration service provided by Microsoft Azure. While many are familiar with the pricing and general features of ADF, understanding how pipelines and activities function in Azure Data Factory Version 2 is essential for building efficient and scalable data workflows. If you’ve used tools like… Read More

Understanding Import and DirectQuery Storage Modes in Power BI

Choosing the right storage mode in Power BI, SQL Server Analysis Services (SSAS) Tabular, or Azure Analysis Services can have a significant impact on your model’s performance, flexibility, and scalability. The two primary options — Import Mode and DirectQuery Mode — each come with advantages and limitations that must be carefully considered based on your… Read More