Power BI

In today’s ever-evolving world of data management, security is a paramount concern for organizations. We are committed to providing our customers with robust solutions that empower them to safeguard their data effectively. That’s why we are thrilled to introduce Dynamic Data Masking (DDM) for Fabric Warehouse and SQL Endpoint in Lakehouse! What is Dynamic Data … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-dynamic-data-masking-for-fabric-warehouse-and-lakehouse-sql-endpoint/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing: Dynamic Data Masking for Fabric Warehouse and Lakehouse SQL Endpoint”</span></a>

This article describes how to use the DAX time intelligence calculations applied to the latest period available in the data, also known as the “current”

We are excited to announce that the Data Warehouse now supports sp_rename. With sp_rename, you can rename user objects like Tables, Stored Procedures, Functions etc. Here is an example of how to use sp_rename that fixes a spelling mistake for city: When you use these features, change the schema an object belongs to or drop … p class="link-more"a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-fabric-warehouse-support-for-sp_rename/" class="more-link"Continue readingspan class="screen-reader-text" “Announcing: Fabric Warehouse support for sp_rename”/span/a

In this post, we will learn How to offline download WebView2 for Power BI Desktop if you don't have an internet connection on your current machine.

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>

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>

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 …

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