Plenty to read!
Let’s set up some basic Source Control in Power BI, with Tabular Editor, Azure DevOps/Git & Visual Studio!
In this post, I give a brief step-by-step tutorial on setting up basic Source Control in Power BI, and explain how Tabular Editor helps your source control in Power BI, by leveraging the TE folder structure save format.
It’s no big secret that source control is challenging in Power BI.
There are few native tools which enable source control in Power BI, allowing you to track changes and work collaboratively with colleagues on a Power BI dataset. Thankfully, however, external tools make this quite easy, for example, leveraging the folder structure save format of Tabular Editor.
This post is a simple introduction to source control as it pertains to a Power BI dataset, and how to set it up.
If you want to learn Tabular Editor, this is a good place to get started. This is a walk-through of some basic settings and uses of the tool, including how to find your way around and customize the user interface, and create, modify and organize objects in the model.
The default Cards & KPI visuals are frequently the first visual a report user will see. It is thus important that they contain meaningful values. Unfortunately, for many users, a (Blank) is not meaningful, either because it is not understood, or they expect to see 0, instead. Here I explain how you can easily hide these blanks with conditional formatting, or a few methods to replace the (Blank) with 0.
Tabular Editor is a must-have tool for making better data models faster in Power BI. However, there are 4 licenses, which have their own costs or limitations. I frequently get questions from colleagues and clients about which they need, or what the difference is.
To make this easier I’ve built an interactive Power BI guide to the Tabular Editor licenses.
Tabular Editor (TE) is a powerful, high-quality, external tool for Power BI & AS Tabular Models that helps you make better models more effectively. Since adopting TE in my Power BI workflow, time on dev tasks has been reduced ~60% compared to when I used Power BI alone. What is this tool, exactly, and how can it help us develop better Power BI data models?
In this article we look at how to format all DAX in Power BI datasets at once. With the push of a button your DAX will be formatted using these C# scripts! Save them as macros and never waste time formatting again.
In this article, we examine a method to automatically monitor & test data quality in Power BI by setting up a composite model to detect data changes.
In this article we look at how to get Microsoft Tasks / Planner data into Power BI, to make analytical reports from our operational Planner boards.
In this article we look at a method for creating waffle charts in Power BI with the default visuals.
In this article, we look at a method to format a single data point in a Power BI visual. Specifically, we look how to label the latest data point in a line chart. This method also works with individual formatting of other data points.
In this article we look at how to have dynamic dimensions in Power BI so that users can choose fields that appear on visual axes, table rows or other categorical elements.
In this article we examine a method to create dynamic hierarchies in Power BI. This is particularly useful for creating ‘details-on-demand’ matrixes; interactive pivot tables in Power BI.
In this article, we look at a way of creating a folder-tab navigation experience using the KPI and Card visuals. Users click on the KPI or Card and then get more details for that metric.
