Power BI

If you don't have a Power BI Premium capacity license, then you are limited to refresh your dataflows up to eight times a day, with the frequency of 30 minutes. The good news for you is that you have a way to do unlimited refreshes and with whatever frequency you like using Power Platform Dataflows.…

This is a mock-up in response to this question on the Power BI Community Boards and provides a concept for expansion rather than telling a particular story. This is an example building on Parker Stevens' excellent Dynamic Reference Line on X-Axis walkthrough, with a twist. Rather than having a singl...

I conducted a workshop in Florida recently, aimed at helping people to move from Business Intelligence to Analytics. I thought I’d post the slides here. If you have any questions, please get …

The Postman app is useful as a developer if you want to send requests and see responses when interacting with Web APIs, as well as seeing what the calls actually do. In this post, we will look at how to call the Power BI REST API from Postman. First, follow the instructions here to register an Azure App to use with Power BI. Note the client id and secret. Next, … Continue reading How to Call the Power BI REST API from Postman

This post comes from a question following on from my Refresh a Power BI Dataset with a Button post which I shared on LinkedIn. The question was, “I wanted to refresh more than one data set in the power bi pro”. You could do this by building out multiple buttons, or you could do this by performing multiple actions within a single flow. You could also do this by calling the … Continue reading How to Refresh Multiple Power BI Datasets using Power Automate and the Power BI API

One new feature that was introduced in the December 2019 release of Power BI Desktop, but which wasn’t mentioned in the release blog post, is the “Diagnose Step” button on the Tools tab of the Powe…

INTERIOR: pan over cubicles of happy, productive office workers CLOSE-UP: office worker at desk NARRATOR: Is that Susie I see, giving Power Platform dataflows a try? SUSIE: That’s right! With…

Another year has gone by and it has now been 10 years since DAX was first introduced in late 2009. As usual, it is time to review the past year and to take

The new Power BI Activity Log makes it much easier for Power BI administrators to access audit log data to monitor and analyze activities occurring within the tenant they support. This blog post de…

The Power BI 2020 Salary survey was popular enough to get some interesting results. In this post, I am sharing the result of that survey (which is filled by the public) as a Power BI report. The report gives you an overall idea of how much the minimum, maximum, and average salary should be based…

Reading Time: 3 minutes With the December Power BI Desktop update, users are introduced to a new color picker when customizing theme colors. The new color picker is much more versatile than the original when selecting colors. Power BI’s new custom color picker (seen in theme customization preview): Power BI’s original custom color picker (currently seen everywhere else): …

Reading Time: 3 minutes Along with the updated Power BI Desktop ribbon, several additional report themes are available. The Power BI docs provide a great reference to the new options, except they do not include the specific color values for anyone who wants that level of detail. Last year, I compiled a hex color reference for the (then eight)…

In a previous blog, I showed how to load a raster tiles into PowerBI data model, in theory that should solved all my issues with doing a detailed maps in PowerBI. unfortunately, no, even if R and P…

Learn who to use Scrims to take your report from ok, to amazing. Scrims are the easiest way to make your report shine. Click here to learn more.

Get rid of unused elements in your Power BI files easily with the new Power BI Cleaner tool. It automatically detects all unused fields in your PBI file.

Video by: Reid Havens Learn how to customize themes using the new menu in Power BI Desktop.

The year flew by pretty fast! With 2019 in the books, it’s time to have a look back at all awesomeness that happened this year! Time to say goodbye to 2019 and welcome 2020 with a short look …

As a follow-up to my last blog, Azure Synapse Analytics & Power BI performance, I wanted to focus on concurrency when using these two products. A common question I here from customers is becaus…

Introducing Scrims, an elegant background for your Power BI Reports. Click hear to learn how to use a scrim to make your report shine. Click to download.

This post has been waiting in my blogging list for a while and now this is my last post in 2019. I wish you all have a wonderful year ahead. In this post I discuss a very important aspect of data visualisation; Colour Coding. I believe, colour coding is one the most powerful and efficient … Continue reading Empower Your Story Telling Data Visualisation in Power BI with Colour Coding

December 2019 is a major update in Power BI Helper. We believe this is the biggest update we have done so far. The list of updates is big. To name a few, now we have pages, visuals and bookmarks metadata available, visual comparer, visualization tree, the reverse dependency tree, DMV execution page, and dependant calculations…

This blog serves as the beginning of a Power BI Governance series that will outline our observations and recommendations for implementing governance.

<p>December version of the gateway</p>

We are excited to announce the availability of a new Power BI API called the activity log, which enables Power BI service admins to track user and admin activities within a Power BI tenant.

The following is a pretty common scenario that I’ve seen with flat files exported from legacy systems, but it also applies to multiple other scenarios. It uses the M language inside of Power BI Desktop / Power Query, but you can follow along without knowing that much about it. The scenario: a table that contains […]

Introduction For this blog, I want to share an interesting approach that can potentially speed up slow reports that include a distinct count calculation. The approach described in this article expl…