Convert your MacroActions.Json file into a full repository of scripts, or do the reverse – convert a ZIP of scripts back into MacroActions.json. Here are two free tools for you: MacroActions to Scripts: Tabular Editor Scripts Extractor Scripts to MacroActions: Tabular Editor Parser – Zip to MacroActions Tool The Problem Managing Tabular Editor macros becomes chaotic asContinue reading “Two Tools Tabular Editor MacroActions.json to Full Repository and Vise Versa”
Category Archives: Allgemein
My Power BI Toolbox: 80+ Tabular Editor Macros to Automate Data Model Development
When it comes to streamlining your Power BI data modeling, the value of automation cannot be overstated. One of the most powerful tools available to achieve this automation is Tabular Editor, where you can write C# scripts to optimize and automate repetitive tasks. In this blog post, I’ll introduce you to my Power BI ToolboxContinue reading “My Power BI Toolbox: 80+ Tabular Editor Macros to Automate Data Model Development”
Spot Poor Power BI Reports: No4. No “EMPTY MEASURE TABLE”
When building Power BI reports, deciding where to place your measures—whether in a dedicated measure table or directly in the fact table—can impact both usability and maintainability. Here’s a look at why creating a separate measure table often works best and why it’s becoming a popular approach for Power BI developers and report consumers alike.Continue reading “Spot Poor Power BI Reports: No4. No “EMPTY MEASURE TABLE” “
Spot Poor Power BI Reports: No3. No Units Calculation Group
When working with large datasets in Power BI, displaying big numbers—especially those over a million—can become a challenge. Lengthy figures not only clutter your visuals but can also confuse your audience. To enhance readability and comprehension, it’s essential to format these numbers into thousands, millions, or even billions. While Power BI offers several methods toContinue reading “Spot Poor Power BI Reports: No3. No Units Calculation Group”
Spot Poor Power BI Reports: No2. The Lonely Fighter
Okay this is not exactly a poor Power BI report or mistake per se, but might be just one contributing factor for your “poor Power BI report”. Have you learned your Power BI skills mostly by yourself via YouTube, reading through the endless Microsoft documentation, or some “secret blog article” like mine? 😉 Here isContinue reading “Spot Poor Power BI Reports: No2. The Lonely Fighter”
Spot Poor Power BI Reports! No1: The Slicer Mess
This article is part of a series on how to spot a poor Power BI report. There are many pitfalls, which are obvious like 3D Pie Charts, but then there are others which are less obvious. We all have done those mistakes, we actually all of us make some of those still every day, awareContinue reading “Spot Poor Power BI Reports! No1: The Slicer Mess”
ULTIMATE LinkedIn Power BI Report Template: Insights & CV
You want to jump right into, what the report looks like than go here: https://app.powerbi.com/view?r=eyJrIjoiMDNiOTMyZDgtNjA3ZS00ODJhLTgyYmQtMWUyMTVjM2Y4OTJlIiwidCI6IjllYTUzNDRiLWFiMzAtNGNjYi1hOWFjLThlODU4NWU1ZWZhZSIsImMiOjl9 In the digital age, the ability to analyze your professional network and present your career accomplishments can significantly impact your success. Two distinct yet interconnected areas where Alexander Korn has excelled are the analytics of LinkedIn engagement and the automationContinue reading “ULTIMATE LinkedIn Power BI Report Template: Insights & CV”
Power BI – Pimp – Script
Do you would like to apply data model best practices with a click of a button to your existing Power BI reports? Than the “PBI-Pimp-Script” is the right place for you! Edit: This script had a major revamp, published on 31. January 2024 and includes now a lot more: Explicit Measure Creation, Units calc group,Continue reading “Power BI – Pimp – Script”
Must-Have Certifications for a Power BI Expert
In today’s rapidly evolving world of data analytics, certifications have become a valuable tool to showcase one’s expertise and knowledge. As a Power BI expert, you understand the importance of staying ahead in this competitive field. But which certifications are essential for a Power BI professional to possess? In this article, we will explore theContinue reading “Must-Have Certifications for a Power BI Expert”
My Top 10 Tabular Data Model Best Practices
This article heavily relies on the information of Michael Kovalsky’s blog article “Top 10 Power BI mistakes and their best practice solutions” published on his website elegantbi.com. The last three points are additions to Michael’s article, focused more on data model best practices, less focused on data model performance. When working with Power BI, creatingContinue reading “My Top 10 Tabular Data Model Best Practices”
Blog about Actionable Reporting - Alexander Korn 