Power BI

5 very helpful tips for winning with Power Platform Projects.

In this new blog series, I will show you how to do data conversions from one data type to another. This blog will show you how to convert a table to a string and vice versa. Table First of all, let’s quickly jump into the definition of a table. According to Wikipedia: In Power Apps, […]

So in part 1 we found out what Workload Management was and why we wanted to use it. (If you haven’t read that part, please click here and read that post before you carry on, as we’re jumping in at the deep end!) In this part we’ll be learning how to configure it. Continuing from […]

Hi and welcome back to another edition of the #FreeAzureDataSummer! Today, I would like to bring your attention to a – for me – very interesting and useful link – the Azure Applic…

We are excited to announce that the Power Query forum is now available in both Power BI and Power Apps communities!

was listening to this Excellent Podcast about Minerva, basically Airbnb went and built a Metrics Store which is a central tool that hold all Measures and dimensions, the idea is to have one source …

A quick note for anyone like me who spends too much time looking at the JSON exports from Performance Analyzer in Power BI Desktop: you may have noticed an event called Query Pending that isn&#8217…

This article continues to build on my COVID Case Fatality Rate report for Australia. Something happened with the global source data this week – in short, it was wrong. This is a global database and I am sure there are many people diligently trying to keep the data up to [...]Read More »

We are super excited to announce that digital copies of Master Your Data for Excel and Power BI are now available for purchase!

I love using my data patterns to solve issues and in this post use one of my favourite recipes in order to label duplicates with Power Query.

I was inspired into action this week by one of the worst visuals I have seen during the COVID pandemic. Here is the visual below, take a look and see what you think. When I first saw this chart, I simply couldn’t make sense of it. The first thing I [...]Read More »

Learn how to know your dataset better using column profiling, quality, and distribution features of Power Query in Power BI

Learn how to find similar values in the data table based on a similarity threshold and get the similarity score output with fuzzy clustering.

When comparing AAS to PPU, I show which are the different deployment options and suggest which ones will work best.

Being aware of data problems is the first step towards solving them. Instructions to create data problem button efficiently with a Tabular Editor script.

This post discusses the forms, origins, and indications of fraud and misrepresentation in the context of Power BI consulting and contract engagements. The intent of this content is to help the read…

When working with Power Query, you have probably already realized that every expression you write returns a value of a specific type. Usually this will be a primitive type like text, number, or date. (A full list of types available in Power Query can be found here: https://docs.microsoft.com/en-us/powerquery-m/m-spec-types). If for some reason the type of…

Power BI deployments are resource-intensive projects that require managing many moving parts and competing priorities. Plan for success with this approach.

Did someone ask you to replace blank values with 0 in your reports? Maybe you should think twice before you do it!

Updated announcement for Premium Gen2 General Availability

[vc_row][vc_column width="1/1"][vc_single_image media="88206" media_width_percent="100"][vc_column_text]In this Power BI tutorial, you'll learn how to build a correlation plot natively in Power BI. […]

Using Smart Narratives and you’d like to add some conditional formatting in Power BI? Patrick shows you some tricks to take Smart Narratives to the next level! Download Sample

Public preview announcement of access rights admin APIs

Third blog in the series on Transform a local into a global Power BI solution. After covering the general differences between small scale and enterprise solutions and last week all about content sh…

There are many, complicated ways to conduct a causal analysis; however, an event study is particularly well suited for a tool like Microsoft’s Power BI. Similar business intelligence software are better known for describing what happened through visualizations rather than why something happened.

Overriding filters that are passed as filters in the tooltip opens new possibilities. This can be done for regular tables but also calculation groups.

Ready for some cool data visualization? In this part, we're building our report in accordance to some of the best data viz practices!

Do you need to detect changes or errors between two revisions of mission-critical Excel workbooks? We have just released our 10th app on AppSource that can help you achieve it. Excel Compare (available on AppSource here) is a free Power BI app that compares two Excel files of your choosing and detects differences and errors […]