Power BI

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

Until now it was all too easy to create and publish a solution and overlook the backing relationships needed for the lookups that are present in the tables.  A new feature will help eliminate this issue. Before October, you will need to validate your existing solutions now to make sure you have included all required relationships for your lookups. 

Canvas app settings have been updated to a modern look, recategorized according to feedback, and streamlined to help you find and set what’s important.

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

On May 25th, we announced the public preview of the Power Platform Extension for VS Code. This helps organizations that continue to strive bridging the “collaboration” gap between with code-first developers and citizen developers.  This public preview is available for developers on MacOS (Intel, and M1) and on Windows10.  

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

Introducing table permissions to portals Studio.

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.

There are different approaches to having a dynamic axis in Power BI. Adam walks you thought 3 way to accomplish it within your Power BI report. Patrick’s Dynamic Axis video: https://www.youtube.com/watch?v=n-OWNaCUU0o Kasper’s Blog: https://www.kasperonbi.com/dynamically-switching-axis-on-visuals-with-power-bi/ Patrick’s Personalize Visual video: https://www.youtube.com/watch?v=20HwiEhIShc Buttons & Bookmark playlist

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.    ...