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!

It is important to perform patch function error handling In Power Apps any time you are updating records in a datasource.

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…

Learn how to use Power Automate to do a flexible Round Robin assignment where you can dynamically mark records on or off duty.

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

In this post, you can learn about the integration between Power Automate and Adobe and how it can help customers automate different scenarios around handling PDFs.

Previously, you needed to install and configure an on-premises data gateway to trigger your desktop flows from the cloud. We are excited to announce that Power Automate Desktop can now connect your machine directly to the cloud and run desktop flows without the use of a gateway. We have also introduced new machine-management capabilities to help scale your robotic process automation (RPA). Try them out starting today, available in preview.

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[…]