Power BI

A common search strategy has to combine multiple items with an AND instead of the default OR. This Power BI file contains two DAX measures solving a search operation with the fancy name: relational division

This blog post discusses model recalculation in Power BI and how you can perform it.

This blog post lists the new financial DAX functions introduced in June 2020.

Learn how to create a tree view in Power Apps.

We reduced a Power BI dataset size by 83% by doing one simple thing. It’s time to get serious about your data model! Download Sample

If your date is not being displayed correctly in the Power BI Service you will need to make some changes to your Operating System to view them correctly.

Have you wondered how to get a refresh date in your Power BI report? Adam looks at an easy way to do that with a little Power Query.

There is now a way to incrementally refresh any Power BI data source using a combination of a SQL Server database and a function.

Power BI has become hugely popular and I find common questions about functionality and features, so I thought I would put in this blog some of those questions with answers: What is the best way to …

Part Two of a Power BI Performance series, with this post focused on the performance of your visuals, featuring the Power BI Performance Analyzer View.

Power BI Icon The great thing about Power BI is the monthly updates and how much Microsoft are churning out features, updates, and all sorts of cool stuff. The worst thing about Power BI, is trying…

In the previous post in this series I showed how you can use the Table.Join function and the SortMerge algorithm to get much better performance for merge operations in Power Query – but only …

In the last two posts in this series I showed how removing columns from the tables used in a Power Query merge operation can improve refresh performance. In this post I’ll show you a differen…

I received feedback on my recent blog post on single-column fusion asking about a curious syntax used in the solution. I promised I would do a deeper dive on why it works in my next blog, so here it …

I'd like to share with you an open source tool and framework I built that dynamically creates a tabular model based on an Excel template. Currently, there is no standard framework people use when …

We’re thrilled to introduce a new look for getting apps! As of today, getting an app from your organization or from the AppSource marketplace has never been easier!

June release of gateway

We have great updates this release! We’re super excited to announce this month that several features are now generally available: automatic page refresh, the hierarchy slicer, the modern ribbon, and AI insights are now generally available. On top of this, we have several new features and updates that will really improve your reporting: many enhancements to mobile layout authoring, visual updates and more! Check out the full blog to learn more about all the updates and enhancements.

This article provides a step-by-step instruction on how to enable Service Principal (SP) access to a Power BI workspace in dedicated capacity (Power BI Premium or embedded/A sku).In the following, I …

Test Studio is the place where you can create your tests.

Quite a while ago in 2018 I wrote about how to debug Power Apps. Then we still had to go through development steps just to understand what was happening in

[vc_row][vc_column width="1/1"][vc_single_image media="87345" media_width_percent="100"][vc_column_text]Here’s a quick Power BI tip for you: Setting up drillthrough so that it never breaks! What […]

The Power BI team releases many new features in every monthly release, which is an amazing achievement to make it happen every time. Having all this new functionality on your fingertips is a great …

From the day Microsoft made the "PowerBI - Refresh a dataset" Power Automate connector available, and having seen this video by GuyInACube https://guyinacube.com/2019/10/24/use-microsoft-flow-and-other-options-to-refresh...

I recently posted a graph to twitter and asked people to explain it. Let’s look at the graph. Chart from Fitbit showing my step count from April 1 through May 23. The graph is from Fitbit. It…

This post discusses two methods of receiving an alert when a tenant setting has changed in the Power BI Service: one using Cloud App Security, and the other using the M365 Security & Compliance Center.

I recently came across an interesting problem regarding how you can show the sum of values of certain selected categories as separate bars in a bar chart – but with the sum of all the non-sel…