How to Configure Parameters for Power BI Reports: A Step-by-Step Demo
Parameters in Power BI act like dynamic variables that you can adjust anytime to control what data is loaded and displayed in your reports. By setting parameters, you empower yourself and your end-users to filter data efficiently and customize report content based on specific needs. When building Power BI reports and dashboards, optimizing data load… Read More
Overview of Visual Studio 2019 Business Intelligence Design Tool Extensions
Microsoft recently launched Visual Studio 2019, bringing some changes to how Business Intelligence (BI) design tools are installed and managed. In this article, Bob Rubocki explains the updated process for installing the BI Designer tools, which were previously part of SQL Server Data Tools (SSDT), and how these changes affect BI developers. Visual Studio 2019… Read More
Introduction to DAX VALUES Function in Power BI Virtual Tables
Jeremiah Hersey kicks off his insightful 6-part series on Virtual Table functions in Power BI Desktop with an in-depth exploration of the DAX VALUES function. This video tutorial explains how the VALUES function operates in different contexts, making it a foundational concept for effective DAX programming. The VALUES function in DAX is a versatile tool… Read More
Mastering the PL-300 Power BI Data Analyst Certification
Join Angelica Domenech in this comprehensive free session designed to help you successfully conquer the PL-300 Power BI Data Analyst Certification exam. Gain valuable insights into the exam structure, question formats, study strategies, and essential tips to boost your confidence and performance. The Microsoft PL-300 Certification Exam, formally known as “Microsoft Power BI Data Analyst,”… Read More
Mastering SQL Set Operators: A Comprehensive Guide by Austin Libal
In this article, SQL expert Austin Libal takes you on a deep dive into SQL set operators. Learn how to effectively use set operators like INTERSECT, EXCEPT, and UNION to combine and filter your data more efficiently. Whether you’re managing customer records or analyzing product sales, these techniques will optimize your SQL queries and improve… Read More
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