Power BI

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 […]

This video provides you with the technical knowledge to choose between using a Date or an Integer to create the relationship between your fact table and the

This session is purely Q&A with Marco Russo on Power BI report optimization and will guide you in analyzing the possible reasons for a slow BI report.

Paradigm BI Posts - Paradigm BI and Active Business Intelligence Updates - Planner Reporting Beta Data Stage is a manual install. This is fairly straightforward.

It’s here! Have a look at the Power BI Paginated visual for your Power BI Reports! It adds additional flexibility for displaying data as well as providing easy export options if that’s your jam. Blog Announcement: https://powerbi.microsoft.com/en-us/blog/paginated-report-visual-for-power-bi-reports-is-now-available-in-public-preview/ Documentation: https://docs.microsoft.com/power-bi/visuals/paginated-report-visual BIFOCAL Show Podcast: https://bifocal.show/ Jason Himmelstein’s white paper: https://sharepointlonghorn.com/the-new-paginated-report-visual-is-here/

I admit that the technique I will share with you in this post may not have many use-cases, but it was a crucial component for the Excel Compare Power BI app that we released on AppSource earlier this week, and you can consider reading this post as a technical challenge to evaluate your Power Query […]

After everything about sharing content and requesting access to content, it is time to talk about discoverability of content in the Power BI Service. The next blog in the series of transforming a l…

You’ve spent time creating Calculation Groups in Power BI only to find that they don’t work. What’s up with that? Patrick may be your only hope. Calculation Groups Documentation: https://docs.microsoft.com/analysis-services/tabular-models/calculation-groups