Links to some of the best Power BI resources the web has to offer.
I have taken advantage of many free (some paid) resources the web has to offer… blogs, YouTube videos, books, courses etc. I believe I have seen some of the best the web has to offer. When I …
Split an existing Power BI file into a model and report
Increase Report writing efficency by building Shared Datasets. This tutorial shows you how to take a single pbix file and form two files model and report.
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 i…
How to keep your Power BI dataflows organized and optimized
In this blog I describe a few of the challenges you might face when you have a lot of dataflows. I will describe a few tips and tricks I am applying to sanitize your dataflow approach, organize dat…
In my last tutorial here, you learned how to apply a What-If technique to calculate the estimated active cases of COVID-19. In this part, you will learn how to run running averages to smooth the trend lines of any measure you use. Our analytics objective is simple. The daily new COVID-19 confirmed cases can fluctuate…
In my last tutorial here, you learned how to apply a dynamic running average in DAX. In this part, you will learn how to offset the daily new confirmed cases vertically and horizontally. Horizontal offset - Normalize cases by population Different countries were affected differently by COVID-19. The most common analytic challenge in comparing between…
Power BI, DAX, and relational division - a common search task with a nerdy name
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
Getting the correct Date Format to be displayed in the Power BI Service - Reporting/Analytics Made easy with FourMoo and Power BI
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.
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…
Chris Webb's BI Blog: Optimising The Performance Of Power Query Merges In Power BI, Part 4: Table.Join And Other Join Algorithms
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 …
Chris Webb's BI Blog: Optimising The Performance Of Power Query Merges In Power BI, Part 3: Table.Join And SortMerge
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!
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.
Service Principal access to dedicated capacity XMLA endpoint
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 …
Drillthrough on All Columns and Measures in Power BI
[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 […]
Power BI Governance – New functionality? Govern the implementation in phases
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 …
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…