Power BI

Using the default option to aggregate joined tables is terribly slow. Read how to speed this up significantly. Performance join.

In this post I write a simple function component that takes one value and returns a calculated value. This creates a resusable function like feature.

Power BI data lineage

Introduction Part III in this series looks at another time-based aggregation technique you can add to models. The basic idea of any aggregation table is to generate a summary table the engine can u…

I stumbled across this Reddit post yesterday, discussing the effect that Jérôme Garcès has on Springbok Rugby games. The results are a little scary, and to try and make myself feel a bit better abo…

In this SVG Introduction post we will cover adding a simple SVG drawing to a PowerApp screen. Future posts will show how to manipulate that image.

I use this diagram a lot[1]: This diagram neatly summarizes a canonical use case for Power BI dataflows, with source data being ingested and processed as part of an end-to-end BI application. It sh…

Adam looks at your refresh options for Power BI datasets. Including Microsoft Flow! https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

There are always many questions about a cheat sheet to shows the existing capability for doing AI and ML in Power BI service and Desktop. In the above chart, I have summarized the capability of doing AI and ML in Power Service and Desktop for each role. I have identified three main roles in…

We’re happy to announce that Auto ML in Power BI is generally available in all public cloud regions where Power BI Premium and Embedded is available. Using Auto ML in Power BI, business analysts can build ML models to solve business problems that once required data scientists.

A recent blog on the Power BI website announced the availability of a preview component in Microsoft Flow, which allows to easily refresh a specific dataset. This is good news, because in reality Azure Logic Apps are under the hood of Flow, so this means the refresh capability is now also available

No Training Required Around 18 months ago I was working on a Power BI Report build that was going to have a few hundred monthly users, many of them accessing the report daily. We had just formed a …

In this article, we will use JSON for canvas apps function and export all the images in a PowerApps Gallery to an HTML file and then convert that HTML\PDF file using the Microsoft Flow. To reduce the complexity, we will divide the article in three parts: Design a canvas app that will capture Multip...

This guide details how to build a Microsoft Flow solution which dynamically creates a Microsoft Word document based user-selected options entered

So how do you design your data model? Do you follow standard practices, or do things your own way? I'm curious to know how you approach this task.

The Desired End Result: Compare Two Entities in a Specific Visual Style (Used here for football QB’s, but perhaps useful in other “head to head” comparisons – products, ad campaigns, etc.) Setting the Stage: a “Risk” This is one of those things where I spent a lot of time figuring out how to do something

How to handle different date time zone values in Power BI / Power Query and how to switch those values to a different time zone.

This week I was honoured to be a guest on the Guy In A Cube channel, and for my topic I decided to tackle one of life’s eternal questions: why does Power BI query my data source more than onc…

In a recent post I mentioned an approach for working around the import-only nature of Power BI dataflows as a data source in Power BI Desktop, and in an older post I shared information about the en…

This is still one of the most common dataflows questions: what’s the difference between Power BI dataflows and Power BI datasets? For the last year I have resisted tackling this question head…

I do a lot that’s not related to dataflows. In fact, dataflows take up a surprisingly small part of my day, if your insight into my calendar came solely from this blog. Despite this, I like t…

Learn how to present KPI data in Power BI that results in greater transparency into the KPI metric definition and calculation.

This article describes how to analyze the performance of a DAX measure based on a DISTINCTCOUNT calculation and how to evaluate possible optimizations. The

Patrick shows you a little known Power BI feature to help your report consumers use every bit of your report. Removing confusion and maximizing use!

Learn how to add needed context to your business intelligence content easily using Microsoft Power BI and Microsoft Sway. The results will amaze you.

The Power BI Desktop Source (PBIDS) File is a file that helps users create files. We built a tool to help with that.. Click here to create PBIS files