Implementing Dynamic Row-Level Security in Power BI

Are you looking to configure dynamic row-level security (RLS) in Power BI for users with different access levels? In this guide, Steve Wise walks you through setting up dynamic RLS where each user has customized permissions. For instance, one user may access the Northeast and Midwest regions, while others have access to the Southeast or… Read More

How to Calculate Working Days in Power BI Using DAX

In this tutorial, Mitchell Pearson demonstrates how to accurately calculate the number of working days within Power BI using DAX formulas. He walks through using a date table to count workdays, including how to incorporate holidays and customize weekend settings for precise business day calculations. Counting days accurately in Power BI is a foundational skill… Read More

How to Embed a Power BI Report into SharePoint: A Step-by-Step Guide by Jonathon Silva

In this tutorial, Jonathon Silva from walks you through the simple and effective process of embedding a Power BI report directly into your SharePoint site. This guide covers every step from setting up the SharePoint web part to customizing your report’s display for maximum impact. Integrating Power BI reports into SharePoint pages can significantly enhance… Read More

Four Powerful Yet Underused Power FX Formulas You Should Know

In this article, Nate Halliwell dives into some highly effective but often overlooked Power FX formulas that can elevate your Canvas app development. Whether you’re a beginner or an experienced maker, adding these formulas—IFERROR, SUBSTITUTE, COALESCE, and SWITCH—to your Power FX toolkit will greatly improve your app’s functionality and user experience. Creating a smooth and… Read More

Understanding Azure Data Factory’s If Condition Activity for Dynamic Pipelines

In this detailed guide, we explore how to effectively use the If Condition activity in Azure Data Factory (ADF) to control the execution flow based on dynamic conditions. Previously, in part one of this series, you learned to retrieve the last modified date of a file using the Get Metadata activity, and in part three,… Read More

Mastering the Sum Function and Collections in Power Apps: From Basic to Advanced Techniques

As a former Algebra and Algebra 2 instructor, I frequently worked with summing numbers—something we often overlook in Power Apps. Summing numerical values isn’t just essential for math teachers, Power BI analysts, or Excel users; it’s equally powerful within Power Apps to enhance your app’s data handling and interactivity. Step-by-Step Guide to Summing a Column… Read More

Essential Guide to Building a Date Table for Data Models and Warehouses

Creating a date table is a common need when designing data warehouses or building data models in tools like Excel’s Power Pivot or SQL Server Analysis Services. A well-structured date table allows you to efficiently analyze and aggregate data across various time periods. We recommend a method using a Common Table Expression (CTE) to generate… Read More

Mastering Advanced Filtering Techniques in Power Apps with Multiple Dropdowns

In my previous blog and video tutorial, I showed how to filter gallery records using a single dropdown control linked to a distinct column in your data source. This simple yet effective method helps users narrow down the displayed data easily. If you missed it, check out the video below. Mastering Advanced Filtering in Power… Read More

How to Save Multiple Attachments from Microsoft Forms to a SharePoint List Using Power Automate

In this step-by-step tutorial, Jonathan Silva from explains how to save multiple file attachments submitted through Microsoft Forms directly into a SharePoint list by leveraging Power Automate. This guide expands on the single-attachment process, detailing the necessary workflow adjustments to efficiently manage and store multiple uploaded files. How to Efficiently Manage Single and Multiple Attachments… Read More

Exploring the Future of Data Transformation: Dynamic Unpivoting Using PySpark in Databricks

In this comprehensive tutorial, Mitchell Pearson from demonstrates how to efficiently perform dynamic unpivoting in PySpark within the Databricks environment. The focus is on transforming data from a wide format with multiple columns into a streamlined, relational format that enhances analysis and reporting capabilities. Mitchell guides viewers through handling datasets with varying column counts, ensuring… Read More