Power BI

Become an Insider: be one of the first to explore new Microsoft 365 features for you and your business.

The last few posts and videos in this series have introduced the importance of a community where your data culture can grow, and ways to help motivate members of the community, so your data culture…

This tip outlines an easy deployment method for data tables that have been manually added to a model via “Enter data” in Power BI Desktop. [...]

This article describes how to use calculation groups to dynamically replace only a partial expression in a complex DAX calculation. This article contains a

The news about Power BI external tools have gone viral on the internet, and every day we see many useful tools added under external tools. The good news for those of you who have been waiting is that you can now have Power BI Helper also (even though a bit late in the game) to…

In this article, I’m going to show how you can use Visual Studio Code to run queries against a Power BI model. Usually, this is the kind of task you would use the excellent DAX Studio for, bu…

Q&A allows report readers to ask questions regarding the report data. Natural language interpretation can be improved by using Q&A synonyms.

We know that Excel is one of the most widely used tools in the world for understanding data and making decisions based on that data. It's used by hundreds of millions of users each month in almost every type of company imaginable. To better meet the needs of our users, Excel has evolved and transfor...

Choosing good colors for your charts is hard. This article tries to make it easier.

I recently published my color contrast report in the Power BI Data Stories Gallery. It allows you to enter two hex color values and then see the color contrast ratio and get advice on how the two c…

In this blog post we cover features of the Power BI Service that could potentially compromise enforcement of your governance and security policies.

Power BI implementation key considerations from a non-technical perspective.

New documentation about what’s involved with migrating to Power BI is available on the Microsoft Docs site.

[vc_row][vc_column width="1/1"][vc_single_image media="87927" media_width_percent="100"][vc_column_text] Complete blog post to be released following the 4th part of the series. Part 3 Power […]

Power BI Sidetools is a free Power BI external tool intended to increase productivity during reports development in Power BI desktop. Transfer DAX and M formulas to files With just one click, you can transfer M and DAX formulas into a folder named like your report. The very first use case wil...

Learn how to plan and conduct a migration from another third-party BI tool to Power BI.

Back in May 2020, I wrote a blogpost about visual customization in Power BI reports. The feature was released in preview with the April 2020 release. Now, the Power BI team made another update to t…

The last two videos in our series on building a data culture covered different aspects of how business and IT stakeholders can partner and collaborate to achieve the goals of the data culture. On…

This article describes how to create Key Performance Indicators (KPI) in a Power BI Desktop data model by using Tabular Editor. Starting from the July 2020

BI Polar has a series of videos and accompanying blog posts that focus on key aspects building a data culture. This series is in progress – five videos have been published so far, and more vi…

data business intelligence bi machine learning mi professionals contractors azure Power bi analysis ETL ELT modeling automation training leadership

This blog post shows how you can use Power Query to clean/cluster/group text values in Power BI

How to increase Power BI adoption in your organization.

When starting a Power BI project, you have many choices to make. Decisions like how to source your data, where and how to create queries to cleanse, transform and reshape the data; where and how to…

You probably know that dimensional modelling and building a star schema are very important in Power BI. In a star schema you’ll have at least one fact table, and in your fact table you’…

These days more and more data lives behind an API, rather than in a more traditional data source like databases or files. These APIs are often designed and optimized for small, chatty[1] interactio…

Microsoft released the exam DA-100 (Analyzing Data with Microsoft Power BI) around early April 2020 which was in Beta until around the beginning of July. After the exam become out of Beta, I was wo…

I have previously explained how to generate a row-number using Power Query. That method is good for pre-calculating row-numbers in the table. However, sometimes, you want to calculate the row number in a visual, based on something dynamic. That is where DAX comes handy. Let's see how this is possible. Sample model I have a…

I often get this question: "Is it better that I create this calculation as a snapshot table in Power Query (or T-SQL, or the data source), or write DAX measures for it?" If you ever had a scenario of creating a report of snapshots, you know what I mean. "Should I have a table for…