Power BI

Data Source management enhancements on Power Platform admin center

In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection with a slicer. This can be applied to any number of months. The end result in this scenario is a report where the user has selected a date with

A lot has changed since we first released the preview of the small multiples feature — let’s take a look at what we’ve shipped since then, discuss updates to our roadmap, and explore opportunities to provide feedback.

It’s just over a week after MBAS. The storm has quieted down, and life is back to normal. This can only mean one thing – it’s time for this month’s update! Next to all the things we covered at MBAS there are more things happening, including a new preview of visual tooltips. Next to that, you can now quickly create reports from SharePoint lists and sensitivity labels are not inherited downstream. There is so much more in this update, so read on!

There were a lot of exciting announcements at the Microsoft Business Applications Summit this week but if you only watched the keynotes or read the recap on the Power BI blog you will have missed a…

How to build a process using Visual Studio Code that allows you to visualise and analyse a Power BI dataset refresh in real-time.

Power BI Goals help you visualize and monitor your business’ statistics, analytics, and metrics (SAM) over time. I'll show you how to...

Announcing new capability that makes it easy for template app users to update their apps in one simple step!

XMLA endpoints in Power BI supports out-of-line (OOL) bindings, an advanced Analysis Services capability to temporarily change the data bindings of certain metadata objects in a dataset for the duration of a refresh command, such as data sources, partitions, and expressions.

This article describes how to use KEEPFILTERS in DAX iterator functions to preserve arbitrarily shaped filters in context transition. When you apply a filter in CALCULATE or CALCULATETABLE, by default the filter overwrites any existing filter over the columns specified in the filter. In order to avoi

Business analytics refers to the digital analysis of data from a range of sources, giving organizations the information they need to make informed decisions rather than relying on guesswork. This …

When you use a parameter as the url in a web query, the data source is a Dynamic Data Source and will not refresh in the Power BI service.

There is a big chance you haven’t been able to catch all the news at MBAS or that some items just escaped your attention as they were drowned out by the next big thing. Don’t worry, we’ve got your back. In this post we do our best to recap what happened en provide links to the detail blog posts where applicable. Also, we’ll list the session so you can go and re-watch them.

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