Power BI

In December 2020, we launched the preview of DirectQuery for Power BI Datasets and Analysis Services. Since then, we have worked with many of you to improve on this feature and get it ready for general availability. Today we are announcing that this feature has reached general availability.

This article describes how to use the Group By Columns property to store the slicer selection by using the same column used in a SWITCH function to optimize

I always enjoy it when we get new DAX functions, especially so for the new set of WINDOW Functions recently added. As part of the April 2023 release of Power BI Desktop, we now have a RANK function and the ability to use a measure to control the order within the existing WINDOW function. The … Continue reading DAX Pareto Calculation

Comparing snapshots by state shows how many ids have moved from one state to another between 2 snapshots providing insights on bottlenecks.

This blog post explains how to only load data if there are actual rows in the table. This allows you to save on potential query costs when using Power Query in #PowerBI

The April 2023 release of Power BI desktop introduced a new preview feature called dynamic format strings for measures. This allows us to return values with different formats from the same measure.…

New data flavors require new ways for storing it! Learn everything you need to know about the Parquet file format

Want to format a measure based on a slicer selection, the measure value, or another conditional way? Now you can! With dynamic format strings for measures a DAX expression can now be used to determine what format string a measure will use.

In this short article, I show you how to upgrade the compatibility level of models managed in Tabular Editor to be able to use new/preview features like Dynamic Format Strings.

Introduction Automated data storytelling is a powerful way to transform complex data visualizations into meaningful narratives. By leveraging OpenAI’s natural language generation capabilities…

data business intelligence bi machine learning mi professionals contractors azure Power bi analysis ETL ELT modeling automation training leadership

Automatic page background image in Power BI is not super easy because you need a theme file and a usable URL. This blog pots walks through the process.

Data preparation is crucial in data analysis and machine learning projects. This article will explore basic concepts and extensive details on the various aspects of data preparation.

In recent years, Power BI has become one of the most widely used business intelligence (BI) tools. Power BI is more than just a reporting tool; it is a comprehensive analytical platform that enables users to collaborate on data insights and share them internally and externally. In addition to creating reports and dashboards, Power BI … Continue reading Power BI Governance, What Organisations Need to Know

Pareto 80/20 calculation using WINDOW function in Power BI

I show you how you can modify or change your dynamic format string after you created it in Power BI desktop.

In today’s data-driven world, organizations need to harness the power of data analytics to make informed decisions, drive growth, and stay competitive. Microsoft offers two powerful tools for…

Working with many companies that implement Power BI, this is a question that comes along every single time; Should we enable workspace creation for all our users, or limit it to a specific security…

Welcome to the Power BI April 2023 Monthly Update! We are happy to announce that Power BI Desktop is fully supported on Azure Virtual Desktop (formerly Windows Virtual Desktop) and Windows 365. This month, we have updates to the Preview feature On-object that was announced last month and dynamic format strings for measures. We have additional features in Reporting, Data Connectivity, Service, Paginated Reports, Mobile, and Visualizations. Read on to explore all we have to offer this month!

Learn how to use custom format strings in Power BI Desktop to customize how fields appear in visuals.

SQL has been used to get data out of databases for decades. Dataverse is a database. So lets use SQL on Dataverse to fetch data into a report

Creating variables and collections is an essential part of the app building process. Therefore, we are excited to announce the general availability of an improved, seamless experience that enables makers to see variables and collections directly in-line with the canvas designer! Gone are the days of switching between the app designer and backstage to set…

A guide on how to send ChatGPT prompts inside Power Query scripts and save the data right back as new columns into your actual data.

Welcome to the Power BI April 2023 Monthly Update! We are happy to announce that Power BI Desktop is fully supported on Azure Virtual Desktop (formerly Windows Virtual Desktop) and Windows 365. This month, we have updates to the Preview feature On-object that was announced last month and dynamic format strings for measures. We have additional features in Reporting, Data Connectivity, Service, Paginated Reports, Mobile, and Visualizations. Read on to explore all we have to offer this month!

Introducing data model editing in the web! A first step towards modeling parity in the Service.

Contribute to PBI-David/Deneb-Showcase development by creating an account on GitHub

Following on from the launch of the new look for model driven apps, we’re making the same modern controls available to canvas apps through an opt in preview. The new controls bring the following improvements:  Modern – A focused and less cluttered design that supports richer interaction states and elevation, provides a higher usability baseline…

Timesheets are a popular app to make in Power Apps. In this step-by-step tutorial, I'll show you how to build your own timesheets app.

AI Copilot overview in Power Apps.

On this page you will find documentation on how to use all 13 of the new Power Apps Modern controls for canvas apps.