Power BI

Time to read: 5 minutes Have you ever wanted to search through your Power BI measures, calculated columns or calculated tables for a specific function or table/column reference? Or export your DAX logic for documentation purposes? If this is the case then this post is for you. As a Power BI dataset admin or author, ... Read more

Over the past few days, I attended the Power BI Next Step conference in Lego land – Denmark. During the keynote, Will Thompson – PM on the Power BI team, showed a new DAX function that …

Have you ever wondered how people do the trick below? Say no more! I'm going to share with you all the tricks that you need to do to achieve something like this. In my example, I created a report where you could switch the measure the charts were showing, and with that, the color of the charts and KPI cards changed to. The first thing you need to do is create your base measures. In my example my base measures were: Number of Orders = count(Amazon[Order ID]) Orders Value £ = SUM(Amazon[Amount]) I

Unpack all the new automation and functionality of Data Source, phData's newest tool from its Toolkit that helps with migration validation.

Query FoldingQuery Folding AuditFunction 1: __QFIndicatorFunction 2: __QFAuditQuery FoldingI will assume you already know what is query folding. If you don't, please read this documentation or watch …

A direct-to-consumer omnichannel retailer, Lenskart, is one of the fastest-growing e-commerce-led eyewear retail chains in the world. It has over 1,100 stores in India and a growing presence in East Asia, Southeast Asia, the Middle East, and the US.Lenskart aims at giving a clearer vision to 1 billion people globally from children to adults. Its eyewear range offers a variety of lifestyle extensions and unique identities for athletes, working professionals, artists, support workers etc.

Last week, we learned how to interpret the output of the EvaluateAndLog function of scalar expressions. Albeit interesting, the new function would be much less useful if it could only return scalar…

In the last post in this series I showed how to get the status of an individual Power BI dataset refresh. In this post I’ll show how to get the history of a dataset’s refreshes and save…

Every day businesses are making a host of decisions—big and small. Increasingly, many of these decisions are being informed or guided by data. This article examines several potential pitfalls that can prevent data-driven decision-making (DDDM) from delivering on its full potential.

Every day businesses are making a host of decisions—big and small. Increasingly, many of these decisions are being informed or guided by data. This article examines several potential pitfalls that can prevent data-driven decision-making (DDDM) from delivering on its full potential.

This blog post shows how to use a Power BI DAX query to extract data and then email it out to users using Power Automate

The Switch function is often a cause of performance problems in DAX. Last year a number of optimisations were made that fixed the most common issues (and as a result you should ignore older blog po…

Using Azure Blob Storage learn how to quickly pre-load data into production data models.

Support for the DAX UserCulture function in Power BI Premium is now available.

We are excited to announce the initial release of a query performance optimization aimed at processing Data Analysis Expressions (DAX) queries more efficiently, known as “Horizontal Fusion”.

Announcing public preview on managing Power BI reports and datasets native components in Power Apps Solution

Field parameters are great for dynamic legends, but the creation of a dyanmic measure + time intel chart can be time consuming. Most of it can be automated.

When it comes to Snowflake, data sharing is one of the important features that stands out from other competitors. This feature is so catchy as data sharing is something most organizations are strug…

This is the fourth and the last article on the EvaluateAndLog function. While DAX developers were excited about the prospect of printing the values of a portion of a DAX expression, many of the ear…

In this blog post, I'm going to share with you a recent success story from one of my customers. For privacy reasons I can't mention the customer itself, but I will give you a little overview of the company and the kind of industry they are in. With this success story, I hope I can inspire readers and customers to think more carefully about their design choices when building reports in Power BI. COMPANY OVERVIEW Customer: Recruiting Analytics (for privacy reasons, I can't reveal the real name of

You want to return the nth business day from a date in Power Query. And this offset should take into account holidays and weekends. It's a common requirement

Learn how to use Timeline Visual in Power BI to show data per date in a timeline format | Horizontal Timeline in Power BI | Virtical Power BI Timeline visual

This article provides information on how to enable query folding against queries that use the Value.NativeQuery function.

With conditional formatting and a few calculation groups it's possible building a fading bar chart, even assigning colors to categories by code.

Defining different formats for values and totals in Power BI can be achieved with the use of a calculation group which will reuse the original format string.

The task of creating calculation groups to active calculation groups can be automated with a C# Script. This script contains custom classes.

Last months I did a presentation for the well-known Club Power BI (Brussels). This session was a brief listing of the most exciting External tools / Third-party software that can help us to work with Power BI. As a Power BI passionate guy, I wanted to be sure to show and explain my favorite applications. […]