Power BI

How to Load data from Synapse to Fabric a step by step guide.

Unlock the Power of Reusing Your Library in the Lakehouse with This Step-by-Step Guide. Fabric provides you with different options to build your analytics solution. If you decide to use Lakehouse and code your solution with Python you may want to reuse some functions and reuse certain business logic across your code. Once your library … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-changing-the-game-using-your-own-library-with-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric Changing the game: Using your own library with Microsoft Fabric”</span></a>

This blog post show I created a Power BI report which shows the Microsoft Fabric support page, after which I subscribe to see the daily status.

Over six years ago now I wrote what proved to be a very popular post here on my blog called “So, what is the UDM?”. It was written in response to the widespread confusion around the time of the rel…

Working with tables in the Microsoft Fabric lakehouse may look like a straightforward task - however, there are many nuances to be aware of before you decide to go one way or another

This is the second part of a series of articles, part 1 (basics and background) was published before. Reminder: Environment strategy You must establish separate app development and production environments to adhere to application lifecycle managemen...

On July 5th, we announced the ability to clone data warehouse tables within Microsoft Fabric as of current point in time. The ability to clone tables is a powerful technique that not only empowers businesses to streamline reporting and analytics but also helps expedite development and testing processes.  While data warehouses constantly evolve, it is often … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/time-travelling-through-data-the-magic-of-table-clones/" class="more-link">Continue reading<span class="screen-reader-text"> “Time-Travelling through data: The Magic of Table clones”</span></a>

Today, we are excited to share a list of user experience features that we’ve shipped within Fabric Warehouse during the month of Nov 2023, to help drive productivity and simplify the experience. The following are the list of features: The rest of the blog describes each of these features in greater detail. Clone table experience … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-warehouse-user-experience-updates/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric Warehouse user experience updates”</span></a>

On July 5th, we announced the ability to clone data warehouse tables within Microsoft Fabric as of current point in time. The ability to clone tables is a powerful technique that not only empowers businesses to streamline reporting and analytics but also helps expedite development and testing processes.  While data warehouses constantly evolve, it is often … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/time-travelling-through-data-the-magic-of-table-clones/" class="more-link">Continue reading<span class="screen-reader-text"> “Time-Travelling through data: The Magic of Table clones”</span></a>

Welcome to the Power Apps monthly feature update! We will use this blog to share a summary of product, community, and learning updates from throughout the month so you can access it in one easy place. We’ve got a great set of updates across for our makers, security and monitor improvements, and updates to model…

Introduction

When I talk to people who are not deep into the Power BI world, I often get the impression that they think of Power BI as a visualization tool exclusively. While that is true to a certain extent, it seems to me that they are not seeing the bigger picture – or maybe it’s better to say – they see just

The “GetCapacityTenantSettingOverrides” API is a response to the concerns raised by tenant administrators. It offers transparency and insight that administrators need to govern Fabric.

Microsoft OneLake provides a single unified storage location for all your data analytics needs. Whether your data is stored directly in OneLake or through other storage accounts, all your data is accessible through OneLake. Microsoft OneLake makes this possible through a virtualization layer called Shortcuts. Shortcuts in OneLake allow you to reference different storage locations … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/create-multiple-shortcuts-faster-and-easier/" class="more-link">Continue reading<span class="screen-reader-text"> “Create multiple shortcuts faster and easier”</span></a>

Master the art of creating and utilizing flags as measures with DAX in Power BI. Dive into insightful techniques and boost your data analytics skills.

Dataset refresh orchestration with Power Automate is a way to mitigate the negative impact of dataset refreshes can have on your Server.

A comprehensive guide to using Data pipelines in Microsoft Fabric Want to retrieve numerous tables from databases across multiple data sources in a fairly simple, reliable, and scalable manner? Data Factory (incl. Data Pipelines) role in Microsoft Fabric Then, read along for this deep-dive into Data

Earlier this year at Build, we launched the experimental preview of Microsoft Dataverse low code plug-ins, a new capability at forefront of the low code and extensibility story trend in modern business workflows. Today, we’re thrilled to announce that low code plug-ins are now available in public preview, with new features and improvements that make…

We are proud to announce that the modern, refreshed look for model-driven apps is now generally available as of 2023 Release Wave 2. Released as part of a preview in February 2023, we’ve made considerable updates and brought a new opt-in toggle for end users. Improvements since February Updated read-only style including re-introducing the lock…

Work queues enable complex processes to be broken down into smaller parts, resulting in optimized performance and reduced risk of SLA breaches.

ALM, Code-first, Custom Connector, Fusion development, Power Apps, Power Platform, Power Platform CLI, Power Platform Developer

AI offers tremendous potential to empower workers around the world – but only if everyone, everywhere has the skills to use it. It's little surprise that, according to the World Economic Forum, AI skills represent the third-highest priority for companies’ training strategies, right alongside analyti

We are excited to announce that the Data Warehouse now publishes all Inserts, Updates and Deletes for each table to their Delta Lake Log in OneLake! Our vision is to break down data silos and make it really easy to share data from your Data Warehouses with other teams who use different services without having … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-fabric-warehouse-publishing-full-dml-to-delta-lake-logs/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing: Fabric Warehouse publishing full DML to Delta Lake Logs”</span></a>

Microsoft Fabric October 2023 update We have a lot of features this month including updates to the Item type icons, Keyword-Based Filtering of Tenant Settings, On-object Interaction updates, Eventstream Kafka Endpoints and many more. Continue reading for more details on our new and updated features! Core Item type icons Admin Keyword-Based Filtering of Tenant Settings … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/microsoft-fabric-october-2023-update-2/" class="more-link">Continue reading<span class="screen-reader-text"> “Microsoft Fabric October 2023 update”</span></a>

We’re back with another data culture post and video with swords, and this time we’re bringing out the big blade. This time we’re bringing out the montante. In the 1500s and 1600s …

How to get data from Power BI into Excel and use Excel's Python integration to analyse it

Data Factory in Microsoft Fabric is an AMAZING tool that allows us to combine the flexibility of Data pipelines and ease of a Dataflow Gen2 to create some nifty solutions with a tiny smidge of code. One of the most common use cases is the ability to load new data into a destination for a […]

No matter what, when the Power BI on-premises gateways are not working as expected, data will not refresh, and direct query queries will not succeed. It's almost simple to create a monitoring solution using Microsoft Fabric

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.