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”
Tag Archives: Business Intelligence
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! 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”
The Hammer for your Power BI Report Server Issues
For many IT admins, troubleshooting a Power BI Report Server can be a daunting task. With so many potential sources of error and so much data to collect, it can be difficult to know where to start. Fortunately, the Power BI Report Server Troubleshooting Tool is here to help. Think of this tool as aContinue reading “The Hammer for your Power BI Report Server Issues”
Power BI Report Server Monitoring Tool
As a support engineer, we often receive requests for usage, audit, or monitoring reports for Power BI Report Server. Sometimes, there are support requests, users could easily self-resolve themselves if they would just have the right tool. For Power BI Service there are audit and monitoring templates available, but for Power BI Report Server thereContinue reading “Power BI Report Server Monitoring Tool”
Power BI Report Server Monitoring for Subscriptions and Schedule Refreshes
As a Power BI Report Server Administrator, it is crucial to monitor the performance of your report server and keep track of your subscriptions and schedule refreshes. Inefficient utilization of report server capacity is a common issue, for instance, when there are specific periods of high server load and others with minimal activity. This canContinue reading “Power BI Report Server Monitoring for Subscriptions and Schedule Refreshes”
The Importance of Actionable Reporting in BI & Reporting Best Practice IBCS
Business Intelligence (BI) is a powerful instrument that can help organizations make better decisions and improve the company’s performance. However, very often I encounter poor BI reports with little to no insight. The assumption in this article is that poor reporting does not stem from an intent to deceive or misinform the report’s target audience.Continue reading “The Importance of Actionable Reporting in BI & Reporting Best Practice IBCS”
Blog about Actionable Reporting - Alexander Korn 