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”
Author Archives: Alexander Korn
Power BI FIXER – Holy Grail of Power BI
I am super stocked to showcase a new script. The script is the banger, since it can modify and improve massively already deployed Power BI reports, within just a few minutes. Just run the script and all reports of one Power BI workspace are automatically upgraded. This is definitely an extension to my previous PIMPContinue reading “Power BI FIXER – Holy Grail of Power BI”
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”
“IBCS Power BI Generator”: Automate your Power BI report development
DISCLAIMER: You are running the tool at your own risk. The tool is currently deleting and replacing all current report pages, including all visuals. So make sure to have a backup. I continuing to develop the tool as we speak. This is hopefully just a start. Manual Introduction In today’s data-driven business environment, the needContinue reading ““IBCS Power BI Generator”: Automate your Power BI report development”
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”
Myths about Red-Green Deficiency in Visualizations
Disclaimer: I am not an “Ophthalmologist”, so don’t cite me here and if you actually have a red-green blindness and/or disagree on the following article please ping me via LinkedIn. It is not as simple as it seems. 😊 Color is a crucial element in data visualization and communication, significantly impacting how effectively information isContinue reading “Myths about Red-Green Deficiency in Visualizations”
Blog about Actionable Reporting - Alexander Korn 