Power BI

Today, we are excited to announce General Availability (GA) of automatic aggregations, along with several important improvements. By using automatic aggregations in Power BI Premium, you can unlock cloud-scale data volumes for interactive analysis. Automatic aggregations import data into the dataset only at the aggregated level while leaving the detail data at the source to minimize data duplication. In this way, most BI queries can benefit from Power BI’s blazing fast query performance in import mode, while occasional detail queries can still work transparently against the data source in DirectQuery mode.

Like many, I was very excited to see the new Field Parameters feature that shipped in preview in the latest May 2022 release. It enables you to do some things that used to be complex in a really ea…

We are excited to announce general availability for metrics in Power BI (formerly called goals) along with new features to deliver scorecarding scenarios even more effectively within Power BI. Additionally, we’re pleased to share plans for how Power BI will work with the new Viva Goals offering from Microsoft to empower organizations more effectively meet their goals with OKR experiences connected to Power BI data, delivered by Viva Goals.

Microsoft Build represents the ultimate developer event. A hundred thousand developers from across the world gather for three days with their peers to learn, engage, and collaborate on the latest innovations and tools from Microsoft.

Announcing public preview of datamart in Power BI, a new Power BI Premium self-service capability that enables users to uncover actionable insights through their own independent and dependent data sets. For the first time ever, we are empowering everyone with the right-sized ability to build datamarts that can be succinctly and centrally governed and managed for workloads up to a terabyte. This new out-of-the-box Power BI capability effortlessly brings turnkey data warehousing to millions of Power BI users, alleviates demands on IT and accelerates time to insights from months to minutes.

The Power Query Editor Remove Rows function can help to prepare your data sets to create meaningful reports. Follow this tutorial to learn more.

3 key things to know for your data analysis journey.

say good bye to bookmarks and selection panes

As part of our GA work for the ExecuteQueries REST API, we delivered a new Power Automate action to run queries against Power BI datasets. This action delivers a straightforward low-code/no-code experience to BI users who want to streamline repetitive, mundane tasks and processes. The purpose of this blog post is to help you get started running queries against datasets in Power Automate. It covers exporting data into csv files, building a solution to test datasets, and creating BI-driven cloud flows.

Users can author formatted tables using a modern low code web-based authoring experience in the Power BI service.

Welcome to the May 2022 update. We are thrilled to announce the general availability of Canvas zoom and Data point rectangle select features, Field parameters and Error bars for columns and line combination charts new preview features, new Format pane and managing composite models preview feature updates. There is more to explore, please continue to read on.

Check this simple trick to enhance user experience when using Fields parameter feature in Power BI!

With today’s preview launch of Power BI datamarts, there is yet another data entity to contend with in the Power BI ecosystem. I plan to update this entry as datamarts mature in the months to…

Here is a real-world M Query scenario recently implemented for a client who has signed contracts in PDF format that offers incentives for sales.

At the 2022 PASS Community Data Summit this November, I’m thrilled to be co-presenting a full-day pre-conference session with the one and only Melissa Coates [blog | Twitter | LinkedIn]. We’ll be p…

May 2022's release of Power BI Desktop is the best releases we've seen in several years. They released a new gem of a featured called FIELD

Learn how to add dynamic names (labels) to Field Parameters ! During model refreshes the names will update based on specified logic . Which can be very useful for applying time intelligence labels , or other label logic that would benefit from changes during the model refresh cycle. Tun

ABSTRACT 📝 At the end of last year , one called ExecuteQueries was added to the endpoint portfolio in the Power BI REST API . It is an endpoint that allows you to extract data directly from datasets . Although it also brings limitations, I think that its advantages outweigh them. So what

The tenant settings in the admin portal of the Power BI Service are incredibly important. The tenant settings include a wide-ranging number of things that significantly affect the user experience. It’s really important to manage the tenant settings effectively. In this post I’m going to talk about t

Case I have one big Power BI dataset with multiple source tables and one of those source tables is refreshed once every hour and all the ot...

Since its inception, Power BI has been a leading tool in self-service analytics. This week at Build, Microsoft released an exciting new feature available to preview – Power BI Datamarts! Power BI Datamarts enable self-service users to build and distribute an analytical solution from end-to-end. Data ingestion and preparation, data exploration and analysis, data modeling, and report design can all be done in a low- or no-code experience in Power BI Service!

Guest Author: Henk-Jan van Well As a follow up to two older Matrix Multiplication posts here and here, I would like to share with you an alternative query for matrix multiplication using the Cartesian product-functionality within Power Query. This post was contributed by guest author Henk-Jan van Well.  When reading through Gil’s book I got […]

In many businesses, sales don't come in equally distributed over the year. Learn how to deal with Forecasting with seasonality in Power BI.

Do yo want to return an (empty) table instead of an error message? This function creates a table string from schema in Power Query.

This article analyzes the fields parameters feature in Power BI, unveiling some of the internals of its implementation. IMPORTANT: while this feature is in

Let report readers dynamically change the visuals in a report using field parameters.

This higher-effort engagement stage often requires you to explore new space, and it’s where you’ll need to stretch your skills and abilities.

Imagine you bought a brand new, top of the line red Ferrari, but in place of a performance driver's seat, it came with a $10 folding lawn chair installed... 26 comments on LinkedIn