Power BI

I have written dozens of articles about row-level security so far and explained in all of them explained different methods in which you can reduce the amount of data rows that a user can see based on their roles. However, in my presentations, I still get this question that: What if I want to compare…

We’ve started to roll-out the capability upgrade classic workspace to the new workspace experience as a Public Preview. This post gives you resources to learn about the upgrade before it becomes available to your users and to be prepared. It also answers questions from our pre-release blog and documentation.

This is an overview of all the updates in the Power Platform for events that have happend in Microsoft Ignite and SQL Pass

At this point I’ve said “Power BI dataflows enable reuse” enough times that I feel like a broken record[1]. What does this phrase actually mean, and how can you take advantage of …

This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to impr

Learn how to create types from text in Power Query enabling you to dynamically change types via functions for example. Type.FromText

Parameters in Power Query are useful for many scenarios when you want to do something dynamic in the data transformation process. I have previously explained how helpful they are in creating a custom function. In this article, I am showing you another useful way of using Parameters to create dynamic datasets, that you can change…

This blog post details how to use the Power BI features to see when there are support issues and how to get notified when it occurs

This is a series of posts and exercises from a recent full-day workshop called Next Level Power BI. Check back for additional lessons and freely post your questions and feedb…

The PowerApps Report Survey allows a simple, unobstructed feedback loop. This is critical to end user adoption and usability of your reporting environment.

“Have you seen the deck.gl framework from Uber? It’s designed to show large scale big data visualization?” said one of the software engineering team. I had a look at it, and it do…

Start tracking your New and Repeat customers in Power BI and see where your sales comes from. Bonus measure added: Repeat customer from previous month.

This tutorial teaches you about Pareto Analysis in Power BI. You will learn how to identify your most and least profitable products, and visualize them.

The conditional formatting can be used in many visuals in Power BI, and I have explained an example of doing it in table visual. This feature is also available in the Card Visual in Power BI, However, I have seen a very few people using it. In this short blog article, I'll explain how this…

Last month[1] at the Microsoft Business Applications Summit (MBAS), Power BI program managers David Magar and Swati Gupta showed off a new load assessment tool for Power BI Premium capacity workloa…

Want to analyze your Power BI model without having the PBIX file? Marco Russo joins Patrick to show you how!

Use the Grouping feature within Power BI desktop to clean up your report. It enables new ways of building features by using Power BI Buttons as well.

Learn how to scale a visual to maximize usability. This tutorial shows you how to do this using Groups and Bookmarks in Power BI Desktop.

In this blog post below, I am going to show you how to configure the Load Balancing with CPU and Memory. I always recommend for On-Premise Data Gateway installations that there be at least 2 Gateways installed. The initial reason was to ensure that if...

This is a question that has come up a few times over the past few months from several clients and so I figured it’d make a good quick blog post that can easily be pointed at to save time. I e…

Back in 2018 I wrote a blog post about how to troubleshoot web service refresh issues using a third party tool called Fiddler. It’s still relevant but Fiddler is a complex tool and installing it an…

My last article described the Shadow Model data modelling technique and how you can use it to help resolve a specific performance challenge caused by tables forced to direct query mode in particula…

This post is the last in this series (for now) and describes a technique used to enhance performance in Power BI models that use Aggregate Awareness. I hope you’ve enjoyed the series as much …

I wasn’t originally planning on including an article on Incremental Aggs as part of this series, but I like the idea, and it seems like a good fit for the series, so here goes. The series so …

Power BI Desktop has a new ribbon! Patrick shows you 5 awesome things about it that you may not be aware of.

At Ignite 2019, Microsoft outlined its vision to continue extending Power BI’s enterprise capabilities. Even with Power BI Premium, deploying Power BI in an organization often means working around concerns such as model size limitations, vague deployment procedures, and more.

Earlier this year I published a few posts describing approaches for retrieving Power BI artifacts via PowerShell scripts. As a Power BI administrator, the scheduled retrieval of this data could bec…

Over two years ago I published a blog and document with a feature matrix comparing modeling features of the different releases of Analysis Services Tabular and Multidimensional. At that time, the T…

I recently found out the SSAS team added new trace information to Azure Log analytics. The new information allows you to find out the report and dataset in Power BI...