Power BI

Bring value to the visuals in your report by highlighting data points based on user selection of slicer values!

In this tutorial, we will learn how to convert cumulative numbers to incremental values using Power Query. In one of our earlier COVID-19 tutorials here, we learned how to convert cumulative values to incremental ones using DAX. We worked with Johns Hopkins University’s COVID-19 dataset that includes only the cumulative confirmed cases and applied the […]

This is the update for the Power BI features from the Microsoft Business Applications Summit for 2021 held online.

We’re excited to announce a new sharing experience that allows sharing reports via links. Previously in the old experience, we supported sharing reports by granting direct access. For the new experience, reports can be shared via links in addition to direct access sharing.

Show images in Excel cells using Power BI Organisation Data Types

e are excited to announce the public preview of Backup and Restore for datasets in Power BI Premium and Premium per User (PPU). You can now use SQL Server Management Studio (SSMS), Analysis Services cmdlets for PowerShell, and other tools to perform backup and restore operations in Power BI via XMLA endpoints in much the same way as you would for tabular models in Azure Analysis Services (Azure AS).

To set the stage, I need you to travel back in time with me a bit.The year was 2019, and none of us had ever heard of COVID-19…those were simpler times.I was working on a data model that had A LOT of …

The Query Plan visual will allow you to understand what’s happening under the hood of your query with more details than the Step Folding indicator.

The Microsoft Business Applications Summit 2021 happened recently, just a couple of weeks after the Power BI Summit, and there were a bunch of exciting announcements and updates from the Power BI team. If you missed seeing them all in one place, this article and video are a nutshell of all of those in one Read more about All Power BI Announcements of Microsoft Business Applications Summit 2021 in One Place[…]

We introduce to you the Explicit Measures Podcast. Where we discuss and have fun talking about the why we do what we do as Power BI Developers

Today we are excited to announce the initial availability of Power BI connected PivotTables in Excel for the web. As part of our journey to simplify enterprise data discovery and analysis in Excel, …

Organizations exist to achieve business objectives and in today’s data driven world, we know that progress is measured through data. However, this is often challenging as goal tracking systems are disconnected from your business data and often require manual updates. Not only that, but goals need to be optimized for teamwork, tightly integrated into core business processes, and easily extended. We are very excited to announce the public preview of Goals in Power BI. Read more in this blog!

Microsoft Business Applications Summit is one of my favorite events of the year. While we connect with our customers, our community, and our partners every day, at the Microsoft Business Applications Summit, we share some of our most important announcements on our strategy and roadmap. We prepare and deliver some really exciting demos and our product managers and engineers look forward to answering all of your questions.

This is the first post in a series to create a Star Wars report. This post handles the issue of using a parameter as the url in a web Power Query. This type of data source is referred to as a Dynamic …

[Deprecated] This is the Microsoft assembly for the .Net 4.0 Dynamic language functionality. - zzzprojects/System.Linq.Dynamic

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…