Introducing Microsoft Fabric and Copilot in Microsoft Power BI | Microsoft Power BI Blog (2023)

Introducing Microsoft Fabric and Copilot in Microsoft Power BI | Microsoft Power BI Blog (1)

Enterprises have been collecting and storing vast amounts of data from applications, services, Internet of Things (IoT) sensors, and other sources for decades. Every year, the amount of data collected grows at an alarming rate.

But deriving value from this data has proven challenging for most. Orphaned data is out of sync. Inconsistent data can lead to high integration costs. Poor data quality can destroy new AI models. Outdated reporting can lead to misinterpretation of insights. All of this stifles the ability to unlock the full value of data, hindering innovation and AI experiences.

Today, we are pleased to unveil theMicrosoft Fabricand Copilot in Microsoft Power BI. Fabric, now in preview, is an end-to-end, people-centric analytics product that brings together all of an organization's data and analytics in one place. It brings together the best of Microsoft Power BI, Azure Synapse, and Azure Data Factory into a unified Software-as-a-Service (SaaS) platform. Data engineers, data warehouse professionals, data scientists, data analysts, and business users can seamlessly collaborate within Fabric to foster a well-functioning data culture across the organization.

Introducing Microsoft Fabric and Copilot in Microsoft Power BI | Microsoft Power BI Blog (2)

Copilot in Power BI, now in private preview, combines advanced generative AI with your data to help everyone discover and share insights faster. Simply describe the insight you need or ask a question about your data, and Copilot will analyze and extract the right data into a stunning report - instantly turning data into actionable insights.

What's included in Microsoft Fabric?

See Arun Ulagaratchagan's blog post to read the full storyMicrosoft Fabric Preview Announcement.

Fabric offers six experiences: Data Integration Experience Powered by Data Factory, Data Engineering Powered by Synapse, Data Warehousing, Data Science and Real-Time Analytics Experience, and Business Intelligence (BI) Using Power BI—all hosted on a lake-centric solutions on SaaS. We're also developing an experience called Data Activator to help customers respond immediately to data changes by building a detection system that automatically alerts teams to take action in the right context.

(Video) Copilot in Power BI Overview

Learn more about these new experiences by reading the following announcement blogs:

  • Data Factory Announcement Blog— With Data Factory in Fabric, organizations can unify their hybrid and multicloud data assets and unlock value through a data integration experience that combines the ease of use of Microsoft Power Query with the scale and capabilities of Data Factory. Currently in preview.
  • Synapse Data Engineering Announcement Blog— Next-generation Synapse data engineering in Fabric provides data engineers with a world-class Spark platform and a great authoring experience to help transform data at scale and democratize it with Lakehouse, while collaborating effectively. Currently in preview.
  • Synapse Data Warehouse Announcements Blog—Synapse Data Warehouse delivers industry-leading SQL performance and scale. For the first time, data engineering, data warehouse professionals, and BI analysts can operate on a unified open format, providing a single copy of the truth for all roles. Currently in preview.
  • Synapse Data Science Announcement Blog— Data scientists can work side by side with their data engineering and BI counterparts to build rich AI models at speed and scale. Currently in preview.
  • Synapse Real-Time Analytics Announcement Blog— Organizations can use Synapse Real-Time Analytics to explore data and perform high-performance and low-latency real-time analytics on massive data streams from applications, websites, IoT devices, and more. Currently in preview.
  • Data Activator Announcement Blog—Data Activator in Fabric enables users to create a detection system to monitor analytics to drive human and automated actions across the organization in a timely manner. Currently in private preview.
  • OneLake Announcements Blog—OneLake is "OneDrive for data." It is a complete, rich, enterprise-grade data lake delivered as a SaaS service. OneLake is at the heart of Fabric's lake-centric approach. Currently in preview.

Introducing Microsoft Fabric and Copilot in Microsoft Power BI | Microsoft Power BI Blog (3)

What does Microsoft Fabric mean for Power BI users?

Power BI customers will continue to enjoy all the functionality available to them today. With the launch of Fabric, Power BI Premium customers can simply turn on the Fabric tenant settings in the admin portal. With Fabric's unified capacity model, any new workload can use Power BI Premium capacity. read thisdocumentMore information on Fabric's single capacity model. Power BI Pro customers can access this functionality through a capacity trial.

In addition to providing access to six other powerful experiences in Fabric, we are announcing somePower BI PremiumOnly features designed to change the way you analyze and visualize data.

Next-Gen AI with Copilot in Power BI

Introducing Copilot in Power BI! With Copilot in Power BI, we're infusing the power of large-scale language models into every layer of Power BI to help users do more and create more value from their data. With Copilot, you simply describe the visuals and insights you're looking for, and Copilot does the rest. Users can create and customize reports in seconds, generate and edit DAX calculations, create narrative summaries, and ask questions about their data, all in conversational language. With the ability to easily customize the tone, scope, and style of narratives and seamlessly add them to reports, Power BI can also deliver more impactful data insights through easy-to-understand text summaries.

we have publishedQuick Measurement Recommendations for DAXAbility to help analysts quickly create the required code. The rest of the Copilot experience in Power BI is now available in private preview. Stay tuned to the Power BI blog for the latest updates and public release dates for Copilot in Power BI.

Unified data foundation using OneLake and Direct Lake modes

Power BI standardizes on open data formats by adopting Delta Lake and Parquet as its native storage formats to help you avoid vendor lock-in and reduce data duplication and management. Direct Lake mode unlocks incredible performance directly to OneLake with no data movement required. Combined with the ability of other analytics engines to read and write data directly in the lake, Fabric will reshape the way business users consume big data. Power BI datasets in Direct Lake mode enjoy query performance comparable to import mode, with the real-time performance of DirectQuery. And the data never leaves the lake, so there's no need to manage refreshes.

We're excited to announce the Direct Lake mode preview for Power BI datasets on Lakehouses. We plan to launch a preview of the Direct Lake mode dataset on Data Warehouse soon. Warehouse's Direct Lake mode dataset is currently in private preview, but it will work if you use Lakehouse's SQL endpoint.

(Video) Copilot in Power BI Demo

To try Direct Lake from Lakehouse or Warehouse in Fabric, clickNew Power BI datasets, select the tables to include, and clickconfirm.Open the data model to create measures and relationships as you would for any other Power BI dataset. Finally, clicknew reportAnd create beautiful Power BI reports. Notice the integrated experience from data in the lake to report creation without leaving the browser or performing a refresh.

Introducing Microsoft Fabric and Copilot in Microsoft Power BI | Microsoft Power BI Blog (4)

Enterprise-grade collaboration with Git integration for Power BI datasets and reports

We also enable more seamless collaboration with your development team on Power BI contentGit integration.You can now easily connect your workspace to an Azure DevOps repository to track changes, revert to previous versions, and merge updates from multiple team members into a single source of truth with just one click will be synced to the workspace.

Introducing Microsoft Fabric and Copilot in Microsoft Power BI | Microsoft Power BI Blog (5)

As a developer, you can use this integration to:

  • usePower BI DesktopWrite reports and dataset metadata files in a source control-friendly format.
  • Save to a folder as a Power BI project (.PBIP) instead of a .PBIX file.
  • Enables multiple developer collaboration, source control integration to track version history, compare different revisions (diff) and revert to previous versions.
  • Use continuous integration and continuous delivery (CI/CD) to enforce a quality gate before reaching production.
  • Enable code reviews, automated testing, and automated builds to verify the integrity of deployments.

With Git integration to develop and deploy Power BI content across development, test, and production workspaces, users can leverage Git integration and deployment pipelines for end-to-end application lifecycle management of their work. Developers can automate this process using the user interface (UI) experience or through other tools such as Azure Pipelines.

End-to-end governance across the fabric

Building analytics solutions is complex. Data teams must manage everything from user roles to data ingestion, security, compliance, collaboration, workspaces, and more. With Fabric, Power BI, Synapse, and Data Factory are unified on a unified SaaS platform. This allows data teams to collaborate on the same copy of data in a single workspace and use centralized management, governance and compliance tools. These capabilities include data lineage and impact analysis, data protection with sensitive labels, data endorsement, administrator monitoring, and more. These unified experiences let you easily switch between tools and collaborate with others on your team. Additionally, as large numbers of data and analytics projects are built within organizations, efficient discovery and management becomes key. OneLake Data Center enables everyone in an organization to centrally discover and explore the data available to them and relevant to their business areas, take further action, or build on what others have already begun.

accessthis blog postLearn more about Fabric management and governance.

(Video) Microsoft Fabric Launch Digital Event (Day 1)

General-purpose computing power simplifies procurement and management of analytical projects

Fabric greatly simplifies the procurement and management of resources. Customers can purchase a single compute pool that powers all Fabric experiences. With this all-encompassing approach, customers can create solutions that can freely leverage all workloads without compromising their experience or business. General-purpose computing power significantly reduces costs because any unused computing power in one workload can be utilized by any workload. For Power BI Premium customers, existing Power BI Premium P SKUs will automatically support all new Fabric experiences. Starting June 1st, new Fabric SKUs will be available for purchase in the Azure portal, giving you access to all of these experiences.

How to get started with Microsoft Fabric?

Enable Fabric in your Power BI tenant

Power BI customers can now access Fabric by opening the Fabric tenant settings in the Power BI admin portal. To give Power BI admins time to prepare, we've turned the switch off by default. You can opt in or out of Fabric through the admin portal. You can also choose to enable Fabric for specific users or security groups within your tenant.Fabric will be enabled by default for all Power BI tenants starting July 1st if admins take no action.

Introducing Microsoft Fabric and Copilot in Microsoft Power BI | Microsoft Power BI Blog (6)

Introducing Microsoft Fabric and Copilot in Microsoft Power BI | Microsoft Power BI Blog (7)

Additionally, if you want to try out Fabric in one or more capacities before enabling it for your entire tenant, you can enable it for a specific capacity in the Capacity Settings tab of the Admin Portal. Like tenant settings, this capacity setting can also be restricted to specific users or security groups.

Introducing Microsoft Fabric and Copilot in Microsoft Power BI | Microsoft Power BI Blog (8)

Upgrade existing Power BI Premium capacity

If your administrator has enabled Fabric at the tenant level, all Premium capacity will be automatically upgraded to support Fabric. Additionally, capacity administrators can enable Fabric at the capacity level (as described in the previous section), allowing anyone with access to this capacity to use the new Fabric experience. To help you prepare and understand how this will impact your use of Power BI Premium, the new Fabric experience will not reduce your capacity usage until August 1, 2023. However, you can monitor how Fabric affects your capacity usage through the Capacity Metrics app.

Introducing Microsoft Fabric and Copilot in Microsoft Power BI | Microsoft Power BI Blog (9)

(Video) What does Microsoft Fabric mean for Guy in a Cube?

Universal Fabric capacity free trial for 60 days

If you don't already have Power BI Premium, you can get a free trial of Fabric (learn more aboutFabric try-on).If your tenant administrator has enabled trials, when you (1) create a project that requires capacity or (2) clickstart trialFrom your account manager in the upper right corner of the portal.

Introducing Microsoft Fabric and Copilot in Microsoft Power BI | Microsoft Power BI Blog (10)

This capacity can be used for one or more workspaces, allowing you to create data warehouses, lake houses, notebooks and more. After 60 days, you canAzure Portal(Available after June 1).

As a tenant administrator, you will see all active trial capacity configured for users within your tenant in the Power BI admin portal.

Fabric Learning Resources

To help you get started with Fabric, we recommend several resources:

  • Microsoft Fabric Learning Path: Take a high-level tour of Fabric and how to get started.
  • Microsoft Fabric Tutorial: Get a detailed tutorial with step-by-step guidance on how to create an end-to-end solution in Fabric. These tutorials focus on several different common patterns, including Lakehouse architecture, data warehouse architecture, real-time analytics, and data science projects.
  • Microsoft Architecture Documentation: Read the Fabric documentation to view detailed documentation on various aspects of Fabric.

join the conversation

Want to learn more about Fabric from the people who created it? Join us on May 24 at 9AM PT for two days of live events to see Fabric in action. These sessions will be available on demand after May 25. Join a live event or view the full conference listblog post.

join usMicrosoft Fabric CommunityPost your questions, share your feedback, and learn from others.

Learn more about otherMicrosoft Power Platform Announcements at Microsoft Build 2023.

(Video) Announcing Windows Copilot


Is coding required for Power BI? ›

Power BI is a set of tools that allows non-technical folks to perform the kinds of analytics previously reserved for technical specialists or IT departments. Power BI changes that. Any analyst can connect to any data source and quickly summarize findings into a simple report, no programming required.

What is the difference between my workspace and app workspace in Power BI? ›

an App is used for sharing content. a Workspace is used mainly for collaborating on content.

What are the three Power BI elements designed to let people create consume and share business insights the way that serves them best? ›

These three elements – the Desktop, the service and Mobile – are designed to let people create, share and consume business insights in the way that serves them, or their role, most effectively.

What tool can you use in Power BI desktop to reduce data? ›

When we choose Import mode for our Power BI tables, VertiPaq performs the following actions: Reads the data source, transforms data into a columnar structure, encodes and compresses data within each of the columns.

Is it hard to learn DAX? ›

Almost anyone can learn DAX with enough time and effort. The secret to mastering DAX is learning the theory first. The formula is simple, but the process is slow. Begin by studying how DAX views the underlying data models.

What is the difference between a dashboard and an app? ›

Put briefly, Dashboards are OK for small implementations, but Apps are more scalable, secure and manageable for larger solutions.

How many days it will take to learn DAX? ›

Becoming proficient with essential DAX functions is estimated to take approximately two weeks. Understanding how to make dashboards and reports takes most people three days. Publishing data findings is a skill most people learn in one day.

What are the 2 types of DAX? ›

There are two primary data types in Power BI DAX functions:
  • Numeric: numeric data types include decimals, currency values, integers, etc.
  • Non-numeric: it consists of strings, binary objects, etc.

Should I learn DAX or M? ›

DAX is easier for non-programmers to learn and use, while M is more suited to complex data transformations and requires more programming skills.

What is the difference between KPI and dashboard? ›

Key Performance indicators (KPIs) are individual metrics that can be displayed on a dashboard to track key measurements. You can think of them as a single important number that is displayed in large text. Dashboards are a collection of Insights and KPIs put together on a page.

Is a dashboard the same as a website? ›

The structural difference is minor: Homepages have a menu drop down in the header that enables users to move to other Homepages. In addition, Homepages can be swiped to move to other Homepages on touch devices like tablets and smart phones. Dashboards lack these features.

What is best to use on dashboard? ›

Typically, the best cleaner for a car dashboard is a simple oil soap and water solution. You can use Castile soap, which is an amazing oil soap with many uses. This type of soap is tough enough to provide a thorough cleaning but gentle enough for materials like leather.

What is difference between app workspace and my workspace? ›

It is where you will always be the sole owner of the content. You can share things from it, but it shouldn't be used for company wide sharing. The App Workspace are tied to O365 Universal Groups, and are collaborative workspaces where you can have multiple people own and manage reports.

What is difference between workspace and Myworkspace? ›

Only you have access to your My workspace. You can share dashboards and reports from your My workspace. If you want to collaborate on dashboards and reports, or create an app, then you want to work in a workspace. Workspaces are used to collaborate and share content with colleagues.

What is my workspace app? ›

My Workspace is a Mac desktop app that helps busy people stay organized with upcoming calendar events and important files at their fingertips. This Mac menu bar can: Show your upcoming calendar events at a glance. Open recent and shared files.

Why do I need workspace app? ›

Users can securely access all Workspace applications, services and data through the Workspace app on any device or network through a single pane of glass. Files and mobile and virtual apps are also available through the interface. Files are stored dynamically and updated across all devices that can access them.

What is the difference between dashboard and workspace? ›

Your dashboard is completely private and personalised to you. Each workspace has its own Overview page. Once you have selected a workspace, you will be directed to your workspace overview. The workspace overview shows all the activity for everyone in that workspace.

What are roles available in workspace? ›

Workspaces allow you to assign roles to individuals, and also to user groups such as security groups, Microsoft 365 groups, and distribution lists. To grant access to a workspace, assign one of the following workspace roles to a user group or individuals: Admin, Member, Contributor, or Viewer.

What is the difference between Google apps and Google Workspace? ›

With a free Gmail account, you get access to basic apps and services, including Google Drive, Docs, Sheets and Slides. With Google Workspace, you get access to all of the same apps as Gmail, as well as Google Meet, Calendar, Chat, Keep Sites, Forms and Current.

Is Google Workspace the same as Google apps? ›

One such app is Google Workspace — previously known as Google Apps for Work and G Suite. Google's G Suite was a collection of productivity and collaboration tools used by more than six million businesses across the globe.

Who uses Google Workspace? ›

Our Customers
  • Salesforce: Driving business and positive change through collaboration. ...
  • Colgate-Palmolive: Empowering global collaboration with Google Workspace to better serve millions of families worldwide. ...
  • Nielsen: Collaborating across 100 countries for better consumer insights.

What is the difference between Google free and Workspace? ›

How does Drive in Google Workspace differ from free Drive? Google Workspace 's Drive provides twice the amount of storage, 24/7 phone and email support, sharing controls, and advanced reporting. You can upgrade to unlimited storage (accounts with fewer than 5 users get 1TB/user) for an additional fee.

Who needs Google Workspace? ›

Google Workspace Individual offers features to help small business owners be more productive. Designed for one-person businesses and "solopreneurs” using a personal account domain, such as,, or


1. Microsoft Fabric Launch Digital Event (Day 2)
(Microsoft Power BI)
2. Can cross-cloud data analytics be easy? | Microsoft Fabric
(Microsoft Mechanics)
3. Copilot AI updates across the Power Platform | Automate, apps, pages & virtual agents
(Microsoft Mechanics)
4. How Microsoft 365 Copilot works
(Microsoft Mechanics)
5. Microsoft 365 Copilot: Your Questions Answered
(Lisa Crosbie)
6. How to build your first app using Power Apps | Automatically with Copilot or from scratch
(Microsoft Mechanics)
Top Articles
Latest Posts
Article information

Author: Prof. Nancy Dach

Last Updated: 04/14/2023

Views: 6303

Rating: 4.7 / 5 (57 voted)

Reviews: 88% of readers found this page helpful

Author information

Name: Prof. Nancy Dach

Birthday: 1993-08-23

Address: 569 Waelchi Ports, South Blainebury, LA 11589

Phone: +9958996486049

Job: Sales Manager

Hobby: Web surfing, Scuba diving, Mountaineering, Writing, Sailing, Dance, Blacksmithing

Introduction: My name is Prof. Nancy Dach, I am a lively, joyous, courageous, lovely, tender, charming, open person who loves writing and wants to share my knowledge and understanding with you.