Tabular Editor

Power BI

7 de julio de 2025

"Copy visuals between reports" and "prepare a report to make it bilingual"

Hello again. Today I'll introduce two new Tabular Editor C# Scripts that might help you at some point if you are already using the PBIR format (which is in preview, so don't rush it!). The first one is to copy a visual, which at first does not look impressive, but remember that swapping fields in[.....

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 →

Esbrina, Power BI

16 de mayo de 2025

C# Scripting Nirvana v2.0: Now with Reporting Layer!

learn how to build c# scripts for the reporting layer with an existing report that allows parsing the whole pbir report into an structured c# object

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

8 de octubre de 2022

Writing Tabular Editor C# Scripts like a Boss

A few months back I wrote an article of what I thought would change the way I (and many more I thought) would write c# scripts from now on. In that article I explored the possiblity of creating a custom dll with all the classes and methods that would make my scripts shorter, more robust[...]

Leer post →

Power BI

21 de mayo de 2022

Creating Filtered Measures, or how to show the total along with the detail in a chart.

It's a terrible title, but by the end I hope it makes sense Today I had some spare time and I thought I would do some c# that is always good to keep your mind going. The goal was to create a script that given a base measure, you can then specify a column and[...]

Leer post →

Power BI

16 de marzo de 2022

Easy Management of Referential Integrity

Referential what? it sounds weird, but it's a rather basic thing: It's like asking, do you have all the product IDs of the sales table in your product table? If you don't, then is when that infamous "blank" appears in slicers and all kind of bad things start to happen. Unless you load everything fro...

Leer post →