Fabric

Local AI Skills with Fabric's endpoint and Gradio to create interactive plots. Steps detailed for building your own AI Skillet app

If you’re utilizing Microsoft Fabric and notice consistently high usage—perhaps averaging 90%—or experience occasional throttling, it’s a clear indication that you’re nearing your capacity limit. T…

Refreshing with a Data Pipeline offers more flexibility with scheduling

For no particular reason, I recently opened a Power BI report with two fact tables, exported the model definition to TMDL, saved it as a file, and loaded it into several state-of-the-art LLMs, incl…

Use an expression to define which tables and partitions to refresh

We’re excited to announce the preview of the Fabric CI/CD Python library! Recognizing the importance of CI/CD in our success, we decided to open source our project to share with the community. As part of the Azure Data Insights & Analytics team, an internal data engineering group focused on supporting product analytics for Azure Data, we’ve been using Fabric as the backbone of our platform for the last two years. Our team is committed to maintaining and evolving this library, and we look forward to collaborating with the community to enhance its capabilities!

In today’s data-driven world, it’s important to be able to read & understand your data to enable you to gain insights on which patterns/trends you want to monitor. After a data driven decision is taken, you can understand which visualizations you want to build and which machine learning models you want to train to give … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/streamline-data-engineering-data-science-with-copilot-in-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Streamline Data Engineering & Data Science with Copilot in Fabric”</span></a>

SQL database in Fabric is currently in preview, and we are actively rolling out improvements as we progress towards general availability (GA). Your insights play a crucial role in this journey. Whether it’s challenges you’ve encountered, features you adore, or any suggestions for enhancement, we want to hear it all—the good, the bad, and the … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/enhancing-sql-database-in-fabric-share-your-feedback-and-shape-the-future/" class="more-link">Continue reading<span class="screen-reader-text"> “Enhancing SQL database in Fabric: share your feedback and shape the future”</span></a>

We are pleased to announce the release of several new Admin APIs, which offer tenant administrators advanced tools for managing tenant settings, as well as tenant setting overrides at the capacity, workspace, and domain levels.   These new APIs, along with enhancements to existing APIs, represent our continued commitment to expanding Microsoft Fabric’s administrative capabilities, thereby … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/admin-api-updates-and-upcoming-definition-changes/" class="more-link">Continue reading<span class="screen-reader-text"> “Admin API updates and upcoming definition changes “</span></a>

OneLake catalog is the central hub for discovering and managing Fabric content. Whether you’re a business analyst searching for the right datasets, a data engineer managing structured and unstructured data, or a BI consumer looking for curated insights, the OneLake catalog seamlessly connects you to the right content. Enhanced exploration in OneLake Catalog OneLake catalog continues to evolve to deliver richer, … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/whats-new-in-onelake-catalog-data-governance-and-more/" class="more-link">Continue reading<span class="screen-reader-text"> “What’s new in OneLake catalog: Data governance and more”</span></a>

Partners, come join the Microsoft Fabric Catalyst program. A collaborative knowledge hub aimed at scaling technical expertise and providing partners with the right resources to drive high-impact solutions in Fabric.

In this blog post, we will cover how to build a Python application using Flask framework to connect to Fabric SQL Database and query data.

In Fabric, you can have many different items in your Workspace. So many, that you easily get lost! Luckily there are tools at hand like Taskflows and Workspace folders. But still, it can be challen…

We are excited to announce the preview of the BULK INSERT statement in Fabric Data Warehouse, which allows you to load CSV files from Azure Data Lake Storage and Azure Blob Storage. Refer to the example of the traditional BULK INSERT statement commonly used by SQL Server or Azure SQL users to import files from … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/bulk-insert-statement-in-fabric-datawarehouse/" class="more-link">Continue reading<span class="screen-reader-text"> “BULK INSERT in Fabric Data Warehouse (Preview)”</span></a>

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 …

We’re excited to tell you more about org apps, now in public preview. Fabric org apps are Power BI workspace apps rebuilt for Fabric as a new item type. With org apps as items, you can create multiple org apps per workspace. And you work with org apps the way you would any other item type – from creating a new org app, saving changes, managing access, to sharing the org app – all the things you find familiar and easy about managing other items, such as reports, will be familiar with org apps as items.

Microsoft Ignite 2024 is currently taking place in Chicago from November 19th to 21st. As always, the Data and AI community is eagerly anticipating the latest announcements from Microsoft. With FabCon Europe having taken place less than two months ago, there was some scepticism about Microsoft’s ability to unveil any major new Fabric features. However, they still had a couple of aces up their sleeve, ready to be revealed at just the right moment.

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

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 Semantic Link labs to get the sizes of all columns touched by a DAX query

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

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!