Power BI

Writing Tabular Editor C# Scripts in Visual Studio has many benefits, on top of all Intellisense. This article walks through the configuration process.

One of the fundamental things missing from Power Bis visualisation capabilities is the ability to easily control data labels. Having to resort to hacks is not ideal but if good data visualisation i…

I'm going to start this blog post with a very strong statement: Bookmarks are the best thing since sliced bread! Yes, I know some of you are not a fan of this incredible feature, but hopefully I can change your mind with this blog post. I feel that for you to like bookmarks, you really need to know all the ins and outs of it, otherwise it can be quite overwhelming, specially if you have to create loads of bookmarks in the same report. First, a little definition of what are bookmarks in Power BI:

Something I do all the time when performance tuning Power BI is use SQL Server Profiler to monitor query and refresh activity. There’s a handy external tool that lets you open up Profiler wit…

A new feature for Deployment pipelines, Deployment History, allows you to review details of all your recent months deployments – who, what and when. Check it out! Also, download our Azure DevOps extension now having general availability, and be aware our UpdateApp API now excludes adding new items to Apps.

Hello Power BI community, Something amazing is coming! and we need your help to transform the future of data visualizations in Power BI. Our goal is to learn…

This blog post shows you how to use the DAX function EvaluateAndLog and how to use the DaxDebugOutput app with Power BI to view the results

I love Power BI community for the inspiration it gives. Today after reading this LinkedIn post by Jan Schroeven I realized that if Power BI … Read More

Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a certain rate on your savings. Let's say 1% (which is at the time of writing ridiculously high, but bear with me). After 1 year, you get 1% interest

Explore a few proven strategies for setting up workspaces for your Power BI Premium Per Capacity (PPC) in this insightful blog. Read today!

If you’ve worked in tech for 25 years, you’ve seen some stuff, and you’ve learned a lesson or two. On October 1st, I presented a new session at Data Saturday Atlanta, sharing the …

I love the Power BI community. There are so many great things that the community does. They help each other (think the Power BI community forum) and they also build fabulous third party external tools to enhance Power BI. Measure Killer This week I am sharing a brand new third [...]Read More »

Power BI is a powerful tool that has also enabled millions of people worldwide to easily visualize & explore their data. Despite that, inflexibility to the visualization configuration and formatting can make it difficult to fulfill visual requirements. What are some of the biggest feature g

✨A new DAX function that is already available in the September release of #PowerBIDesktop, but was hidden in the last updates announced in September. ✨#OFFSET allows to make comparisons in context between two values, without writing extremely long and complex

Blogging about Power BI, Power Platform and other things I find interesting.

In September 2014, I wrote a blog post on dynamically passing parameters from PowerPivot to a SQL Server stored procedure using VBA. Back then, VBA was a real lifesaver. It perhaps still is for many of us. But frankly, I even forgot how to write VBA. Maybe it is time to look at it again. … Continue reading Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query

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.

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.