Power BI

I have explained previously how you can use the Table.Profile Power Query function to fetch the profiling data of a table, such as minimum value, maximum value, null count etc, and use it in a report page to inform the user about the quality of the data. However, that function doesn't provide you with one…

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

In this post I will introduce animating SVG by altering the colour and size of the SVG graphic using variables and a timer control.

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 …

Power Platform admin center gateway management enhancements

A few months ago we announced a Public Preview of Power Platform analytical dataflows. Now, we’re extremely excited to announce that Power Platform analytical dataflows are generally available!

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…

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…

Can we filter SQL table based on the values from another table(like a join in SQL)? We have two tables Table1_UserPermission["PersonID","ProjectID","IsActive"], Table2_ProjectDetails["ProjectID","ProjectName","ProjectCost"]. When the user logs in, we are trying to check the Table1_UserPermission...

I want to show a gallery from table A but filter the results based upon a value of Column4 in a related table B. eg. TableA Column1(PK), Column2, Column3(FK) TableB Column1(PK), Column2, Column3, Column4 In SQL, I would write "select * from TableA inner join TableB on TableA.Column3=TableB...

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…

In Microsoft Power Apps, there is an Org Browser Canvas App which connects to your Office 365 data and enables the app user to search for Office 365 users in an organization. This can be convenient if you want to enable users to contact other users, especially mobile ones. Let’s take a look at it. To install it, go to https://make.powerapps.com and select Apps, then Org Browser: Give the App … Continue reading Checking out the Org Browser Canvas App in Power Apps

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 …