Power BI

There are over 600 functions in Power Query. Yet, those functions won't always do what we need, therefore we might need to turn to custom functions.

This article discusses how to create a custom functions in Power BI using Power Query. The latest SQL Server articles from SQLServerCentral

Learn what the RACI model is, why it matters, and when and how to use it to improve your stakeholder management.

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 […]

An article that covers how in depth how the Combine Files experience in Power BI / Power Query and how parameters and functions work inside of it.

Understanding the main principles of Parameters and Functions in Power Query and Power BI when it comes to Data Preparation and the M language.

How, when and why to use recursive functions within Power BI / Power Query. Theoretical and practical examples

This is a complete tutorial on Power Apps Data Table, PowerApps data table limit, PowerApps data table filter and PowerApps data table vs gallery, etc.

In this article I will show the easiest way to make a scrollable screen in Power Apps using a vertical container.

There’s a nice new feature in Power Query Online (the version of Power Query used in Dataflows): parameters of type List. You can see this as a new option in the Type dropdown in the “M…

When the Power BI report is not enough, here is how to add an interactive button as a shortcut to the Excel file in the Power BI report.

Learn about new Power Query-related updates in the recent October 2021 release of Power BI Desktop!

Here is a tip that reduces your Power Query steps with 1 step less. When I build date tables I typically use the function List.Dates to create a list of dates. As I want it as a table I use the Rib…

This article shows how to get the previous row value using Power Query. You can adjust the 3 ways to also retrieve an earlier or later row.

Learn how to create a dynamic date table in Power Query. Make sure to pick up your free script to generate a reusable calendar.

You may already be aware (but then again, maybe not) that Microsoft shares its plans for upcoming new features for the Power Platform every 6 months, and Power BI forms a subset of that plan. The next plan is called Power Platform Release Plan 2021 Wave 2. It takes a [...]Read More »

Last year I blogged about handling multi-select scenarios for dynamic M parameters. Since then support for “Select All” has been added (see here) but since a regular slicer with no item…

The most popular example is a company store where items are placed into a shopping cart. I will show you how to create a Power Apps shopping cart.

GA Support for File and Image in Power App Canvas

A productivity tool for analyzing a Power BI report's performance.

Let’s say you are building a dashboard for the Sales team and have the following requirements: Each sales person should have access to only their territory – Ok this is easy enough. We …