Power BI

Learn how to view the lineage of Fabric items.

We have some very exciting news to share with you today! We are thrilled to announce that we have just launched the public preview of Direct Lake mode for Power BI datasets in Fabric! Fabric is taking a bold bet on open data formats in OneLake.

Microsoft Fabric is a new platform designed to bring together the data and analytics features of Microsoft products like Power BI and Azure Synapse Analytics into a single SaaS product. Its goal is to provide a smooth and consistent experience for both data professionals and business users, covering everything from data entry to gaining insights. … Continue reading Unveiling Microsoft Fabric’s Impact on Power BI Developers and Analysts

It’s a question I see popping up every now and then. Is Microsoft Fabric just a rebranding of existing Azure services like Synapse, Data Factory, Event Hub, Stream Analytics, etc.? Is it something more? Or is it something entirely new? I hate clickbait titles as much as you do. So, before we dive in, let me answer the question right away. No, Fabric is not just a rebranding. I would not even describe Fabric as an evolution (as Microsoft often does), but rather as a revolution! Now, let’s find out why.

Learn about Real-Time Intelligence in Microsoft Fabric.

What is Get events Say hello to effortless data connectivity and streaming, regardless of whether your data originates from new or established sources, streams, or events. With the new Get events experience you are unlocking connectivity and streaming prowess in your Fabric Real-Time Intelligence journey. Leveraging the Get events tool extends beyond mere data ingestion; it … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/unlock-the-power-of-real-time-intelligence-in-fabric-connect-and-stream-events-effortlessly-with-the-get-events-experience/" class="more-link">Continue reading<span class="screen-reader-text"> “Unlock the Power of Real-Time Intelligence in Fabric: Connect and stream events effortlessly with the Get events experience (preview)!”</span></a>

In this blog post I show you how to loop through data using a PySpark notebook in Fabric

Okay, Power BI community, we have a problem. 80+ votes is already enough to confirm that we indeed have a problem. “In Power BI, normalizing … Read More

Learn how to utilize APIs to build your Fabric KQL solutions. We’ll show you how to create items in Fabric and work within the data plane of Eventhouse and KQL Databa

When you store secrets in Azure Key Vault as described in the previous post in this series you need a way to fetch them when you need them

🎉 Exciting News: Eventhouse is Now Generally Available! 🎉 We’re thrilled to announce that Eventhouse, our innovative database workspace designed to manage and store event-based data, is now officially available for general use. Eventhouse is a cutting-edge database workspace meticulously crafted to manage and store event-based data. Engineered to handle data in motion, Eventhouse seamlessly … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/exciting-news-eventhouse-is-now-generally-available/" class="more-link">Continue reading<span class="screen-reader-text"> “Exciting News: Eventhouse is Now Generally Available!”</span></a>

Migrating to F-SKUs does not force you to use Fabric

Showing the path of the selected data point in a native Scatter plot of Power BI can be done with some hacks and some DAX. This article shows one way to do it.

This is it. The way you write DAX changes today with the preview of visual calculations!

The Power BI integration with Azure Log Analytics has been enhanced through the introduction of a new event known as ‘ExecutionMetrics’. This addition will improve customers ability to obtain more details about their semantic model activities.

VahidDM website has many valuable articles about DAX, Power Query, Data visualisation, Power BI, Power Platform, and Tips and Tricks.

In this final installment of our four-part mini-series on DAX window functions, we’ll be focusing on a new development. The May release of Power BI Desktop has enriched all DAX window functio…

How to create a DAX measure to notify users filters have been applied to a report when there are hidden slicer or filter panels.

Deep dive into Analysis services 2022 new features deep dive part 1: Composite Model and DAX

Support for the DAX UserCulture function in Power BI Premium is now available.

We are excited to announce the initial release of a query performance optimization aimed at processing Data Analysis Expressions (DAX) queries more efficiently, known as “Horizontal Fusion”.

With lo-code we can automate exporting data from Power BI visuals without any REST API knowledge. We need simply copy DAX queries from “Performance Analyzer”, past it in Power Automate inside “run a query against dataset” action . Then we can perform export operation according to our requirements.

If you want to: Present interesting Power BI discoveries to your colleagues Test your DAX Measures, reporting on a very clean Star schema Discover multiple DAX Functions Show different Power BI features by examples Then this Lazy DAX file is for you! It’s a Power BI Desktop file that you can freely download on my […]

easily compare different categories on the same axes

Comparative Analysis by different values in same dimension in Power BI Have you ever wanted to compare metrics between 2 sets of selected values in the same dimension in a Power BI report? For example, let’s say you wanted to compare claims metrics of one hospital or a group of hospitals to another ...

A little #PowerBI tip - want to get a list of columns in a table? Great for documentation!Run the following #DAX query in DAX Studio or Tabular Editor 3. Preface your tablename with '$' and ignore …

This blog post shows how to find out which columns are being used the most in visuals and DAX measures in Power BI Premium/PPU

If you aren’t using Tabular Editor to format all of your DAX code for you, you are missing out. I’ve written a super short script that will format all of your DAX code in measures, and make it look picture perfect in Power BI Desktop. First, you need to download Tabular Editor. The free version is

A handy feature of Tabular Editor is the ability to create C# scripts to simplify & automate basic development tasks. One such task that can be easily automated is the formatting of DAX code in the data model . Particularly upon inheriting a data model from someone else, formatting the DA