Episode Details

Behind every great Power BI solution is more than just dashboards and data models. There is logic, automation, storytelling, optimization, architecture, and most importantly — community. In this episode of the m365.fm podcast, Mirko Peters sits down with Bernat Agulló Roselló, Microsoft MVP, Senior BI Developer Partner at Sabrina, Tabular Editor contributor, organizer of the Power BI & Fabric Barcelona User Group, and one of the most passionate voices in the Power BI community today. From DAX optimization and semantic model automation to community building and multilingual collaboration, this conversation explores the technical depth and human side of modern Business Intelligence. Bernat shares his journey from Excel macros and reporting automation to becoming a recognized expert in DAX, Tabular Editor scripting, semantic modeling, and enterprise Power BI development. But this episode is not just about technology. It is also about curiosity, learning, international experiences, and the incredible role that community plays in shaping careers, opportunities, and innovation across the Microsoft Data Platform ecosystem.

THE JOURNEY FROM EXCEL TO POWER BI

Bernat’s BI journey started long before he officially realized he was working in Business Intelligence. While working with Excel macros inside manufacturing environments like Nissan, he was already building reporting automation, aggregating data from multiple sources, and solving business reporting challenges long before terms like “semantic modeling” or “data warehousing” became part of his vocabulary. Eventually, after reading Kimball’s Data Warehouse Toolkit and diving deeper into BI concepts, Bernat recognized that he had already been practicing many foundational Business Intelligence principles for years. This realization sparked a deeper passion for analytics, Power BI, DAX, automation, and semantic modeling that continues today. 

WHY DAX CHANGES EVERYTHING

One of the strongest technical themes throughout the episode is DAX — Data Analysis Expressions — the language behind Power BI calculations and advanced analytics. According to Bernat, one of the biggest misconceptions people have about DAX is assuming it behaves like Excel formulas. In reality:

• DAX depends heavily on semantic models
• Relationships are critical
• Filter context changes everything
• Measures and calculated columns behave fundamentally differently
• Understanding context transition is essential

Bernat explains how learning the foundations of DAX and semantic modeling completely changes how developers approach Power BI solutions. He strongly recommends that anyone serious about Power BI eventually studies “The Definitive Guide to DAX” by Marco Russo and Alberto Ferrari — a book that fundamentally shaped his own understanding of the platform.

THE POWER OF TABULAR EDITOR

Another major focus of the discussion is Tabular Editor and why it has become one of the most important tools for advanced Power BI and semantic model development. Bernat explains how Power BI Desktop works well for getting started, but as enterprise semantic models become larger and more complex, development workflows quickly become difficult to manage. Tabular Editor enables developers to:

• Manage large semantic models efficiently
• Edit measures faster
• Access advanced model properties
• Work with calculation groups
• Build reusable automation scripts
• Improve semantic model governance
• Optimize development workflows
• Automate repetitive tasks

For advanced BI developers, Tabular Editor becomes a critical productivity multiplier.

AUTOMATION IS THE FUTURE OF POWER BI DEVELOPMENT

One of the most exciting parts of the episode focuses on automation using C# scripting, Tabular Editor, and semantic model tooling. Bern