YTD Flags in Power Query

YTD Flags in Power Query What are YTD Flags in Power Query? Dates tables are an integral part of creating data models in Power BI. Dates tables allow you to normalize a variety of different date fields and perform calculations … Read More

Import v Direct Query: Here’s What You Need to Know

Import v Direct Query: Here’s What You Need to Know When connecting to data in Power BI, you need to choose whether you want to use Import or Direct Query mode for connecting to your data. Using the Import method, … Read More

Page Navigation in Power BI

Page Navigation in Power BI Enabling users to sensibly navigate your Power BI reports is crucial for providing users with a great user experience. Luckily, there are a variety of ways to do this in Power BI.  In this blog … Read More

Optimizing Power BI Reports

Optimizing Power BI Reports Why is it Important to Optimize Power BI Reports? When developing reports in Power BI Desktop (or any software for that matter), good performance in terms of load time is important for gaining trust with stakeholders … Read More

Power BI Beginner Basics: How to Create Toggle Switches and When to Use Them

Power BI Beginner Basics: How to Create Toggle Switches and When to Use Them This blog series, Power BI Basics, is for those new to Power BI, who have a lot to learn, and a lot to digest. I hope … Read More

Power BI's Sum vs. Sumx

Power BI’s SUM vs SUMX: What’s the Difference, REALLY?

Power BI’s SUM vs SUMX: What is the Difference, REALLY? For many Power BI developers, the difference between the DAX functions SUM and SUMX can be a confusing topic. Though they are similar, there is a big difference, and if … Read More

How to Process Batch Data in Power BI

How to Process Batch Data in Power BI What is Batch Data? Organizations produce, consume, and store large amounts of data. Batch data is extracted once or in batches (for instance hourly or daily). It is then transformed, stored, and … Read More

How to Parameterize Data Sources in Power BI

How to Parameterize Data Sources in Power BI Introduction When developing Power BI reports for projects, you will find that switching over data sources from development to production can often be tedious if there are a lot of queries. Parameters … Read More

How to Export Data from Power BI to Excel

How to Export Data from Power BI to Excel For many teams that use Power BI shared workspaces, having the ability to export the data in their reports and dashboards directly to Excel is crucial. This feature is important because … Read More

Slicers vs. Filters: The Difference and When to Use Them in Power BI

Slicers vs. Filters: The Difference and When to Use Them in Power BI Slicers and filters in Power BI may look like they do the exact same thing, and in many cases, they can accomplish the same task, but understanding … Read More