Power BI

RANKX is a simple function used to rank a value within a list of values. Its use is simple, but it can be a source of frustration for newbies. In this artic

In a previous entry I explained at length the various ways to secure data in business intelligence products. In this follow-up I want to elaborate on which method(s) to use for what purposes. RLS vs. OLS vs. DDM Row Level Security (RLS) is meant to restrict the depth of what any specific user or group

This article describes how to enable the cross-highlight in Power BI charts using different dates for the same event, such as Order Date and Delivery Date.

Create Power BI Metrics (goals) scorecards

Ways we can get to the total's row in Table or Matrix visual using HASONEVALUE & INSCOPE functions in Power BI

Learn the difference between DirectQuery mode and Live connections in Power BI

Share the article

Just a joke. But it opens great data visualization possibilities. Everything (almost) is possible. You know the rules. Use arrows to move around the visual. … Read More

In this post I just wanted to show the ability to use the Delta Lake format that is very common now with Power BI. I will go over a quick example of creating the files to reference, building a view…

This step-by-step blog walks you through how to load large datasets in Power BI Desktop using parameters.

How to create a DAX measure to notify users filters have been applied to a report when there are hidden slicer or filter panels.

Writing Tabular Editor C# Scripts in Visual Studio has many benefits, on top of all Intellisense. This article walks through the configuration process.

One of the fundamental things missing from Power Bis visualisation capabilities is the ability to easily control data labels. Having to resort to hacks is not ideal but if good data visualisation i…

I'm going to start this blog post with a very strong statement: Bookmarks are the best thing since sliced bread! Yes, I know some of you are not a fan of this incredible feature, but hopefully I can change your mind with this blog post. I feel that for you to like bookmarks, you really need to know all the ins and outs of it, otherwise it can be quite overwhelming, specially if you have to create loads of bookmarks in the same report. First, a little definition of what are bookmarks in Power BI:

Something I do all the time when performance tuning Power BI is use SQL Server Profiler to monitor query and refresh activity. There’s a handy external tool that lets you open up Profiler wit…

Deep dive into Analysis services 2022 new features deep dive part 1: Composite Model and DAX

A new feature for Deployment pipelines, Deployment History, allows you to review details of all your recent months deployments – who, what and when. Check it out! Also, download our Azure DevOps extension now having general availability, and be aware our UpdateApp API now excludes adding new items to Apps.

Hello Power BI community, Something amazing is coming! and we need your help to transform the future of data visualizations in Power BI. Our goal is to learn…

This blog post shows you how to use the DAX function EvaluateAndLog and how to use the DaxDebugOutput app with Power BI to view the results

I love Power BI community for the inspiration it gives. Today after reading this LinkedIn post by Jan Schroeven I realized that if Power BI … Read More

Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a certain rate on your savings. Let's say 1% (which is at the time of writing ridiculously high, but bear with me). After 1 year, you get 1% interest

Explore a few proven strategies for setting up workspaces for your Power BI Premium Per Capacity (PPC) in this insightful blog. Read today!

If you’ve worked in tech for 25 years, you’ve seen some stuff, and you’ve learned a lesson or two. On October 1st, I presented a new session at Data Saturday Atlanta, sharing the …

I love the Power BI community. There are so many great things that the community does. They help each other (think the Power BI community forum) and they also build fabulous third party external tools to enhance Power BI. Measure Killer This week I am sharing a brand new third [...]Read More »

Power BI is a powerful tool that has also enabled millions of people worldwide to easily visualize & explore their data. Despite that, inflexibility to the visualization configuration and formatting can make it difficult to fulfill visual requirements. What are some of the biggest feature g

Here’s our September release of the on-premises data gateway! As always, stay up to date for the latest functionality.

✨A new DAX function that is already available in the September release of #PowerBIDesktop, but was hidden in the last updates announced in September. ✨#OFFSET allows to make comparisons in context between two values, without writing extremely long and complex

Blogging about Power BI, Power Platform and other things I find interesting.

In September 2014, I wrote a blog post on dynamically passing parameters from PowerPivot to a SQL Server stored procedure using VBA. Back then, VBA was a real lifesaver. It perhaps still is for many of us. But frankly, I even forgot how to write VBA. Maybe it is time to look at it again. … Continue reading Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query