Power BI

Since the Power BI team allowed to launch external tools from the Power BI desktop ribbon, several tools became available. Do you know you can create your own

Use this PowerShell solution to verify if best practices are applied in all Power BI models. It includes a template report to analyze results.

Shared via Flipboard

Performance, performance, performance, everyone loves a report that has good performance right? Specially if we are talking about reports using Direct Query, which is the main focus of this post. While you have some settings in Power BI Desktop that can help you with query reduction (specially useful if you're using Direct Query!), there is no option to add an "Apply all filters" button directly in your report page. Yes, you can add an "Apply all" button if you use the filter pane, but if you're

The first and most important thing we need to understand to get our expected result is forcing the user to use a custom navigation inside of the report. Let's avoid the default pages navigation. We might need to build a single visible Menu page to start our report. You can find a lot of post and vid...

Using the small multiples in Power BI, monitor performance of multiple stores and analyze data in more granular categories

Read this blog to know more about xViz Multiple Axes chart for Power BI which can represent multiple KPIs in up to 5 different axis scales

In this blog post I show how to overcome an error when deploying to Power BI Premium per User when there are incremental partitions created.

Writer and developer James Bartlett delivers another great update to Business Ops for Power BI read about a new tool release Report Analyzer

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

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.