Power BI

This article describes how to optimize a text search operation in DAX. This technique can improve the performance of Power BI reports that use the contains

Discover the benefits of establishing a Centre of Excellence (COE) for data analytics with Azure and Power BI innovation in FSIs.

The new Power Apps drop shadow property for containers makes it easy to your apps look modern and stylish. We don't need to write complex CSS.

Placeholder shapes also known as shimmers appear where the data eventually displays. We can create this effect using the Power Apps Shimmer Control.

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

Power Apps can look amazing if you have a strong understanding of design principles & UI UX skills. Try these 5 Power Apps design tips.

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.

This is the 2nd article in a series about how to build your own timesheets app in Power Apps. The first article focused on creating a timesheet lines feature with the ability to add, edit, delete and save lines. This article will continue the tutorial to include the ability to create new timesheets and submit them for approval.

ABSTRACT 📄 Every Power BI developer has come across business requirements which were impossible or difficult to achieve using the Power BI core visuals. The HTML VizCreator custom visual puts an end to this! Learn from the creator of the visuals that even with little to no HTML knowledge, you can

ABSTRACT 📄 Every Power BI developer has come across business requirements which were impossible or difficult to achieve using the Power BI core visuals. The HTML VizCreator custom visual puts an end to this! Learn from the creator of the visuals that even with little to no HTML knowledge, you can

Through a co-design study, synthesized an engine to construct accessible visualization experiences for screen-reader users.

Power BI and DevOps

This post was authored by Andrey Mirskiy and Diego Fanesi.   Welcome to the first post of our series on how to use Azure Databricks SQL with Power BI. In this article, we will focus on how to connect to a Databricks SQL Warehouse from Power BI and query your Delta Lake to populate your dashboards. T...

Learn how Power BI advanced data model management is about empowering creators with advanced data modeling and publishing capabilities.

The missing documentation.

Inspired by Darrens Gosbell’s excellent blog post – Automatically generating measure descriptions for Power BI and Analysis Services with ChatGPT and Tabular Editor – Random Procrastina…

Yesterday I worked on a Power BI report where the client wanted to add vertical bar next to the slicer in order to make the design of the slicers a little bit nicer and also to make the slicers rec…

Why this error occurs and how you can avoid it

Reading Time: 3 minutes Data literacy has become a vital skill for individuals at any organization that wants to leverage data for better decision making and innovation. Data is everywhere, and decisions are often based on data-driven insights. Data Literacy’s Impact As the ability...

Find out how much memory and CPU is used by the Analysis Services engine and the Power Query engine during a dataset refresh in 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.

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