Power BI

Have you ever had the idea of finding which measures in your model use a particular function? Or a quick view of all the calculated columns in a model? These are relatively simple tasks but it can be …

This article describes a naming convention for temporary columns in DAX expressions to avoid ambiguity with the measure reference notation. Table functions

What you can do and why you should Have you ever been facing the problem of showing small and large numbers together (e.g. 123,456, 789.99 and 34.56) in a nice way, lets say with a 3 digit precison as 34.5 and 123G (or 123E6).   When working with large numbers you can divide them with 1,000 or 1,000...

In this blog post, I will give you a comprehensive overview on the Power BI calculation groups. I’ll share with you some of my tutorials around calculation groups and you’ll see how and when to use them.    Calculation groups are a collection of items, which are basically the same measures that you ...

This article is the fourth release in a series of “pill” blog posts aimed at investigating performance issues that could affect the proper operation of the On-premises Data Gateway in Enterprise …

How to measure the duration of a Power BI DirectQuery query using Performance Analyzer

.Use calculation groups in Power BI to control when measures get processed using an Apply All button

With Power BI becoming more and more popular, it can be observed that organizations are trying to move their current reporting platform in to Power BI based solutions. However, success of this migr…

Premium Gen2 Preview important dates for autoscale coming up and timelines update

DAX (Data Analysis Expressions) is the programming language of Power BI and it was created in PowerPivot for Excel back in 2010, integrated in SSAS Tabular and then, in 2015 in Power BI. There are two main types of users who are learning Power BI (and also DAX if they really want to master Power

PAFnow Sign In

The ability to filter data by user is critical whenever sensitive information is shared, whether internally to an organization or even more so externally. This is often known as “row level se…

Most people working for a single organization are unlikely to run into this use case, but if you’re a consultant like me then this issue will annoy you. In Power BI Desktop, authentication ag…

Microsoft Power BI rose to its leading position in the BI market on the back of its top-shelf PowerQuery self-service ETL and VertiPaq in-memory engine as well as its familiarity and integration fo…

In a previous entry we saw how to use Cascading Style Sheets with Power BI’s HTML Content visual do apply dynamic visual effects outside what’s commonly expected within the platform. Wh…

This is a very short, simple article about how to have a multi-select slicer in Power BI. Power BI slicer is in fact multi-select by default, however, there is a very small option that if you set it, makes it even easier to use, let’s talk about it. If you want to learn more about Read more about Multi-Select Slicer in Power BI[…]

Over the past few years, along with the high adoption rate of Power BI, also came the development of new tools by the Power BI community. Customers, partners, and individual users are contributing tools that improve the productivity of users creating models and reports in Power BI. It’s an evolution of a trend that started several years ago with tools that support developers using Analysis Services as a backend platform for their enterprise Business Intelligence solutions.

This article is the state-of-the-art guide of the development tools for Power BI and Analysis Services models, providing guidance to improve productivity an

While some cloud BI tools such as Amazon QuickSight do all their authoring in the browser, Microsoft chose to develop a dedicated client creatively named Power BI Desktop. Its initial release as &#…

This article describes the available options to filter data in Power BI by using slicers and filters. After an initial description of the features available

Last year was a phenomenal year, and what better way to kick off 2020 than with a bunch of new features (including relationships and dependancies) to make your life easier as yo…

Data Vizioner

Can we use source control with Power BI? We get this question ALL THE TIME! Adam walks you through what your options are and how this works today with Power BI. ALM Toolkit: http://alm-toolkit.com/ Tabular Editor: https://tabulareditor.com/ Latest updates for Deployment Pipelines: https://powerbi.microsoft.com/blog/announcing-new-deployment-pipelines-capabilities/ Source Control Idea https://ideas.powerbi.com/ideas/idea/?ideaid=c73d887d-042e-4ca0-8216-bcb09bd282ab

Paradigm BI Posts - Paradigm BI and Active Business Intelligence Updates - This is the companion blog post to the Planner In Power BI YouTube Video.  If you ar

At BlueGranite, we have previously showcased the key AI features in Power BI, but I am taking a different approach by attempting to list all the ways AI is built into Power BI.

This trick will blow your mind! Learn how to create a custom rating visual by writing a few lines of DAX!

Automatic Page Refresh is not a commonly used feature, but it is very powerful when used in conjunction with the Power Automate visual to refresh Power BI datasets.