Power BI

Creating a Query catalog of a Power BI workspace, using read-access XMLA endpoints. and a C# Azure Function.

This is an an "unboxing" post on Power BI Goals so that you get a quick look at the major parts of the feature.

Each year, Gartner invite vendors from the BI and Analytics Magic Quadrant to show how their product can help solve real-world problems and find insights in real-world data. In previous years we’ve looked into the opioid crisis in the USA, global happiness, and life expectancy. This year the impact of COVID-19 was the obvious candidate! There is a wealth of data available on the internet, and while Gartner gave us some direction for the business questions we would investigate, we could use data from any number of sources to do the analysis. In this blog post you can see what we built and we will explain how we built it.

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