C# Script

Power BI
16 de septiembre de 2025

Automatically create measures with DAX user-defined functions

YES! Public preview is finally here, and DAX UDFs have the potential to change how we write DAX in a big way. If you don't know what UDFs are, head over to Microsoft (and SQLBI of course) and learn everything they have said about them first, no point in repeating it here. If you want[...]
Leer post →
Power BI
25 de mayo de 2025

Two new C# Scripts for PBIR: Replace Fields & Open Visual Json files

In comparison with my previous post, this one was an absolute breeze to write. Just an idea, some little tweaking with ChatGPT and GitHub CoPilot. Both come from the daily little miseries of daily with Power BI. One is replacing fields in a visual, the other one is finding the visual.json file of ce...
Leer post →
Power BI
14 de julio de 2024

Building a Referential Integrity Report Page with a C# Script

Hello again! I'm back with the other use case I have in mind for Report-layer scripts. If you haven't read yet my previous blog post I recommend you do this now as we'll be building on that with a more complex use case. When I first managed to develop C# in visual studio I rushed[...]
Leer post →
Power BI
12 de julio de 2024

C# Scripting the report layer with Tabular Editor

Hello! Today's post is quite special for me as I wished that this day would come. When I wrote the article to generate the measures for a dynamic data problems button there was a section that read "So, let’s build this button then. This part, unfortunately cannot be scripted, so we’ll need to work a...
Leer post →
Power BI, PowerShell
9 de diciembre de 2023

Building my first near real time model in Power BI

Hello! Today we leave PowerApps aside, but we head into yet another area way out of my confort zone: Programmatic creation and refresh of custom M Partitions! this is not something I really wanted to do, but I found myself with no other option available. Are you ready? Let's do it. As the title says...
Leer post →
Power BI
9 de julio de 2023

Industrializing Calculation Groups

Hello! Today (well yesterday by the time I have finished writing this) saw a great use case of calculation groups and I wished I had come up with the idea myself because it's awesome and something that I've come across sometimes. In a table there's a breakdown by month, and at the total they want[.....
Leer post →
Power BI
26 de enero de 2023

Dynamic headers in Power BI, sort of.

Well, I was happy with the result, but I was even more happy with the reaction on twitter. The dynamic header effect felt like magical to many people, and well, I have many more followers now, thank you all. In case you haven't seen it, here's the video So how did I do it? Short[...]
Leer post →
Power BI
10 de diciembre de 2022

The ultimate snapshot report (part 2)

Hello again. You didn't think there would be a second part, right? well, me neither. But as things turn out, I had to work on another report dealing with snapshots, and this time they wanted something fancier. It took me a while to figure it out, but I like the result so I thought it[...]
Leer post →