The inspiration behind this post solely came from WHO website https://www.who.int/. I went onto to check some COVID data and found quick...

In last week’s post I described the new Power Query M functions for working with Well Known Text objects, and in a post a few weeks ago I...

The Microsoft Power BI team will have me as a guest speaker tomorrow (8/20 2pm ET) for a live tutorial on building a COVID-19 dashboard...

In the August 2020 release of Power BI Desktop a couple of new Power Query functions were added: Geography.FromWellKnownText,...

In the last tutorial of the COVID-19 dashboard series here, you learned how to import a single COVID-19 situation report directly from...

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...

I don’t generally blog about data visualisation in Power BI because it’s not my strong point, and I don’t blog about maps and geospatial...

Follow @gilra Follow @datachant I am happy to share with you the news. I have recently been re-awarded as a Microsoft MVP in the Data...

Follow @gilra Follow @datachant In one of my last tutorials here, we learned how to apply time-intelligence in DAX to analyze the...

The Power Query OData.Feed function has an option called IncludeAnnotations that allows you to return annotation values from an OData...

Here’s something that will excite all you M nerds out there! Did you know you can make tooltips appear when you hover over column headers...

In the last tutorials of the COVID-19 dashboard series, you learned how to build your own COVID-19 dashboard from CSV files that were...

In my previous blogpost I’ve described a method how to extract a substring that follows a certain pattern from a string. In this post I...

Do you have Analysis Services Multidimensional cubes in production? Although I know it’s a long time since I last posted any...

When you import data from a relational database like SQL Server in Power BI you have the option of entering your own SQL query to use as...

I see a lot of Power BI datasets in the course of my work, and as a result I see a lot of datasets that look like this: What’s wrong with...

A typical task when cleaning data is to extract substrings from string that follow a certain pattern. In this post I’m going to describe...

Follow @gilra In my last tutorial here, you learned how to apply a dynamic running average in DAX. In this part, you will learn how to...

Over the past year or so I’ve been delivering a presentation on the Power Query engine’s data privacy settings at various conferences and...

In the previous post in this series I showed how you can use the Table.Join function and the SortMerge algorithm to get much better...