Power BI

This article is about the state of AI tools with Power BI, and how to use the model context protocol (or MCP) to interact with and control Power BI or Fabri

This post introduces two new scripts. One will copy one or more visuals from a template report to a page in target report. The other will prepare your report for bilingual format.

Data engineering often presents challenges with data quality or complex data analytics processing that requires custom logic. This is where Fabric User data functions can be used to implement custom logic into your data processes or pipelines. Here are the most common cases where Fabric User Data Functions

SQL native Scalar user-defined functions (UDFs) in Microsoft Fabric Warehouse and SQL analytics endpoint are now in preview. A scalar UDF is a custom code implemented in T-SQL that accepts parameters, performs an action such as complex calculation, and returns a result of that action as a single value. They can contain local variables, calls … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/inline-scalar-user-defined-functions-udfs-in-microsoft-fabric-warehouse-preview/" class="more-link">Continue reading<span class="screen-reader-text"> “Inline Scalar user-defined functions (UDFs) in Microsoft Fabric Warehouse (Preview)”</span></a>

Check out the latest for Power Apps for AI Power Development, Governance and end user productivity.

Microsoft Power Apps brings generative pages to public preview, providing enterprises with a new AI-powered, agent-first approach to app development.

We’re thrilled to share a series of exciting updates and upcoming enhancements to the SQL analytics endpoint in Microsoft Fabric. These improvements are designed to make your experience more powerful and reliable. From Preview to GA – Metadata sync REST API Last month, we introduced the SQL analytics endpoint metadata sync REST API in preview, … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/whats-new-and-coming-soon-in-sql-analytics-endpoint-in-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “What’s new and coming soon in SQL analytics endpoint in Fabric”</span></a>

Overview Microsoft Fabric is officially sunsetting Default Semantic Models. This change is part of our ongoing efforts to simplify and improve the manageability, deployment, and governance of Fabric items such as warehouse, lakehouse, SQL database, and mirrored databases. Why the Change? Default Semantic Models were initially designed to provide a lightweight, out-of-the-box experience—automatically generating models … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/sunsetting-default-semantic-models-microsoft-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Sunsetting Default Semantic Models – Microsoft Fabric”</span></a>

Additional authors: Joanne Wong The preview of the integration between Fabric data agents and Microsoft Copilot Studio is now available, introducing a robust capability that enables agents to interoperate seamlessly across tools. This enhancement is designed to streamline the development, deployment, and scaling of intelligent agents across enterprise data environments, reinforcing automation and extensibility within … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-data-agents-microsoft-copilot-studio-a-new-era-of-multi-agent-orchestration/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric Data Agents + Microsoft Copilot Studio: A New Era of Multi-Agent Orchestration (Preview)”</span></a>

Learn how translytical task flows enable data write-back capabilities in Power BI reports with user data functions in Fabric.

We are excited to announce Materialized Lake views (MLV) in Microsoft Fabric. Coming soon in preview, MLV is a new feature that allows you to build declarative data pipelines using SQL, complete with built-in data quality rules and automatic monitoring of data transformations. In essence, an MLV is a persisted, continuously updated view of your … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-materialized-lake-views-at-build-2025/" class="more-link">Continue reading<span class="screen-reader-text"> “Simplifying Medallion Implementation with Materialized Lake Views in Fabric”</span></a>

In this article, we tackle the growing issue of ‘report-specific objects’, dataset measures and tables created to fill specific report visual requirements, why they negatively impact self-service users, and best practices to mitigate this impact.

Now available in preview, Copilot Inline Code Completion is an AI-powered feature that helps data scientists and engineers write high-quality Python code faster and with greater ease. Inspired by GitHub Copilot, this feature offers intelligent code suggestions as you type, with no commands needed. By understanding the context of your notebook, Copilot Inline Code Completion … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/improving-productivity-in-fabric-notebooks-with-inline-code-completion/" class="more-link">Continue reading<span class="screen-reader-text"> “Improving productivity in Fabric Notebooks with Inline Code Completion (Preview)”</span></a>

Copy job has been a go-to tool for simplified data ingestion in Microsoft Fabric, offering a seamless data movement experience from any source to any destination. Whether you need batch or incremental copying, it provides the flexibility to meet diverse data needs while maintaining a simple and intuitive workflow. We continuously refine Copy job based … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/simplifying-data-ingestion-with-copy-job-incremental-copy-ga-lakehouse-upserts-and-new-connectors/" class="more-link">Continue reading<span class="screen-reader-text"> “Simplifying Data Ingestion with Copy job – Incremental Copy GA, Lakehouse Upserts, and New Connectors”</span></a>

Shortcut transformations is a new capability in Microsoft Fabric that simplifies the process of converting raw files, starting with .CSV files, into Delta tables. This feature eliminates the need for traditional ETL pipelines, enabling users to transform data directly on top of files with minimal setup. Why use Shortcut transformations Shortcut transformations help users: What … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/announcing-shortcut-transformations-from-files-to-delta-tables-always-in-sync-no-pipelines-required/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing Shortcut Transformations: from files to Delta tables. Always in sync, no pipelines required.”</span></a>

The June 2025 release of the on-premises data gateway is (version 3000.274). What’s New Fabric pipeline – Azure database for PostgreSQL connector version 2.0 is now generally available. This new version is enhanced to support TLS 1.3, new table action – upsert, as well as the script activity in data pipeline.  Fabric pipeline – Enhanced … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/on-premises-data-gateway-june-2025-release/" class="more-link">Continue reading<span class="screen-reader-text"> “On-premises data gateway June 2025 release”</span></a>

The Microsoft Fabric Extension for VS Code introduces two new features that enhance the management of Fabric items directly within the editor. Users can now perform CRUD operations on Fabric items and switch between multiple tenants easily. These updates aim to improve workflow efficiency and are based on customer feedback, inviting further suggestions for enhancement.

Welcome to the June 2025 update. The June 2025 Fabric update introduces several key enhancements across multiple areas. Power BI celebrates its 10th anniversary with a range of community events, contests, expert-led sessions, and special certification exam discounts. In Data Engineering, Fabric Notebooks now support integration with variable libraries in preview, empowering users to manage … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/fabric-june-2025-feature-summary/" class="more-link">Continue reading<span class="screen-reader-text"> “Fabric June 2025 Feature Summary”</span></a>

We’re excited to introduce Data Source Instructions, a powerful new feature in the Fabric Data Agent that helps you get more precise, relevant answers from your structured data. What are Data Source instructions? When you use the Data Agent to ask questions in natural language, the agent must determine which data source to use and … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/new-in-fabric-data-agent-data-source-instructions-for-smarter-more-accurate-ai-responses/" class="more-link">Continue reading<span class="screen-reader-text"> “New in Fabric Data Agent: Data source instructions for smarter, more accurate AI responses”</span></a>

This blog draft gives an overview of updates to access and learn from report data via Copilot.

We’ve introduced more intuitive entry points, expanded access so more business users can explore their data, and added new functionality to make Explore even more powerful!

Power BI is turning 10, and we’re celebrating a decade of turning data into insight and impact. From 500,000 early adopters to over 375,000 organizations today—including 95% of the Fortune 500—Power BI has become a global force in business intelligence. We want to give a major thanks to our vibrant community of users, partners, and advocates and celebrate this achievement.

For the eighteenth consecutive year, Microsoft has been positioned as a Leader in the 2025 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms.* We’re thrilled that Microsoft has again been positioned furthest on Completeness of Vision and highest in the Ability to Execute in the Magic Quadrant, marking our seventh consecutive year in this position.

Have you ever found yourself frustrated by inconsistent item creation? Maybe you’ve struggled to select the right workspace or folder when creating a new item or ended up with a cluttered workspace due to accidental item creation. We hear you—and we’re excited to introduce the new item creation experience in Fabric! This update is designed … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/introducing-new-item-creation-experience-in-fabric/" class="more-link">Continue reading<span class="screen-reader-text"> “Introducing new item creation experience in Fabric”</span></a>

Co-author: Alexei Robsky, Data Scientist Manager Overview  As organizations increasingly rely on real-time data to drive decisions, the need for intelligent, responsive systems has never been greater. At the heart of this transformation is Fabric Real-Time Intelligence (RTI), a platform that empowers users to act on data as it arrives. Today, we’re excited to announce … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/introducing-mcp-support-for-real-time-intelligence-rti/" class="more-link">Continue reading<span class="screen-reader-text"> “Introducing MCP Support for Real-Time Intelligence (RTI) “</span></a>

IntroductionThe ChallengeThe SolutionExampleConclusion Introduction In an internal Microsoft Fabric support channel, someone asked, “My customer has multiple workspaces, each containing sever…

Introduction Integrating Azure API Management (APIM) with Microsoft Fabric’s API for GraphQL can significantly enhance your API’s capabilities by providing robust scalability and security features such as identity management, rate limiting, and caching. This post will guide you through the process of setting up and configuring these features. You may not be familiar with API … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/integrating-azure-api-management-with-fabric-api-for-graphql/" class="more-link">Continue reading<span class="screen-reader-text"> “Integrating Azure API Management with Fabric API for GraphQL”</span></a>

This article presents two new Tabular Editor C# scripts for PBIR reports, one to replace a field in visuals and one to open visual.json files

The introduction of file-based destinations for Dataflows Gen2 marks a significant step forward in enhancing collaboration, historical tracking, and sharing data for business users. This development begins with SharePoint file destinations in CSV format, offering a streamlined way to share with users on the SharePoint platform. Overview of file-based destinations File-based destinations allow data to … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/sharepoint-files-destination-the-first-file-based-destination-for-dataflows-gen2/" class="more-link">Continue reading<span class="screen-reader-text"> “SharePoint files destination the first file-based destination for Dataflows Gen2”</span></a>

We’re excited to announce the General Availability of Dataflow Gen2 CI/CD & Git integration support! With this set of features, you can now seamlessly integrate your Dataflow Gen2 items with your existing CI/CD pipelines and version control of your workspace in Fabric. This integration allows for better collaboration, versioning, and automation of your deployment process … <p class="link-more"><a href="https://blog.fabric.microsoft.com/en-us/blog/dataflow-gen2-ci-cd-git-integration-and-public-apis/" class="more-link">Continue reading<span class="screen-reader-text"> “Dataflow Gen2 CI/CD, GIT integration and Public APIs (Generally Available)”</span></a>