Field parameters are a great way to give your end users the ability to customize their reporting experience in Power BI. The possibilities are enormous! Let’ me show you how easily you can make a customizable report using Field parameters and bookmarks! Imagine a dataset like this: Head into Power BI Desktop, to the modeling […]
Many years ago I made a DAX calendar blogpost. I’ve been using that calendar table for many reports since then. Now it’s on like page 4 of the blog or something and it’s annoying to make all the clicks needed to get to it. Clearly the best solution is to make a new blogpost and […]
Yes, you read the title correct. I know you might think “but.. RLS will remove the rows completely, not just filter it out”. Let me just outline the use case before I jump into the creative solution. You have a report. Users look into this report and they’re allowed to see data that regards other […]
When we talk about RLS, the first thing that comes to mind might be to set rules like “if your username matches this, you can see ‘your own’ data” or we’ll make a rule that simply says “Company = Contoso” and then we have to put people in that roles to make them see Contoso. […]
We all strive for what really matters in life, enriching data, so I understand that I already preach to the choir with this blog post 😉 If you are however in that outlier percent of people with other, weird, interests in life, let me introduce you to what I mean by “Observation Table” and why […]
I woke up one morning and had the urge to create a Power BI template for Prompt Buddy. You know how it is. This is not the story of how you install it. The Power BI Template file can be found on GitHub from the link above including installation instructions. This is the story of […]