Power BI

Power BI is a great reporting tool to reflect inventory values at a specific point in time and then filter the values by different dimensions. At the same time, the user can assess the levels of inventory values across different time periods as well as see key inventory management ratios.

Our Power BI Principal Consultant Kane Snyder shares a technique for optimising calculation group performance.

Using ALLSELECTED with no arguments in a remote model later used in a composite model might produce unexpected results. In this article we examine the topic

Data Quality is not something that 'just happens.' Data Quality takes a great deal of work from a wide variety of different roles.

The Quality Framework will address these dimensions of quality across these different levels and comprise In-Line, Off-Line tests, and automatic fallback processes.

Data platforms do not spring forth fully built and operational. They take time to develop and build out. The same is true for a Data Quality practice.

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 …

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 »