Power BI

The enterprise Business Intelligence and IT community have been anxiously awaiting this capability for many years and it has finally arrived – at least in Preview form for testing and prototy…

TL;DR : using Fabric Python Notebook to Sort and Save  Parquet files  up to 100 GB shows that DuckDB is very competitive compared to Spark even when using Only half the resources available in a com…

We are excited to announce that Forrester has recognized Microsoft as a Leader in The Forrester Wave™: Augmented BI Platforms, Q2 2023. Microsoft received the highest score of any vendor in the strategy category.

We brought Marco in to help explain the TIMELINE update within DAX Studio. This can help you understand performance a bit deeper when optimizing your DAX and models. This is one to watch! DAX Studio https://daxstudio.org Marco Russo Tweets by marcorus https://www.linkedin.com/in/sqlbi/ https://sqlbi.com Optimizing DAX Video Course https://www.sqlbi.com/p/optimizing-dax-video-course/

We are pleased to announce the public preview of a Power BI Desktop Developer Mode, which offers a new save option to your Power BI developers that unblock source control and CI/CD best practices

Bring sexy back to your career by ditching your GUI-based comfort.

For many people, data storytelling is just an extension of data visualization. Most of the focus is spent on the explanatory data visualization techniques that are employed in data stories. By focusing primarily on the visuals, the two other key elements of data stories--data and narrative--are often misunderstood and overlooked. It's time for organizations to embrace a more balanced approach to data storytelling that is centered around the effective communication of insights, not just the data visualization aspects.

Welcome to the June 2023 update! This month, we are please to announce updatest to On-Object interaction, a new demo experience to the Power BI embedded playground which simplifies the process of exploring embedding Power BI in your application, creating Power BI reports instantly with Jupyter Notebooks, and Power BI Desktop Developer mode. Read on for all of these updates and more in Reporting, Data connectivity and preparation, Service, Embedded, Developers, and Visualizations.

With the February and March 2023 Desktop releases comes more features enabling us to enhance our KPI visualisations out of the box. This article talks specifically to the DAX function LINEST() and the new Subtitle and Dividers formatting options. For a simple enhancement, we can add the divider to KPI Cards, without title and subtitle,… Continue reading KPI trend indicators on Core Visuals

In my last article I introduced the three different connectivity modes that are available for Power BI to fetch data from a source, with a specific focus on when and where to use DirectQuery connections.  In this article I am going to go deeper and introduce the modelling aspects of a DirectQuery [...]Read More »

The New Card Visual is out an in preview – and it’s absolutely fantastic. With this first drop of the Card Visual we can see flexible formatting options such as accent bars, images, backgrounds, padding, spacing and alignment. For a more comprehensive look check out this post. There are a lot more features on the… Continue reading Adding sparklines to New Card Visual

New! Users can now generate a link to chart from organizational app and use it in PowerPoint. This newly added feature allows users to infuse data and insights from org app charts into their presentations and work with smart insights, filters, and live data.

Power BI Desktop has a new card visual that allows users to display multiple cards in a single container with full control over each card’s components. It supports multiple fields and offers refined formatting settings.

TL;DR ; Although the optimal file size and the row group size spec  is not published by Microsoft, PowerBI Direct Lake mode works just fine with Delta table generated by non-Microsoft tools an…

Export and import Power Query template files in Excel and Fabric

Reading Time: 1 minute Forty Days of Fabric! Learn a bit about Microsoft Fabric every day. Maybe you caught the announcements around Microsoft Build nearly three weeks ago, but there is so much new material to digest with the evolution of Microsoft analytics with...

In this blog post I show how you can use the Power BI Field parameters to create a hierarchy for your field values

Microsoft Fabric is out there for a few weeks now. With the release of Fabric, a new concept in line with data-mesh architectures became available in Fabric, or Power BI if you will. With the intro…

Learn the differences between Fabric Lakehouse, Data Warehouse and Power BI Datamart, and how to choose the right one for your scenario.

Calculating the trend of a line chart can be possible using the Analytics tab under the format section of the chart. What if we need to store this calculation and reuse it or show it as a separate chart? Actual Chart as below The trend of the chart The first question is about calculating the Read more about Calculating the trend of a Chart using DAX ( Smoothing Moving Average)[…]

This is the third post in a 3-part blog series on Power BI with Azure Databricks SQL authored by Andrey Mirskiy and Diego Fanesi. Read Part 1: Power Up your BI with Microsoft Power BI and Azure Databricks Lakehouse: part 1 - Essentials and Part 2: Power Up your BI with Microsoft Power BI and Lakehou...

Hi, You may download my PBI file from here. Hope this helps.

Hi, This measure worksMeasure = COUNTROWS(FILTER(VALUES('Table'[ID]),CALCULATE(COUNTROWS('Table'),'Table'[status]="approve")=1&&CALCULATE(COUNTROWS('Table'),'Table'[status]="reject")=0)) Hope this helps.

A very quick blog on how to import Delta Table to PowerBI Desktop, probably your first question is why ? doesn’t the new Direct Lake solve that ? Direct lake assumes the compute to be running…

In this blog article, we will explore four end-to-end scenarios that are typical paths our customers take to extract value and insights from their data using Microsoft Fabric. In these scenarios, we will show you how Fabric seamlessly addresses common architectural scenarios with a single service that encompasses data ingestion, transformation, storage, and exposure through reports or SQL endpoints.

An introduction to the Logical Thinking Process

Simple drawings illustrating the main concepts of Microsoft Fabric to empower anyone to build stuff on Fabric.

When you share insights with audiences, they must be put in context so they can be fully understood and appreciated. While almost everyone would agree on the importance and value of context, there is little-to-no guidance on how to contextualize numbers. In this post, I share six ways in which you can add valuable background information to your key insights so they can resonate more deeply with audiences.