Power BI

SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. If you

As anyone who is familiar with my series on building a data culture knows, training is an absolutely vital success factor for a community of practice. This isn’t limited to developers, admini…

Learn how to get a field's value from another table in Power BI using the Related function in DAX and traversing through the existing relationship

In this post I will describe how to get previous row data that matches a criteria. This post will demo getting a person's previous score.

Looking to boost your Power BI development? Check how the latest version of Tabular Editor can help you become a true Power Bi hero!

Hierarchy FilterFor Microsoft® Power BIThe Hierarchy Filter is a selector component like a native slicer, just that it can display multiple category values in an expandable tree view used to …

SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. If you like to follow best practices, you can just read this paragraph out of the entire article. If you are using SUMMARIZE to calculate new columns, s

Back in 2019, Ton Swart and I wrote a blog post on Versioning and CI/CD for Power BI with Azure DevOps. Back then, there were not many options available for versioning and professionalizing your AL…

Learn how to document the entire Power BI service tenant objects without writing any code. You can export all workspcaces, reports, datasets etc.

Paradigm BI Posts - Paradigm BI and Active Business Intelligence Updates - We're going to make some customer-friendly KPIs using the Adaptive Cards custom visual for Power BI.

Email notifications for dataflow refreshes now available for non-owners

When you create and publish a composite model using DirectQuery for Power BI datasets and Analysis Services, you should pay attention to the minimal permiss

Learn how to filter the data for a calculation in a DAX expression in Power BI. You can apply multiple conditions using AND or OR operators.

Object Level Security (OLS) helps to protect our data assets inside Power BI. OLS can be applied to a table or just a single column.

The other day I was facing an interesting question "How can I randomly draw ten records from the top 50 for each group using Power Query?" As you may guess, this article also contains the answer.

This is part 5 of the Analysis Services DevOps blog series. Go to part 4 Release Pipelines In the previous chapter, we saw how to set up a complete build pipeline, that loads our Tabular model from source control, performs a schema check, runs the Best Practice Analyzer and even performs a validation deployment. At the

What are release pipelines in Azure Pipelines?

This is part 2 of the Analysis Services DevOps blog series. Go to part 1 Branching strategy and workflow The first thing we need to align before getting started, is what branching strategy to use. While this sounds boring, it’s actually quite important, because it will dictate what the daily development workflow will be

Exporting Translations Tabular Editor lets you export translations into the same .json file format used by Visual Studio and SSAS Tabular Translator. This is useful if you want to delegate the task of translating your model to someone without access to your tabular model metadata. Let’s say you’ve added a new culture (called “translation” within Tabular

Learn how to reduce the size of Power BI file by removing un-necessary columns in a very few simple steps and guide to follow it.

Power BI Windows app is designed to provide great Power BI consumption experience for Windows users. Business users who do not need to create or edit reports can use this app for simpler and easier view and usage of reports, dashboards and apps. In this release we are introducing preview of Power BI Windows app’s new look, which includes new home page.

We are pleased to announce the release of a new version of Power BI Report Builder! This release includes a number of new features designed to improve your paginated report authoring experience, plus we’ve now added Power BI Report Builder as an app in the Microsoft Store.

Easy data sharing with endless possibilities

PowerBI Data Portal is now available. Try it for free for 15 days and start sharing your Power BI datalflows with anyone.

Enso – a visual and textual functional programming language. - enso-org/ide

Generate stunning color palettes for your next mobile app.

learn how to use TopN function in DAX either to create a calculated table, or to use it in a measure to achieve analysis such as; comparison with the average amount of the top group.

Part 2, goes into comparing the scalability between AAS and PPU and how it compares to when it is scaling upwards.

We’ve just finished a difficult yet fulfilling 12th round for the Power BI Challenge, which was based on a transport and shipping dataset. This was probably one of the most difficult challenges we’ve had to date, and we’re very impressed with the participants’ in-depth analysis on their entries.    ...