Power BI

We are excited to announce the preview of the OPENROWSET function in the Fabric Data Warehouse and SQL endpoint for Lakehouse. This powerful function allows you to read the content of external files stored in Azure Data Lake Storage and Azure Blob Storage without the need to ingest them into the Data Warehouse. With the … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-openrowset-function-public-preview/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric OPENROWSET function (Preview)”</span></a>

Last week I was running a post-conference (postcon) workshop at Fabric February in Oslo. To have a successful postcon, workspaces were needed for all attendees of the workshop. In these workspaces …

Data workspace, the ERD data experience with Copilot is now generally available in 9 languages supporting solution and model-driven app.

This article describes the differences between the ALL and CROSSFILTERED functions in DAX. Have you ever wondered what the subtle difference between ALL and

Microsoft Power Apps announces preview of ability to customize in-app chat with Copilot Studio.

More Power Fx formula reuse! User defined functions can now call behavior functions with side effects and be chained. User defined types enable passing records and tables in and out of user defined functions and can type JSON and untyped objects. And enhanced component properties move to preview.

The plan designer is now available for preview for makers worldwide! The plan designer can help you transform a simple business requirement into a complete, end-to-end low-code solution in minutes!

When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse, a pipeline ...), you are also the owner of the item. There has been an outstanding issue in Microsoft Fabric, where if a user's account was deactivated, other users could no longer access the item. Whoopsies. When a c

Last year we announced a sneak peak of a migration assistant designed to accelerate the migration of SQL Server, Synapse dedicated SQL pools, and other warehouses to the Fabric Data Warehouse. This tool enables users to migrate the code and data from the source database, automatically converting the source schema and code to Fabric Data … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/private-preview-of-migration-assistant-for-fabric-datawarehouse/" class="more-link">Continue reading<span class="screen-reader-text"> “Private Preview of Migration assistant for Fabric Data Warehouse”</span></a>

We’ve got a lot of exciting updates this month. To name a few, NotebookUtils session management utilities, Enhancing COPY INTO operations with Granular Permissions in Data Warehouse, Application Lifecycle Management (ALM) and Fabric REST APIs. Keep reading to hear about everything we have in store for you this month. Microsoft Fabric Community Conference 2025 After … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/microsoft-fabric-january-2025-update/" class="more-link">Continue reading<span class="screen-reader-text"> “Microsoft Fabric January 2025 update”</span></a>

Use LLMs like gemini-1.5-flash-002 with Microsoft Fabric updates to convert unstructured data into structured JSON

You want to merge multiple files with transactional data. The files are saved with the month name, yet contain no date records in the file. Here's how.

We are thrilled to announce the launch of Fabric Copilot capacity, a new billing feature designed to enhance your experience with Microsoft Fabric. This new capability allows you to leverage the full potential of AI in your organization by simplifying the ability to enable access to Copilot within Fabric. What is a Fabric Copilot capacity? … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/17673/" class="more-link">Continue reading<span class="screen-reader-text"> “Introducing Fabric Copilot capacity: Democratizing AI usage in Microsoft Fabric”</span></a>

I compared which Microsoft Fabric workload uses the least amount of Capacity Units when loading data from On-Premises SQL Server to a Lakehouse.

Use the Smart Narrative visual to summarise text data

With the PBIR format of Power BI reports, it’s much easier to make report updates outside of Power BI Desktop. One thing you may want to do is to switch out an image in a report. Maybe you ne…

Update for R/Py visuals in PBI

Use Semantic Link labs to get the sizes of all columns touched by a DAX query

The October 2024 Power BI update introduces an inconspicuous yet significant preview feature: Value Filter Behavior. This feature is activated by setting a new model-level property, ValueFilterBeha…

Learn more on how to automate the migration of your Power BI capacities to Microsoft Fabric.

Welcome to the Power Apps monthly feature update! We will use this blog to share what's new in Power Apps. A summary of product, community, and learning updates from throughout the month so you can access it in one easy place. This month we're excited to shared a simplified approach to writing Power Fx with Copilot, Performance improvements to the Canvas designer, Studio visual updates, and smart paste for model driven apps!

Using a Microsoft Fabric Notebook to read from a Lakehouse A in Workspace A and write to Lakehouse B in Workspace B.

This blog post shows you how to use #MicrosoftFabric AI Skills, #MSFTCopilot and #MicrosoftTeams to answer questions on your data!

The Fabric notebook version history feature has launched! This new feature is designed to significantly improve your experience in developing and managing notebooks by providing robust built-in version control capabilities.  Highlights These enhancements are part of our ongoing efforts to improve collaboration, reproducibility, and the overall user experience within Fabric. We believe these updates will … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/notebook-live-versioning/" class="more-link">Continue reading<span class="screen-reader-text"> “Notebook Live Versioning”</span></a>

Have you ever wondered where a certain field is used in a report? Or maybe you need an easy way to find broken field references in a report? Certain 3rd-party tools such as Measure Killer and Power…

Once upon a time, there was a SQL Server, an undisputed emperor of operational databases! In this article, we examine the key characteristics of the SaaS operational database in Fabric - Fabric SQL Database

With the new pricing changes in Power BI Pro (+40%) and the need to move from Power BI Premium to Fabric capacities next year, it is a perfect timing to start strategizing how to gain higher return on investment (ROI) from your Power BI investments. As your organization explore opportunities and use-cases for AI, a […]