Power BI

Final thoughts on Data Quality

Hello P3 Adaptive Nation! Happy New Year, ring out the old and ring in the new! Speaking of ringing in the new, with all the hustle and bustle associated

My recent posts have focused on the importance of understanding both the problem domain and solution domain in which you’re working, the value of operating in both the problem domain and the …

Charting time magnitudes and displaying hours and minutes in the data label is not straight forward in Power BI, but can be achieved with a Calculation group

Incremental refresh with non-foldable data sources are not recommended, but if you can retrieve just some period of data, it's possible to do it.

This month we have released highly-anticipated features for deployment pipelines: Azure DevOps extension, to automate your deployments and pipeline creation using Tasks in your Azure pipeline. Multiple pipelines working together, to sync the connections between items managed in different pipelines. Dataflows GA and support for linked entities

Log Analytics contains information on the dataset, report and visual that are associated with a DAX query but that information is in the form of IDs rather than names. Getting the IDs for specific …

In the first part of this series I showed how to create a Power BI DirectQuery dataset connected to Log Analytics to do near real-time monitoring of Analysis Services activity; in the second part I …

These brief definitions of the topics need to be addressed in data quality. By no means is this an in-depth list of Data Quality terms, nor are they fully defined.

n late 2021, the Charticulator visual was added to Power BI desktop. This post walks through creating a Charticulator Simple Custom Chart.

If you’re reading a Power BI-focused blog[1] you’re probably someone who builds solutions. As a BI and data practitioner, you may build reports, datasets, dataflows, databases, or any n…

Describes advanced incremental refresh and real-time data features with the XMLA endpoint.

Dread of data misuse has spread through all kinds of organizations since the General Data Protection Regulation went live in May. The legislation hasn't done much to lighten the already drab image of

Let’s be clear — we do not intend to bury data governance, but rather to place it within the context of a more comprehensive approach…

Learn what is the Sparkline and how to add it into a Power BI report using real-world demos and examples of configuring it.

Power BI is strongest for its built-in Power Query ETL and powerful Vertipaq tabular engine, but it’s not renowned as the crispest visualization tool on the commercial BI scene (most people w…

Now more than ever, companies are striving to make data-driven decisions. With the vast amount of data at our fingertips, one can easily mistake the quantity (or speed) of the data available for the value derived from the data.

Creating a Custom DLL for Tabular Editor C# Scripts and moving development over to Visual Studio can help you code faster c# scripts for Tabular Editor

Useful code for tabular modeling and automation. Contribute to m-kovalsky/Tabular development by creating an account on GitHub.

Seventeen ways to improve data viz from 1915.

MicrosoftHatesGregsQuickMeasures Installation How to Use NotesAn external tool for creating quick measures or columns in Power BI Desktop or tabular model. Read more about it here Microsoft Hates …

I have written quite a few articles about Tabular Editor over the last few years. I recently started using Tabular Editor 3, and I absolutely love it. Buying this product is one of the easiest ways you can significantly improve your Power BI Data Modelling productivity. For US$100 per year [...]Read More »

As a Power BI administrator you want to see what’s happening in your tenant right now: who’s running queries, which datasets are refreshing and so on. That way if a user calls you to co…

Late last year I was spending some vacation days playing with one of my favorite personal data sets[1], and I realized I needed a better date dimension. So I asked for one. A bunch of folks from th…

When used in a composite model, calculation groups show a very unique behavior that a good DAX developer must understand well to build sound models. In this