Data & Analysis

Dynamic Commentary in Power BI

Today is another in my series where I am building out my COVID report for Australia. There are a few things I cover in the video today. The main “new” concept is the dynamic commentary, but I also show you some more warts and all insider…

6 January 2022

Data & Analysis

Build a Power BI P&L in 5 Mins with InfoRiver

I have been building P&Ls in Power BI for about 6 years, and it’s pretty hard to do. When I was asked to build a video showing how this can be done in just 5 minutes, I was a bit sceptical at first. But as you…

30 December 2021

Data & Analysis

Generating Excel Reports Using Power BI, Cube Formulas, Office Scripts And Power Automate

Now that Excel reports connected to Power BI datasets work in Excel Online it opens up a lot of new possibilities for doing cool things with Office Scripts and Power Automate. Here’s a simple example showing how all these technologies can be put together to automatically…

29 July 2021

Data & Analysis Dynamics NAV & BC Tips & tricks

Analyzing Dynamics 365 Business Central telemetry with Power BI

Telemetry is a concept extremely important with Dynamics 365 Business Central, especially in the cloud world. Every partner should have an internal policy in place for connecting customer’s tenants to Application Insights service and then monitoring the status of these tenants and their performances by periodically…

3 March 2021

Data & Analysis

Implementing Data (As Well As Metadata) Translations In Power BI

Power BI Premium has supported metadata translations – translations for table, column and measure names etc – for a while now. Kasper has a great blog showing how to use this feature here; Tabular Editor makes it very easy to edit metadata translations too. However (unlike…

3 March 2021

Data & Analysis

Using Power BI Dynamic M Parameters In DAX Queries

As I’m sure you’ve guessed by now I’m a big fan of dynamic M parameters in Power BI. They’re easy to use in Power BI Desktop but what if you want to use them in your own DAX queries? Documentation for this is coming soon, but…

17 December 2020

Data & Analysis

Delaying Power BI Dataset Refresh Until The Source Data Is Ready

This week a customer came to me with the following problem: they had scheduled the refresh of their dataset but their source data wasn’t always ready in time, so the old data was being loaded by mistake. The best solution here is to use some kind…

3 December 2020