Power BI

Reflex is many things next to one of the workloads of Microsoft Fabric. Before I delve into these things in more detail in later articles (yes, maybe this is the birth of another series of articles), I want to say this: Reflex is cool. It was never that simple to watch your data in your Power BI datasets (and this is only one of the capabilities of Reflex). Because I need images whenever I try to understand things, I start with a simple image of Reflex: I consider Reflex a watchdog! Reflex is watching something and alarms me or someone else when something happens - a defined condition is met. It will be likely that the first thing you ask Reflex to watch is a measure in one of your Power BI datasets. The dataset I use in this article is the dataset that holds the status of my on-premises data gateways. I store the status of each on-premises data gateway in a delta table-you can read about this here: (https://www.minceddata.info/2023/10/16/power-bi-gateway-monitoring-and-more-using-microsoft-fabric/) I defined a measure that returns 1 if the status of the gateway is “NotReachable.” This status indicates that something has happened, and the Power BI Service cannot use the gateway to support import and Direct Query solutions. This measure is simple: a new Measure = var maxActivityDateTime = CALCULATE( MAX( 'view1'[activityDateTime] ) ) return CALCULATE( COUNT( 'view1'[GatewayStatus] ) , 'view1'[GatewayStatus] = "NotReachable" , 'view1'[activityDateTime] = maxActivityDateTime ) The table ‘view1’ holds the status information about all the on-premises data gateways. The measure returns a value that is greater than 0 when the status of one the gateways becomes “NotReachable.” This measure returns the value only for the latest available status. The timestamp is created inside the notebook that is retrieving the status information and stored to the delta table.

One of my top three favorite features in Microsoft Fabric

Enhance productivity in Fabric Notebook using mssparkutils' fastcp, a Python wrapper for azcopy, providing 9x faster file copying

🚀 Using notebooks in #MicrosoftFabric: Whenever technology advances for citizen #PowerBI developers, it’s impossible for me not to pay attention! I’m thrilled to share how recent improv…

We are excited to announce the availability of Column-Level and Row-Level Security in Fabric Warehouse & SQL Endpoint in Public preview in all regions! In today’s data-driven world, organizations are constantly collecting vast amounts of sensitive information that fuels their operations, decision-making processes, and competitive edge. While data accessibility is essential for business success, ensuring … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-column-level-row-level-security-for-fabric-warehouse-sql-endpoint/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing: Column-Level & Row-Level Security for Fabric Warehouse & SQL Endpoint”</span></a>

Meet your new favourite action hero, Data Activator. It’s the newest experience to be added to Microsoft’s unified Software-as-a-Service (SaaS) platform Fabric, having been made available in the public preview at the beginning of October. But what is it? What does it do? How can you use it?

Introducing MeasureMaze: a Python library for enhanced Power BI measure dependency visualization, network analysis, and workflow optimization

Learn about the Power BI Desktop project report folder.

Learn about the Power BI Desktop project dataset folder.

Learn about Git integration with Power BI Desktop. projects.

Understand the workflow of using Git integration with deployment pipelines to manage the lifecycle of your apps.

Learn about Azure Pipelines and how to use them with Desktop projects.

Business Assist Forecast is a tool that enables quick and confident forecasting of future support volume based on historical data, which can save time compared..

In this blog, I will share 7 golden rules for writing DAX formulas that will help you create more sophisticated and effective calculations.

This is my personal blog, but a lot of what I post here is informed by my work at Microsoft, filtered through the lens of my personal reflection. For the past two and a half years my work has inclu…

Link visual IDs found in Log Analytics to visuals in a Power BI report

The model view now has even more to offer! We are excited to share the public preview of the Model explorer in the model view of Power BI Desktop.

Using Microsoft Fabric’s Lakehouse we can manage different data sources. Today Microsoft Copilot is very popular, and we hope that Microsoft Fabric can become an indispensable part of enterprise data management and make it easier for enterprise data to connect with LLM. This blog will combines data engineering and data science perspectives to construct Copilot … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/chat-your-data-in-microsoft-fabric-with-semantic-kernel/" class="more-link">Continue reading<span class="screen-reader-text"> “Chat your data in Microsoft Fabric with Semantic Kernel”</span></a>

The foundation of centralized connection management is granular access control. Power BI always enforces granular access control for shareable cloud connections (SCCs). For all other data connection types, it can be enabled at the tenant, workspace, and dataset level.

You asked, we deliver! The option to create a customized pipeline of 2-10 stages is now available. Check it out!

In this post, I’ll explain the how and why of: How to connect Tableau to Power BI semantic models. How to connect Tableau to Fabric lakehouses (and other items that have a SQL endpoint).

Table of Contents Introduction to Data Lineage With more emphasis on data management and governance than ever before, understanding the journey of data from its source to its destination is […]

A while ago I had a little blog post series about cool stuff in Snowflake. I'm starting up a similar series, but this time for Microsoft Fabric. I'm not going to cover the basic of Fabric, hundreds of bloggers have already done that. I'm going to cover little bits & pieces that I find interesting,

In this short article, we look at the consequences of having a case-specific collation in your Power BI semantic model. This is particularly important as Direct Lake models created in the Fabric user experience have a case-sensitive collation applied, automatically.

There are 2 kinds of companies currently active in the Microsoft data space: those who are migrating to Microsoft Fabric, and those who will soon be planning their migration to Microsoft Fabric. 😅 One question that often comes back is Should I focus on the Lakehouse or the Data Warehouse? Let’s answer that in this post. I can already tell you this: you’re asking the wrong question 😉

With the latest OneLake file explorer v1.0.10.0 (download here), you can now seamlessly transition from browsing your OneLake data in Windows File Explorer to accessing it in the online Fabric portal.  Perhaps you are using OneLake file explorer to upload data that you want to analyze in a Fabric Notebook.  After uploading the data, you can … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/onelake-file-explorer-easy-access-to-open-workspaces-and-items-online/" class="more-link">Continue reading<span class="screen-reader-text"> “OneLake file explorer: easy access to open workspaces and items online”</span></a>

Microsoft Fabric offers a set of different tools to explore and prepare the data for analysis and from that perspective, notebooks have become one of the quickest ways to get started with data exploration. This post draws its inspiration from the world of experimentation, exploration, and seamless integration into Microsoft Fabric- Data Science in Microsoft … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-change-the-game-exploring-the-data/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric Change the Game: Exploring the data”</span></a>