how do i enable assignments in microsoft teams

How to Use Assignments in Microsoft Teams: Quick 12-Minute Tutorial for Teachers

Sara Wanasek

Using Microsoft Teams in the classroom gained popularity during the pandemic. However, it can, and is, being used in both online and physical classrooms today. As a learning management tool, Teams works seamlessly with other Microsoft products like Word, Excel, and PowerPoint which are classic favorites for students and teachers alike.

This multi-functional tool allows you to stay in touch with your students not only through video calls, but with chats, files, and assignments in Microsoft Teams. Teams can seem daunting when you first begin to use it, but it really is quite simple and easy to use. To make it seem less intimidating, we have broken down and explained some main features of Teams separately. Here are links to our other guides on features of Microsoft Teams:

• Microsoft Teams for Online Teaching – A Guide for Teachers
• Using Breakout Rooms in Microsoft Teams  
• Assignments in Teams
• Class Notebook in Microsoft Teams
• 15 of the Best Teams Tips and Tricks .

Below is a quick, everything-you-need-to-know guide on assignments in Microsoft Teams. Let’s get started!

Create an Assignment in Microsoft Teams

To begin creating assignments in Microsoft Teams, you first need to be sure of two things:

• You are logged in with a Microsoft EDU account
• The Team you have created is a Class Team type

If both of those things are complete you will be able to see the Assignments tab on the side ribbon and on the top ribbon in the General channel. If you need help getting to know the interface and basics of Teams, check out our Teams Guide for Teachers.

Start a New Assignment

Now, to create your assignment, click on the Assignments tab from the top ribbon under your General Channel. Click Create , and then Assignment , to begin your first assignment. You can explore creating a quiz with the help of Microsoft Forms and creating an assignment based on a pre-existing assignment another time.

Add Assignment Details

In your new assignment, add a title and a description to let your students know what to do to complete the assignment.

If you prefer to attach the instructions as a document, or have supporting materials to the assignment, you can attach them under the Add Resources link. Teams allows you to attach files in many different ways: through your OneDrive, ClassNoteBook, from a link, by creating a new file, or from uploading a document from your computer.

When you attach a resource, you have the option to allow students to edit it or not. By default, they cannot edit; however, if you prefer to change this, just click on the three dots at the end of the resource and click, Students edit their own copy. Now, when students edit this file, a new copy will be made for them, and it is automatically attached to this assignment for an easy turn-in.

Set Points and a Rubric

To easily grade this assignment in Teams, assign the number of points it is worth, or add a rubric . Similar to creating assignments, you can use a pre-existing rubric, upload one, or create a new one.

Creating a new rubric is very customizable so you are able to add all the information your students need to complete the assignment. Just add a title , and a description , then fill in the rest of the rubric. If you need more categories , just click the plus button at the end of the columns, or after the bottom row. In addition, you can assign points to each category of the rubric.

Choose Students to Assign the Work to

The next step in creating an assignment is to assign it to your students. You can assign it to all of them, or a certain student(s) for more individualized work. Just click Assign to All, or go through the list and click the students you would like to assign this to.

Give a Due Date & Close Date

In Teams, there are two different categories of dates for when the assignment is due.

Due Date: This is when the assignment is due, however, students are still able to turn in the assignment late, after the due date has passed.

Close Date: This is when the assignment closes and no more submissions are allowed.

To set both of these, and schedule this assignment for the future, click Edit under the Due Date section. To set a Close Date , click the checkbox on the side and set the date.

When all of your setups are complete, back at the top of the page, click assign, or save for later if it still needs a bit more work.

How Students Can Turn in Assignments

After you assign an assignment, students will receive a notification. They are able to view the assignment in the General Channel or on the Assignment tabs.

The student’s view of the assignment is very similar to the teacher’s view. They will see the Due Date and Close Date, the instructions, any files you have attached, and a rubric if there is one.

Students can begin their assignments right away in Teams if you have attached a document for them to work on. In the example below, students would be using PowerPoint on their desktops simultaneously with ClassPoint to make their presentations more interactive. As they work, their changes will be saved automatically. If you don’t have a document attached, students can upload and attach their work instead.

When they have completed their work, they just need to click Turn In. They will see a fun animation appear indicating the turn-in is successful.

How to Grade Assignments

Once students have turned in their work, you will receive a notification. Now, you can easily look over and grade their work. Click into an assignment to view how many students have turned in their work, how many need grading, and how many you have already graded.

To grade an assignment, click on the Turned in status. Here, you are able to view their work alongside a tab for you to give them feedback. If you have a rubric , it will open for you to assign the points for each category. Scrolling down, you can leave feedback to let them know what they excelled at and what needs more work.

When the grading is completed, you can return it to the student. They can view your feedback, make changes, and turn it in again if necessary.

To easily jump between students for a continuous grading experience, click the arrows on the side of the student’s name, or click on the student’s name for a drop-down menu of your other students.

Export Grade Data

In Teams, it is really easy to export data, especially for assignments. You can export data for certain assignments, in addition to exporting all assignments and student grade data. This can be done from the Grades pivot on the top toolbar. You will see a complete list of your students, and of each assignment on this tab that you have assigned throughout the year.

Frequently Asked Questions

And that completes this tutorial on Assignments in Microsoft Teams! There is plenty you can do with this feature on Teams to make it suitable for your students and classroom. Enjoy using it to its fullest potential.

We have put together some frequently asked questions in case you still have some lingering questions before you get started!

What if I don’t see the Assignments tab?

If you don’t see the Assignment tab on the top ribbon in your General channel, or on the side ribbon, you are not logged in with a Microsoft EDU account. Create your own, or get in touch with your IT department for your login.

What is the difference between the Due Date and the Close Date?

Students can still turn in Assignments after the Due Date has passed, but once the Close Date has passed, no more submissions are allowed.

If I return the assignment to my student does that mean I want them to redo it?

Not necessarily. You can return all assignments to the students so that they can see your feedback. If you want a student to redo the assignment, you should let them know in your feedback.

Can I attach a PDF for my students to edit to the assignment?

You can do this through your Class Notebook! Insert the PDF to a Class Notebook page and set it as the background. Then, you can assign this page to your students.

Watch this for a visual guide on how to insert a PDF to a Class Notebook page.

Can I assign an assignment to a certain channel?

Unfortunately, no. You can only assign to the General Channel, which is all your students, or assign to individual students when setting up the assignment.

About Sara Wanasek

Try classpoint for free.

All-in-one teaching and student engagement in PowerPoint.

Supercharge your PowerPoint. Start today.

500,000+ people like you use ClassPoint to boost student engagement in PowerPoint presentations.

Simplify your class workflow with new Assignments features from Teams

September 20, 2023.

By Microsoft Education Team

Share this article

Whether it’s the beginning of a new school year or mid-winter semester, we know it’s important for you to have the right tools to help prepare, teach, and assess your students more efficiently. With customizable features and options, Microsoft Teams for Education helps you simplify your class workflow and create a quality learning environment for students as well as educators.

Explore four new Assignments features in Microsoft Teams for Education designed to help you make the most of your valuable instruction and assessment time.

1. Duplicate or share assignments in a snap with new quick actions

With the latest updates to quick actions in the Assignment list, you can click on an assignment and choose from these options: Edit, Copy Link, Duplicate, Mark as Inactive, or Delete. With Duplicate, you can copy the assignment to another class. With Copy Link, you can get a direct link to the assignment and share it over chat, email, or any other platform you use to communicate with your students.

With quick actions in the Assignment list in Teams, you can choose these options for assignments: Edit, Copy Link, Duplicate, Mark as Inactive, or Delete.

2. Set individual assignment due dates for multiple classes

If you have multiple classes to publish an assignment to, you can now set individual schedule, due, and close dates for each class with new multi-publish support. With new multi-class assignment options, you can quickly make one or more changes and publish to all your classes in one action, saving you time and streamlining the management of your assignment timelines.

3. Configure quiz time limits directly in Assignments

Timed Quiz is a popular feature in Microsoft Forms, enabling you to set the amount of time students have for a quiz. Now, you can configure and change the time for each quiz directly inside of Assignments settings in Teams. This new capability allows you to make any quiz a Timed Quiz without having to go into Forms to change the settings.

Configure and change the time for each quiz directly inside of Assignments settings in Teams.

4. Customize your grading with new Grade settings

In Assignments and Grades, the Grade settings now support multiple grading schemes. Use this feature to map to your grading schemes for grading inside Teams . Once configured, you can either use points or a new scheme of your choice in your grading and reporting. The system is flexible to support a variety of needs—you can even use emojis for your grading!

In Assignments and Grades, use the Grade settings to customize your grading schemes for grading inside Teams.

With the latest updates from Microsoft Teams for Education , you’ll find simplified ways to help streamline, manage, and customize your class workflow. Discover all the newest updates to Microsoft Teams in What’s New in Teams for Education | August 2023 .

Ready to go deeper? Take the free, online training Master Microsoft Teams for any learning environment from Microsoft Learn.

Related stories

New IDC InfoBrief explores key skills and tools critical to AI success

Prepare for the future with IDC’s insights on AI in the workforce. Learn how the balance of human capabilities and AI tools is critical for career success.

8 transformative tools to elevate project-based learning

Navigating the complexities of project-based learning (PBL) can be overwhelming, but you’re not alone. Many educators find balancing the hands-on approach of PBL with structured planning and managing groups challenging. Fear not—we can help!

4 new Teams updates to enhance classroom engagement

Students are engaged by dynamic learning environments—the type of environments that offer experiences and tools that help students relate to content, understand why their learning matters, and show their thinking in various ways. Dynamic learning environments also help educators to swiftly and effectively evaluate and adjust learning experiences to suit students’ specific needs.

• SCHOOL STORIES
• MICROSOFT EDUCATOR CENTER
• CONTACT SALES

Teams Forum Top Contributors: EmilyS_726   ✅

May 10, 2024

Teams Forum Top Contributors:

EmilyS_726   ✅

Contribute to the Teams forum! Click  here  to learn more  💡

April 9, 2024

Contribute to the Teams forum!

Click  here  to learn more  💡

• Search the community and support articles
• Microsoft Teams
• Teams for education
• Search Community member

Ask a new question

Assignment tab is not appearing in a team

The assignment tab is not appearing in the team tab list. I am unable to post an assignment for the students. I would like to know any settings that need to be done or any suggestions to resolve this issue.

Report abuse

Reported content has been submitted​

• Independent Advisor

2 people found this reply helpful

Was this reply helpful? Yes No

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

Thanks for your feedback.

1 person found this reply helpful

Replies (7) 

Question info.

• Assignments
• Set assignments
• Norsk Bokmål
• Ελληνικά
• Русский
• עברית
• العربية
• ไทย
• 한국어
• 中文(简体)
• 中文(繁體)
• 日本語

Create an assignment in Microsoft Teams

Create  assignments for your students in Microsoft Teams for Education . Manage assignment timelines, add instructions, create resources to turn in, and more.

Note:  Assignments is only available in class teams . You can assign assignments to classes of up to 1000 students. Classes larger than 300 can't use a Class Notebook or Makecode.

In this article

Create a new assignment, title and category, instructions and attachments.

Points, rubrics, and grading

Assigning to students or groups

Due dates and scheduling, assign, save, or discard, classwork modules.

Navigating the Grades tab

Navigate to the desired class team, then select Assignments .

Select Create >   New   Assignment .

At a minimum, you must give the assignment a title. This is required. You can optionally add a tag, which will make this assignment easier to search for in the future. 

Assignments only supports the following image file types: .png, .jpeg, and .gif. 

On mobile, Images will resize to the screen. 

On desktop, you can use sizing handles on images to resize them.  

You can also attach existing files, links, or assignment integrations and create and name a new file right from here for students to turn in.

Note:  You can add up to five files for students to edit. The total number of resources you can add to an assignment is 10, whether editable or non-editable. Read-only reference files can be up to 500 MB in size. Files for students to edit can be up to 50 MB in size.

Select Attach  to attach resources to the assignment. Choose a file from your OneDrive, upload a file from your device, or choose one of the other options set by your admin, such as MakeCode.

Note:  If you're assigning a Class Notebook page, check what version of OneNote your students are using to ensure that their assignment pages will lock after the assignment due date passes.

Select +New  to create a blank Word (.docx), Excel (.xlsx), PowerPoint (.pptx), or Whiteboard document, or a new video recording to hand out to your students.

Select  Apps  to attach content from an app to the assignment. Admins can  manage Teams apps in the Microsoft Teams admin center .

Select Learning Accelerators  to add Reading Progress , Search Progress and other Learning Accelerators to the Assignment.

By default, Students can't edit  attached documents, meaning the document is read-only. This is a great option for reference materials.

Note:  If you have older documents with the file extension .doc, .xls, or .ppt, students won't be able to edit them. You can either attach them as read-only reference material or create a new file in Teams, copy in the old content, and save it. All new files you create in Teams or other Microsoft 365 apps will have the correct extension.

The Assign to field is where you choose the class for this assignment. By default, the class team you are in will be selected. 

Multiclass Publish

Multiclass publish allows educators to create an assignment for multiple classes with the same due date. 

Do this by navigating to the Assign to field and check the boxes for classes the assignment will be published to. 

Points and rubrics

You can select which grading scheme,  grading categories , and points the assignment is worth. 

If you have configured the class to use Grading Categories, you need to select a Grading Category for assignment with points.

Select the amount of points this assignment is worth, if any. You can use points on any number-based scale including whole numbers of 100 and set your own denominator. Examples:  88/100 or decimals 3.7/4.0.

Select  Add rubric  to  create a rubric .

Select  Manage grading categories  to create or edit the grading categories for the class.

Setting up Grading Schemes

Letter grading and grading categories must be set as a Grading Scheme in the Grade settings section to display these options.

2. Navigate down to Grade settings .

3. Choose Add Schemes or  Manage schemes .

Note:  If no other grading schemes other than "Points" have been set, this link will read  Add Schemes . Once you have gone through the steps to add a new scheme, the link will change to  Manage schemes. 

5. Set the grading levels. Letter grades will be the normal A, B, C, D, F, scheme. Ensure that there are enough levels to cover the entire 0-100 percent range.

6. Select the Save button when complete. 

Finish by choosing the  Done  button. 

Choose multiple classes, individual students, or groups of students  in one class to assign to.

By default, only students who are in your class now will receive this assignment. Change this by selecting an option from the dropdown menu.

Note:  If you choose a close date, any student who joins will receive this assignment until the close date.

Select a time and date for the assignment to be due. To schedule an assignment, next to  Assignment will post immediately with late turn-ins allowed  select Edit assignment timeline . Here, you can customize when your assignment will be posted to students and when it will close for turn-ins. By default, no close date will be selected, which allows students to turn in assignments late.

Note: If you choose multiple classes to publish the assignment to, you can select Set due date per class to set individual schedule , due and close date for each class

You can choose whether to add this assignment to your calendar on Outlook, students' calendars, and other educators or staff in your class team. Set this preference for all assignments in Assignments Settings .

Next to Add assignment to calendars , select the dropdown and pick one of the following options:

Students only  adds the assignment to just student calendars.

Students and me adds the assignment to both student calendars and your calendar.

Students and team owners to adds the assignment to both student and other educators or staff in the class team calendars.

Choose the channel where you'd like notifications for this assignment to post. This allows you to keep student work and discussion organized by unit, topic, or subject. By default, assignments will be posted in the General channel or your selection in Assignments Settings.

To choose a channel to post in, next to Post assignment notifications to:  select the down arrow for a list of available channels. 

Pick the channel you’d like this assignment notification to post in, your selection will be applied immediately.

To post assignment notifications to a channel, make sure bot posting is enabled. You can check that here  or ask your IT Admin for help.

Assignments will post to channels that are visible to all students. Private channels will not appear during this step.

If you have selected multiple classes, select Set per Class to set which channel to use or just use the General channel. Assignments to individual students do not post to channels.

When you're ready, you can finish the process of creating your new assignment by assigning it to students.

Note:  If your school uses Turnitin, you can sync assignment turn-ins to Turnitin .

Assign  will immediately publish the assignment and your students will be notified of the new assignment on the day you specified and the notification linking to this assignment will post in the channel you selected. They'll also have an entry on their Teams and Outlooks calendars if you've selected that option.

Save  will save a draft of the assignment. Students will not receive any notification, and nothing will be added to any calendar. 

Discard  will delete the draft of the assignment. Students will not receive any notification, and nothing will be added to any calendar. 

Create a New Module

1. Navigate to the desired Class Team, then select Classwork.

2. Select Add module. 

3. Enter a title for the new module.

4. Optionally, enter a description.

5. Select Save to save the module as a draft.

Note: Draft modules are only visible to Team owners (teachers) until published. All new modules are created in draft states. 

Learn more about managing classwork modules in Microsoft Teams.

Navigate the Grades tab

To open the Grades tab, navigate to your desired class team and select Grades .

You'll see that students appear in a column, with their assignments in a row next to their name. Assignments are listed in order by due date with the nearest date at the beginning. 

Learn more about the Grades tab. 

Create a group assignment

Edit an assignment

Save an assignment as a draft

Grade, return, and reassign assignments

Additional resources for educators

Ask the community

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Thank you for your feedback.

• Using Project Execution Management

Work Plan Templates

A work plan template is standard set of project tasks and resource assignments. They enable project managers to standardize project creation across teams and act as an efficient starting point for creating task structures.

You can use work plan templates to add tasks and resources during project creation and to existing projects.

Advantages of using work plan templates:

Quickly build task structures by using standard task structures.

Save time in assigning resources by using generic resources and later replacing these resources with actual named-persons.

Save standard task structures and share them with other project managers.

Work Plan Template Creation

To create a work plan template, you must be the Project Manager or have the required privileges. To create a work plan template from a project, open the project and select Save as Work Plan Template from the Actions drop-down list on the Manage Project Plan page.

When you create a work plan template, it contains the following values from the project:

Financial and nonfinancial tasks along with their attributes including:

Task Number, Task Code, Description, Priority, Billable, Chargeable, Schedule Mode, Schedule Type, Work Type

Planned Effort, Planned Allocation, Planned Duration

Labor Resources and Expense Resources

Planned Labor Cost, Planned Labor Bill Amount, Planned Expense Amount, Total Planned Cost

Dependencies

Gate approvers as team members

Approvers from the Gate Approvers table

All resources except project-specific resources

Expense resources on tasks

Deliverable types associated with tasks

Project resources as planned resources

Resources along with roles if same resource with multiple roles exists

Resource assignments for each task

The application sets the tasks progress to zero and sets the following values to blank:

Start and Finish

Constraint type and date

Sprint and requirement

Actual expense amounts

Actual hours

Actual amounts for expense resources

How You Add Tasks During Project Creation

Project managers can select a work plan template in the Create Project window when creating a project to add tasks from a work plan template.

When you add tasks from a work plan template, all the values in the work plan template are copied to the project. Refer to the Work Plan Template Creation section to learn about values contained in work plan templates.

Considerations for Editing Work Plan Templates

Project managers can edit work plan templates from the Edit Work Plan Template page. To navigate to the page, open Manage Project Plan page > click Manage Work Plan Template from the Actions panel tab > click the work plan template.

When you edit a work plan template, the existing projects based on the work plan template aren't updated. These changes are included only in the projects that are created after making these changes.

Considerations for Adding Tasks from a Work Plan Template

When you create tasks from a work plan template, here are a few things to keep in mind:

The tasks inherit the schedule type of the project.

Summary tasks in the work plan template are added as peers to the selected task in the project plan. If the selected task is at a project level, summary tasks in the work plan template are created as subtasks.

How You Share Work Plan Templates

Project managers can share work plan templates with other project managers in two ways:

Enable the Public check box when you use the Save as Work Plan Template action in your project plan.

Enable the Public check box for a work plan template in the Manage Work Plan Templates window.

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Overview of app management and governance in Teams admin center

• 18 contributors
• Applies to: Microsoft Teams

In the Teams admin center, we provide a few dedicated pages to manage your apps with granularity and complete control. You manage apps for your organization in the Manage apps page in the Teams admin center portal. Use the URL https://admin.teams.microsoft.com/policies/manage-apps to view and govern all Teams apps that are available in your organization's app catalog, define access to apps using policies, cater to prominent use cases for app management, and more.

To use Teams admin center, you must have a Global Administrator or Teams Administrator role. For details, see Teams administrator roles and Microsoft 365 administrator roles .

App developers extend Microsoft Copilot for Microsoft 365 by creating plugins, for example, Microsoft Teams message extension or a Power Platform connector. These plugins increase user productivity across daily tasks and workflows. Admins manage plugins for Copilot in the Integrated apps section of the Microsoft 365 admin center.

You can only view and manage apps that are deployed in the same release channel as your tenant is. For example, if your tenant is in the general release channel then you can't manage apps that are deployed in the private or public preview channels. This isn't an issue for apps that are released to the general release channel.

App management use cases and the available interfaces

The options to accomplish most of app management use cases are available in Teams admin center. In addition, some options are available in other portals or different pages in the Teams admin center.

App management tasks that are supported in admin center are in the table below.

App management tasks that are supported on other portals are in the table below.

Allow or block apps

As an admin, you control access to all types of apps that are used across your organization. Teams provides granular controls to configure access for each app and for each user.

To allow an app, you must do all of the following settings. To block an app, just use any one of these settings.

You allow or block specific apps on either the Manage apps page or in the app details page. Manage apps page displays all the available app and the current org-level app status. To allow or block an app, follow these steps:

Sign in to the Teams admin center and access Teams apps > Manage apps .

Select the app on the Manage apps page and select Allow or Block option.

Alternately, click on the app name to open its app details page. Change the status between Allowed and Blocked .

If you use manage access by apps feature , the block option is available in the Actions menu.

To allow an app for specific users, see app permission policies .

When a developer publishes an app to the Teams store, some apps may need an admin to configure the app. Before an admin allows such an app, it shows as Blocked by publisher in the admin center. Before you allow it for users, follow the publisher's guidance to configure the app.

To block all third-party apps, open the Org-wide app settings on the Manage apps page and disallow the use of third-party apps. If you use manage access by apps feature , you can also block the apps created by Microsoft .

From within the Teams client, your users can request you to allow the apps that aren't available for them. You receive notifications and can allow the app. For details, see view and manage user requests .

Allow access to an app for users and groups

As an admin, you use one of the following methods to define access to apps for your users:

• App permission policies if you use policy-based method to define app access.
• App assignment if you use app centric management to define app access.

Simplify app rollout and adoption based on organization needs

As an admin you can't just allow apps and authorize users to use the apps, you can also make app rollout and app adoption much smoother for the admin team and for your organization's users. To facilitate friction-free app rollout and adoption, Teams provides conceptual guidance and suggestions to app developers so that developers can enable admins to drive adoption . Also, Teams admin center provides various features that help you evaluate apps, allow apps, auto-install apps, pin apps for users, and so on.

We recommend a few approaches below that can cater to your organization’s need and the recommendations are based on the following guiding principles:

• Respect and support IT and security requirements around app permissions, access, and availability across all options.
• Improve app adoption so that the authorized users can use the app in Teams as soon as the app is required and continue their work efficiently.
• Don’t interrupt or burden the users who aren’t using the app.

Manage org-wide app settings

Use org-wide app settings to control whether users with an F license get the tailored frontline app experience, whether users can install third-party apps, and whether users can upload custom apps in your organization.

On Manage apps page, select Org-wide app settings . You can then configure the settings you want in the pane.

Under Tailored apps , turn off or turn on Show tailored apps . When this setting is on, users with an F license get the tailored frontline app experience. This experience pins the most relevant apps in Teams for frontline workers. To learn more, see Tailor Teams apps for your frontline workers .

This feature is available for F licenses. Other license types will be supported in the future.

Under Third-party apps , turn off or turn on these settings to control access to third-party apps in your organization:

Allow third-party apps : This setting controls whether users can use third-party apps. If you turn off this setting, your users won't be able to install or use any third-party apps and the app status of these apps is displayed as Blocked org-wide in the table.

When Allow third-party apps is off, outgoing webhooks are still enabled for all users, but you can control them at the user level by allowing or blocking the Outgoing Webhook app through app permission policies .

Allow any new third-party apps published to the store by default : This setting controls whether new third-party apps that are published to the Teams app store become automatically available in Teams. You can only set this option if you allow third-party apps.

Under Custom apps , turn off or turn on Upload custom apps for personal use option. This setting controls whether users can upload custom apps or not. To learn more about custom apps, see how to manage custom apps .

Select Save . The settings take effect after a few hours.

Admin center settings may allow your users to collaborate with users from other organizations. To understand how apps work with external users in meetings, see Teams apps for external attendees .

Auto install approved apps based on admin approval

Auto install approved apps feature automatically adds approved apps in Teams client of the permitted users. The functionality respects all admin governance controls and only installs apps that the users use outside Teams. It reduces manual intervention to add an app and improves user productivity by preventing context-switching. To know more about the feature, see Auto install approved apps in Teams .

Stop app usage and remove apps

As an admin, to prevent users from adding and using an app in Teams, you can do one of the following:

• For any type of apps, block it for entire org .
• For any type of apps, prevent a few users from accessing the app by using either permission policies or by using app centric management .
• Delete a custom app from your organization's store. You can't remove any app that is available in Teams app store.
• You can't stop use of some Core apps provided by Microsoft that are critical for Teams to work.

You can't remove or uninstall the apps that are currently added by users.

Blocked apps may still have access to data from the teams that the apps were added to. To turn off app data access, a Global Administrator, an Application Administrator, or a Cloud Application Administrator must turn off user sign-in in the Microsoft Entra admin center .

Manage org-wide app settings for Microsoft 365 Government

In a Microsoft 365 Government - GCC, GCCH and DoD deployment of Teams, all third-party apps are blocked by default. In GCC, you see the following note about managing third-party apps on the app permission policies page in the Microsoft Teams admin center.

Use org-wide app settings to control whether users can install third-party apps. Org-wide app settings govern the behavior for all users and override any other app permission policies assigned to users.

On the Teams Apps > Manage apps page, select Org-wide app settings . You can then configure the settings you want in the panel.

Under Third-party apps , turn off or turn on these settings to control access to third-party apps:

• Allow third-party apps : This option controls whether users can use third-party apps. If you turn off this setting, your users aren't able to add or use any third-party apps. In a Microsoft 365 Government - GCCH and DoD deployment of Teams, this setting is off by default.
• Allow any new third-party apps published to the store by default : This option controls whether new third-party apps that are published to the Teams app store become automatically available in Teams. You can only set this option if you allow third-party apps.

Under Blocked apps , add the apps you want to block across your organization. For any third-party app you want to allow in your organization, remove the app from this blocked apps list. A blocked app isn't available to any user, regardless of app policies.

Select Save for org-wide app settings to take effect.

To allow third-party apps, either edit and use the Global (Org-wide default) policy or create and assign an admin-created policy.

Manage apps in 21Vianet and air-gapped cloud environments

In Microsoft 365 operated by 21Vianet and air-gapped cloud environments, you get an overview of the apps on the Teams apps > Manage apps page.

To view more details of an app, click an app's name to access the app details page. You can allow or block the app for your users.

Support information for apps

You may have queries about admin settings or configuration, user flows and app features, app troubleshooting, and more. You receive support information about apps from the following two different sources:

We don't provide direct customer support for Teams apps but we provide the following safeguards, health checks, and certification methods for apps:

• We proactively check Teams apps for issues and inform the developer to update their app. Scenarios covered are related to app health, functional issues reported by users to Microsoft, security issues, and so on. For details, see Microsoft enforcement actions for published apps .
• For Publisher Attested and Microsoft 365 certified apps, Microsoft provides the security and compliance information of apps .
• Testing of all apps as part of its app validation program to ensure that all apps work as advertised. If apps don't work as suggested in the app listing, then we contact app developers to request either an update to the app. If app developers don't make the requested updates after a few reminders, we proactively remove the apps from Teams.
• Certification to apps using Microsoft 365 app compliance program ensures that apps are compliant with the industry-standard frameworks.

Developer provided app information, support, and documentation

App developers provide customer support, updates to the apps, security and compliance information, bug fixes, and so on. The app security and compliance information are available in the admin center in app details page as mentioned above. App developers publish app updates, bug fixes, and vulnerability fixes as per their business requirements, issue severity, and service agreements. For direct support requests and inquiry about app updates, contact the app developer at their website address available at the following two places:

App details page of the app in Manage apps page in Teams admin center.

Details + support tab of the app's AppSource page.

Privacy and data access considerations : In the terms of use and privacy policy of any app, the app developer discloses what data their app uses and how it's handled. This information is available on app developer's website and you can access the URLs in the app details page in Teams admin center. Many app developers choose to undergo the Microsoft 365 app compliance program. The program checks and audits an app against controls that are derived from leading industry-standard frameworks. The detailed information about each such app is available at Teams Apps Security and Compliance .

App developers can provide their contact information that you can use to chat with them. It helps you quickly evaluate an app and get the needed information from the app developers before you adopt and rollout an app. Some examples of such information are compliance and certification details, data handling details, clarity on pricing plans for paid apps, and app configuration instructions. You can start a chat with app developers by selecting Start a Teams chat but only if the app developer provided their contact information. We recommend that you don't share personal and sensitive information in the chat.

Related articles

• Manage user requests to allow apps
• Auto install approved apps in Teams
• Install and pin apps via setup policies
• Overview of policies to govern apps .

Was this page helpful?

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback .

Submit and view feedback for

Additional resources

• Announcements
• Copilot Studio

Microsoft Copilot Studio: Building copilots with agent capabilities

Omar Aftab , Vice President, Conversational AI , Tuesday, May 21, 2024

At Microsoft Build 2024 , we’re excited to announce a host of new powerful capabilities in   Microsoft Copilot Studio —t he single conversational AI tool you can use to create your very own custom copilots or extend Microsoft C opilot experiences with your own enterprise data and scenarios.

The first of these are c opilots that can now act as independent agents— ones that can be triggered by events— not just conversation— and can automa te and orchestrate complex, long-running business processes with more autonomy and less human intervention.

For instance, consider the potential of a copilot that can react when an email arrives, look up the sender’s details, see their previous communications, and use generative AI to trigger the appropriate chain of actions in their response. From understanding the intent of the email, to look ing up the sender’s details and account , see ing their previous communications, checking inventory,   responding to the sender asking for their preferences, and then taking the appropriate actions to close a ticket — orchestrating and shepherding an entire process over days.  

With such capabilities, copilots are evolving from those that work with you to those that work for you. They can be designed to handle specific roles or functions, such as IT, marketing, sales, customer success, and finance across various industries, including travel, retail, and financial services.  

With these new capabilities, here are some examples of the kinds of copilots our customers can build:  

• IT help desk .  IT support is complex, involving tickets, order numbers, approvals, and stock levels . O pening and closing a ticket can be a long-running task that spans days. A copilot can now handle this process, interfacing with IT service management applications, resolving IT tickets with context and memory, creating purchase orders for device refresh, and reaching out and getting managers approvals — all independently .
• Employee onboarding . Onboarding new employees is often expensive and slow. Now, imagine you’re a new hire. A copilot greets you, reasons over HR data, and answers your questions. It introduces you to your buddy, provides training and deadlines, assists with forms, and sets up your first week of meetings. Throughout all of this, the copilot is in touch, guiding you through the weeks -long onboarding and account set up processes.  
• Personal concierge for sales and service . Balancing exceptional customer experience while meeting ambitious revenue goals can be challenging. When a copilot serves guests, i t can use the memory of previous conversations with guests to remember their preferences, make reservations, handle complaints, and answer questions related to the products and services on offer. The copilot learns from its interactions and proposes new ways of handling customer scenarios. By doing so, copilots can increase upsell and attachment rates, driving revenue for the resort while simultaneously enhancing guest experience, satisfaction rates, and repeat business.

Let’s dig deeper into a few of the underlying capabilities that make all this possible:

• Asynchronous orchestration of complex tasks . The first is the ability to use generative AI- powered   planning and reasoning to manage complex, multi step, long-running tasks. For example, reacting to a new order means determining the need to verify inventory, trigger ing the right payment processes, pinging a supervisor for approval if the amount is above a certain threshold, and replying with a confirmation. Many of these events can take hours—or even days— to complete, but the copilot will run through them , maintaining the necessary state and context to do so.
• Memory and context . One of the frustrating things about support has traditionally been having to repeat information: who you are, what your policy number is, what your address is. There is no continuity of conversation. Copilots will now learn from previous conversations from the users and utilize this knowledge to continually personalize interactions . A copilot may not need to ask you for your laptop model or your address when you call again for the same issue. Conversations will thus become long-running, contextual, and deeply personalized.
• Monitor, learn, and improve . Copilots can now learn and adapt, offering monitoring and teaching capabilities to make their interactions better. Each copilot records a comprehensive history of its activities, providing transparency into its performance, including user interactions, actions taken, and feedback received, and you can see what decisions it made — and correct and teach them — with just a few clicks.

• Delegation with confidence and guardrails . When developing copilots with agent capabilities, establishing clear boundaries is paramount. Copilots operate strictly within the confines of the maker-defined instructions, knowledge, and actions. The data sources linked to the copilot adhere to stringent security measures and controls, managed through the unified admin center of Copilot Studio. This includes data loss prevention, robust authentication protocols, and more.

The se advanced new capabilities in Copilot Studio are currently accessible to customers participating in a limited private preview  where organizations such as Centro de la Familia are excited to explore agent capabilities that support teachers and case workers, allowing them to spend less time on administrative tasks and more time working with children, ultimately leading to better child outcomes . Based on feedback from program participants, we will continue to iterate and refine these capabilities for broader access in a preview planned for later this year .  

Additional innovations with Copilot Studio

There’s a lot more to share at Microsoft Build with Copilot Studio, and we’ll touch on just a few of our new capabilities here. To learn more — just sign up and try it out for yourself here .

It’s easier than ever to create c opilots .  With Copilot Studio, creating and testing copilots is now incredibly simple. You can create your copilot with our brand new conversationally driven experience — simply describe what you want it to do, and what knowledge you want it to have, and Copilot Studio will create your very own c opilot. You can then immediately test it out, add additional capabilities, such as your own actions, APIs, and enterprise knowledge — and then publish it live with a few clicks.

Connect all your enterprise data with Copilot c onnectors .   Customers want copilots connected with data from their own enterprises business systems and apps. Copilot connectors enable anyone to ground their copilot in business and collaboration data. This makes it possible for copilots to use various data sources, including public websites, SharePoint, OneDrive, Microsoft Dataverse tables, Microsoft Fabric OneLake (coming this calendar year), Microsoft Graph, as well as leading third-party apps. You can even create your own custom generative prompts to configure how a copilot handles a response from an API or connector.

Here are a few examples of how Copilot connectors can transform copilot experiences for specific personas or functions:

• Legal and Compliance . Navigate complex legal landscapes with a Copilot extension that queries specific legal datasets, ensuring controlled and compliant responses without overwhelming users with extraneous information.
• HR Helper . Assist employees with accessing essential resources for benefits and PTO policies, and even book time off directly through Copilot.
• Incident Report Coordinator . Workers can locate the right documentation, report incidents, and track them efficiently, all within the context of the chat.

Starting in June 2024, developers can access the preview for Copilot connectors and stay informed on updates here .

Conversational analytics (private preview) : One of the most common asks from customers has been the need for deeper insight into what their copilot is doing, how generative AI is responding, when it was unable to give the right answers and why — and recommendations on what to do to improve it.

Templates : If simply describing your copilot to build it wasn’t easy enough, Copilot Studio will now also include a variety of pre-built copilot samples for departments and industries. Some templates — such as Safe Travels for comprehensive travel support, Organization Navigator for organizational clarity, Kudos Copilot for fostering recognition, Wellness for employee health insights — are available now, with many more releasing in the coming months.

Enhanced security and controls (public preview ) : Administrators can now configure advanced settings beyond the default security measures and controls. With Microsoft Purview , Copilot Studio administrators gain access to more detailed governance tools, including audit logs, inventory capabilities, and sensitivity labels. They will be able to review comprehensive audit logs that cover tenant-wide usage, inventory (with API support), and tenant hygiene (such as data loss prevention violations and inactive copilots), enabling them to effectively monitor business impact. Both creators and end-users will be able to view sensitivity labels when responses are generated using AI-powered answers based on SharePoint documents.

With all the amazing innovations, numerous organizations are using Copilot Studio to build transformative generative AI-powered solutions. Check out this story from Nsure on how they are using Copilot Studio:

Get started today with Copilot Studio

This is just a glimpse of all the exciting innovation around copilots and Copilot Studio — we have a host of exciting new capabilities to share in our sessions at Build. So, join us in watching the sessions below, and try out Copilot Studio yourself and build and share your very own copilot in minutes.

Watch the sessions at Microsoft Build:

• “ Microsoft Build opening keynote ”
• “ Next generation AI for developers with the Microsoft Cloud ”
• “ Shaping next-gen development: the future of Copilot in Power Platform ”

Deeper dives:

• Breakout: “ What’s new with Microsoft Copilot Studio ”
• Breakout with demos: “ Build your own copilot with Microsoft Copilot Studio ”
• Breakout with demos: “ Build Microsoft Copilot extensions with Copilot Studio ”
• Demo (live only): “ Build your own Copilot extension with Microsoft Copilot Studio ”

Please enter your information to subscribe to the Microsoft Fabric Blog.

Microsoft fabric updates blog.

Microsoft Fabric May 2024 Update

• Monthly Update

Welcome to the May 2024 update.  

Here are a few, select highlights of the many we have for Fabric. You can now ask Copilot questions about data in your model, Model Explorer and authoring calculation groups in Power BI desktop is now generally available, and Real-Time Intelligence provides a complete end-to-end solution for ingesting, processing, analyzing, visualizing, monitoring, and acting on events.

There is much more to explore, please continue to read on. 

Microsoft Build Announcements

At Microsoft Build 2024, we are thrilled to announce a huge array of innovations coming to the Microsoft Fabric platform that will make Microsoft Fabric’s capabilities even more robust and even customizable to meet the unique needs of each organization. To learn more about these changes, read the “ Unlock real-time insights with AI-powered analytics in Microsoft Fabric ” announcement blog by Arun Ulag.

Fabric Roadmap Update

Last October at the Microsoft Power Platform Community Conference we  announced the release of the Microsoft Fabric Roadmap . Today we have updated that roadmap to include the next semester of Fabric innovations. As promised, we have merged Power BI into this roadmap to give you a single, unified road map for all of Microsoft Fabric. You can find the Fabric Roadmap at  https://aka.ms/FabricRoadmap .

We will be innovating our Roadmap over the coming year and would love to hear your recommendation ways that we can make this experience better for you. Please submit suggestions at  https://aka.ms/FabricIdeas .

Earn a discount on your Microsoft Fabric certification exam!  

We’d like to thank the thousands of you who completed the Fabric AI Skills Challenge and earned a free voucher for Exam DP-600 which leads to the Fabric Analytics Engineer Associate certification.   

If you earned a free voucher, you can find redemption instructions in your email. We recommend that you schedule your exam now, before your discount voucher expires on June 24 th . All exams must be scheduled and completed by this date.    

If you need a little more help with exam prep, visit the Fabric Career Hub which has expert-led training, exam crams, practice tests and more.  

Missed the Fabric AI Skills Challenge? We have you covered. For a limited time , you could earn a 50% exam discount by taking the Fabric 30 Days to Learn It Challenge .  

Modern Tooltip now on by Default

Matrix layouts, line updates, on-object interaction updates, publish to folders in public preview, you can now ask copilot questions about data in your model (preview), announcing general availability of dax query view, copilot to write and explain dax queries in dax query view public preview updates, new manage relationships dialog, refreshing calculated columns and calculated tables referencing directquery sources with single sign-on, announcing general availability of model explorer and authoring calculation groups in power bi desktop, microsoft entra id sso support for oracle database, certified connector updates, view reports in onedrive and sharepoint with live connected semantic models, storytelling in powerpoint – image mode in the power bi add-in for powerpoint, storytelling in powerpoint – data updated notification, git integration support for direct lake semantic models.

• Editor’s pick of the quarter
• New visuals in AppSource
• Financial Reporting Matrix by Profitbase
• Horizon Chart by Powerviz

Milestone Trend Analysis Chart by Nova Silva

• Sunburst Chart by Powerviz
• Stacked Bar Chart with Line by JTA

Fabric Automation

Streamlining fabric admin apis, microsoft fabric workload development kit, external data sharing, apis for onelake data access roles, shortcuts to on-premises and network-restricted data, copilot for data warehouse.

• Unlocking Insights through Time: Time travel in Data warehouse

Copy Into enhancements

Faster workspace resource assignment powered by just in time database attachment, runtime 1.3 (apache spark 3.5, delta lake 3.1, r 4.3.3, python 3.11) – public preview, native execution engine for fabric runtime 1.2 (apache spark 3.4) – public preview , spark run series analysis, comment @tagging in notebook, notebook ribbon upgrade, notebook metadata update notification, environment is ga now, rest api support for workspace data engineering/science settings, fabric user data functions (private preview), introducing api for graphql in microsoft fabric (preview), copilot will be enabled by default, the ai and copilot setting will be automatically delegated to capacity admins, abuse monitoring no longer stores your data, real-time hub, source from real-time hub in enhanced eventstream, use real-time hub to get data in kql database in eventhouse, get data from real-time hub within reflexes, eventstream edit and live modes, default and derived streams, route streams based on content in enhanced eventstream, eventhouse is now generally available, eventhouse onelake availability is now generally available, create a database shortcut to another kql database, support for ai anomaly detector, copilot for real-time intelligence, eventhouse tenant level private endpoint support, visualize data with real-time dashboards, new experience for data exploration, create triggers from real-time hub, set alert on real-time dashboards, taking action through fabric items, general availability of the power query sdk for vs code, refresh the refresh history dialog, introducing data workflows in data factory, introducing trusted workspace access in fabric data pipelines.

• Introducing Blob Storage Event Triggers for Data Pipelines
• Parent/child pipeline pattern monitoring improvements

Fabric Spark job definition activity now available

Hd insight activity now available, modern get data experience in data pipeline.

Power BI tooltips are embarking on an evolution to enhance their functionality. To lay the groundwork, we are introducing the modern tooltip as the new default , a feature that many users may already recognize from its previous preview status. This change is more than just an upgrade; it’s the first step in a series of remarkable improvements. These future developments promise to revolutionize tooltip management and customization, offering possibilities that were previously only imaginable. As we prepare for the general availability of the modern tooltip, this is an excellent opportunity for users to become familiar with its features and capabilities. 

Discover the full potential of the new tooltip feature by visiting our dedicated blog . Dive into the details and explore the comprehensive vision we’ve crafted for tooltips, designed to enhance your Power BI experience. 

We’ve listened to our community’s feedback on improving our tabular visuals (Table and Matrix), and we’re excited to initiate their transformation. Drawing inspiration from the familiar PivotTable in Excel , we aim to build new features and capabilities upon a stronger foundation. In our May update, we’re introducing ‘ Layouts for Matrix .’ Now, you can select from compact , outline , or tabular layouts to alter the arrangement of components in a manner akin to Excel. 

As an extension of the new layout options, report creators can now craft custom layout patterns by repeating row headers. This powerful control, inspired by Excel’s PivotTable layout, enables the creation of a matrix that closely resembles the look and feel of a table. This enhancement not only provides greater flexibility but also brings a touch of Excel’s intuitive design to Power BI’s matrix visuals. Only available for Outline and Tabular layouts.

To further align with Excel’s functionality, report creators now have the option to insert blank rows within the matrix. This feature allows for the separation of higher-level row header categories, significantly enhancing the readability of the report. It’s a thoughtful addition that brings a new level of clarity and organization to Power BI’s matrix visuals and opens a path for future enhancements for totals/subtotals and rows/column headers. 

We understand your eagerness to delve deeper into the matrix layouts and grasp how these enhancements fulfill the highly requested features by our community. Find out more and join the conversation in our dedicated blog , where we unravel the details and share the community-driven vision behind these improvements. 

Following last month’s introduction of the initial line enhancements, May brings a groundbreaking set of line capabilities that are set to transform your Power BI experience: 

• Hide/Show lines : Gain control over the visibility of your lines for a cleaner, more focused report. 
• Customized line pattern : Tailor the pattern of your lines to match the style and context of your data. 
• Auto-scaled line pattern : Ensure your line patterns scale perfectly with your data, maintaining consistency and clarity. 
• Line dash cap : Customize the end caps of your customized dashed lines for a polished, professional look. 
• Line upgrades across other line types : Experience improvements in reference lines, forecast lines, leader lines, small multiple gridlines, and the new card’s divider line. 

These enhancements are not to be missed. We recommend visiting our dedicated blog for an in-depth exploration of all the new capabilities added to lines, keeping you informed and up to date. 

This May release, we’re excited to introduce on-object formatting support for Small multiples , Waterfall , and Matrix visuals. This new feature allows users to interact directly with these visuals for a more intuitive and efficient formatting experience. By double-clicking on any of these visuals, users can now right-click on the specific visual component they wish to format, bringing up a convenient mini-toolbar. This streamlined approach not only saves time but also enhances the user’s ability to customize and refine their reports with ease. 

We’re also thrilled to announce a significant enhancement to the mobile reporting experience with the introduction of the pane manager for the mobile layout view. This innovative feature empowers users to effortlessly open and close panels via a dedicated menu, streamlining the design process of mobile reports. 

We recently announced a public preview for folders in workspaces, allowing you to create a hierarchical structure for organizing and managing your items. In the latest Desktop release, you can now publish your reports to specific folders in your workspace.  

When you publish a report, you can choose the specific workspace and folder for your report. The interface is simplistic and easy to understand, making organizing your Power BI content from Desktop better than ever. 

To publish reports to specific folders in the service, make sure the “Publish dialogs support folder selection” setting is enabled in the Preview features tab in the Options menu. 

Learn more about folders in workspaces.   

We’re excited to preview a new capability for Power BI Copilot allowing you to ask questions about the data in your model! You could already ask questions about the data present in the visuals on your report pages – and now you can go deeper by getting answers directly from the underlying model. Just ask questions about your data, and if the answer isn’t already on your report, Copilot will then query your model for the data instead and return the answer to your question in the form of a visual! 

We’re starting this capability off in both Edit and View modes in Power BI Service. Because this is a preview feature, you’ll need to enable it via the preview toggle in the Copilot pane. You can learn more about all the details of the feature in our announcement post here! (will link to announcement post)  

We are excited to announce the general availability of DAX query view. DAX query view is the fourth view in Power BI Desktop to run DAX queries on your semantic model.  

DAX query view comes with several ways to help you be as productive as possible with DAX queries. 

• Quick queries. Have the DAX query written for you from the context menu of tables, columns, or measures in the Data pane of DAX query view. Get the top 100 rows of a table, statistics of a column, or DAX formula of a measure to edit and validate in just a couple clicks! 
• DirectQuery model authors can also use DAX query view. View the data in your tables whenever you want! 
• Create and edit measures. Edit one or multiple measures at once. Make changes and see the change in action in a DA query. Then update the model when you are ready. All in DAX query view! 
• See the DAX query of visuals. Investigate the visuals DAX query in DAX query view. Go to the Performance Analyzer pane and choose “Run in DAX query view”. 
• Write DAX queries. You can create DAX queries with Intellisense, formatting, commenting/uncommenting, and syntax highlighting. And additional professional code editing experiences such as “Change all occurrences” and block folding to expand and collapse sections. Even expanded find and replace options with regex. 

Learn more about DAX query view with these resources: 

• Deep dive blog: https://powerbi.microsoft.com/blog/deep-dive-into-dax-query-view-and-writing-dax-queries/  
• Learn more: https://learn.microsoft.com/power-bi/transform-model/dax-query-view  
• Video: https://youtu.be/oPGGYLKhTOA?si=YKUp1j8GoHHsqdZo  

DAX query view includes an inline Fabric Copilot to write and explain DAX queries, which remains in public preview. This month we have made the following updates. 

• Run the DAX query before you keep it . Previously the Run button was disabled until the generated DAX query was accepted or Copilot was closed. Now you can Run the DAX query then decide to Keep or Discard the DAX query. 

2. Conversationally build the DAX query. Previously the DAX query generated was not considered if you typed additional prompts and you had to keep the DAX query, select it again, then use Copilot again to adjust. Now you can simply adjust by typing in additional user prompts.   

3. Syntax checks on the generated DAX query. Previously there was no syntax check before the generated DAX query was returned. Now the syntax is checked, and the prompt automatically retried once. If the retry is also invalid, the generated DAX query is returned with a note that there is an issue, giving you the option to rephrase your request or fix the generated DAX query. 

4. Inspire buttons to get you started with Copilot. Previously nothing happened until a prompt was entered. Now click any of these buttons to quickly see what you can do with Copilot! 

Learn more about DAX queries with Copilot with these resources: 

• Deep dive blog: https://powerbi.microsoft.com/en-us/blog/deep-dive-into-dax-query-view-with-copilot/  
• Learn more: https://learn.microsoft.com/en-us/dax/dax-copilot  
• Video: https://www.youtube.com/watch?v=0kE3TE34oLM  

We are excited to introduce you to the redesigned ‘Manage relationships’ dialog in Power BI Desktop! To open this dialog simply select the ‘Manage relationships’ button in the modeling ribbon.

Once opened, you’ll find a comprehensive view of all your relationships, along with their key properties, all in one convenient location. From here you can create new relationships or edit an existing one.

Additionally, you have the option to filter and focus on specific relationships in your model based on cardinality and cross filter direction. 

Learn more about creating and managing relationships in Power BI Desktop in our documentation . 

Ever since we released composite models on Power BI semantic models and Analysis Services , you have been asking us to support the refresh of calculated columns and tables in the Service. This month, we have enabled the refresh of calculated columns and tables in Service for any DirectQuery source that uses single sign-on authentication. This includes the sources you use when working with composite models on Power BI semantic models and Analysis Services.  

Previously, the refresh of a semantic model that uses a DirectQuery source with single-sign-on authentication failed with one of the following error messages: “Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery.” or “Refresh over a dataset with a calculated table or a calculated column which references a Direct Query data source is not supported.” 

Starting today, you can successfully refresh the calculated table and calculated columns in a semantic model in the Service using specific credentials as long as: 

• You used a shareable cloud connection and assigned it and/or.
• Enabled granular access control for all data connection types.

Here’s how to do this: 

• Create and publish your semantic model that uses a single sign-on DirectQuery source. This can be a composite model but doesn’t have to be. 
• In the semantic model settings, under Gateway and cloud connections , map each single sign-on DirectQuery connection to a specific connection. If you don’t have a specific connection yet, select ‘Create a connection’ to create it: 

• If you are creating a new connection, fill out the connection details and click Create , making sure to select ‘Use SSO via Azure AD for DirectQuery queries: 

• Finally, select the connection for each single sign-on DirectQuery source and select Apply : 

2. Either refresh the semantic model manually or plan a scheduled refresh to confirm the refresh now works successfully. Congratulations, you have successfully set up refresh for semantic models with a single sign-on DirectQuery connection that uses calculated columns or calculated tables!

We are excited to announce the general availability of Model Explorer in the Model view of Power BI, including the authoring of calculation groups. Semantic modeling is even easier with an at-a-glance tree view with item counts, search, and in context paths to edit the semantic model items with Model Explorer. Top level semantic model properties are also available as well as the option to quickly create relationships in the properties pane. Additionally, the styling for the Data pane is updated to Fluent UI also used in Office and Teams.  

A popular community request from the Ideas forum, authoring calculation groups is also included in Model Explorer. Calculation groups significantly reduce the number of redundant measures by allowing you to define DAX formulas as calculation items that can be applied to existing measures. For example, define a year over year, prior month, conversion, or whatever your report needs in DAX formula once as a calculation item and reuse it with existing measures. This can reduce the number of measures you need to create and make the maintenance of the business logic simpler.  

Available in both Power BI Desktop and when editing a semantic model in the workspace, take your semantic model authoring to the next level today!  

Learn more about Model Explorer and authoring calculation groups with these resources: 

• Use Model explorer in Power BI (preview) – Power BI | Microsoft Learn  
• Create calculation groups in Power BI (preview) – Power BI | Microsoft Learn  

Data connectivity  

We’re happy to announce that the Oracle database connector has been enhanced this month with the addition of Single Sign-On support in the Power BI service with Microsoft Entra ID authentication.  

Microsoft Entra ID SSO enables single sign-on to access data sources that rely on Microsoft Entra ID based authentication. When you configure Microsoft Entra SSO for an applicable data source, queries run under the Microsoft Entra identity of the user that interacts with the Power BI report. 

We’re pleased to announce the new and updated connectors in this release:   

• [New] OneStream : The OneStream Power BI Connector enables you to seamlessly connect Power BI to your OneStream applications by simply logging in with your OneStream credentials. The connector uses your OneStream security, allowing you to access only the data you have based on your permissions within the OneStream application. Use the connector to pull cube and relational data along with metadata members, including all their properties. Visit OneStream Power BI Connector to learn more. Find this connector in the other category. 
• [New] Zendesk Data : A new connector developed by the Zendesk team that aims to go beyond the functionality of the existing Zendesk legacy connector created by Microsoft. Learn more about what this new connector brings. 
• [New] CCH Tagetik 
• [Update] Azure Databricks  

Are you interested in creating your own connector and publishing it for your customers? Learn more about the Power Query SDK and the Connector Certification program .   

Last May, we announced the integration between Power BI and OneDrive and SharePoint. Previously, this capability was limited to only reports with data in import mode. We’re excited to announce that you can now seamlessly view Power BI reports with live connected data directly in OneDrive and SharePoint! 

When working on Power BI Desktop with a report live connected to a semantic model in the service, you can easily share a link to collaborate with others on your team and allow them to quickly view the report in their browser. We’ve made it easier than ever to access the latest data updates without ever leaving your familiar OneDrive and SharePoint environments. This integration streamlines your workflows and allows you to access reports within the platforms you already use. With collaboration at the heart of this improvement, teams can work together more effectively to make informed decisions by leveraging live connected semantic models without being limited to data only in import mode.  

Utilizing OneDrive and SharePoint allows you to take advantage of built-in version control, always have your files available in the cloud, and utilize familiar and simplistic sharing.  

While you told us that you appreciate the ability to limit the image view to only those who have permission to view the report, you asked for changes for the “Public snapshot” mode.   

To address some of the feedback we got from you, we have made a few more changes in this area.  

• Add-ins that were saved as “Public snapshot” can be printed and will not require that you go over all the slides and load the add-ins for permission check before the public image is made visible. 
• You can use the “Show as saved image” on add-ins that were saved as “Public snapshot”. This will replace the entire add-in with an image representation of it, so the load time might be faster when you are presenting your presentation. 

Many of us keep presentations open for a long time, which might cause the data in the presentation to become outdated.  

To make sure you have in your slides the data you need, we added a new notification that tells you if more up to date data exists in Power BI and offers you the option to refresh and get the latest data from Power BI. 

Developers 

Direct Lake semantic models are now supported in Fabric Git Integration , enabling streamlined version control, enhanced collaboration among developers, and the establishment of CI/CD pipelines for your semantic models using Direct Lake. 

Learn more about version control, testing, and deployment of Power BI content in our Power BI implementation planning documentation: https://learn.microsoft.com/power-bi/guidance/powerbi-implementation-planning-content-lifecycle-management-overview  

Visualizations 

Editor’s pick of the quarter .

– Animator for Power BI     Innofalls Charts     SuperTables     Sankey Diagram for Power BI by ChartExpo     Dynamic KPI Card by Sereviso     Shielded HTML Viewer     Text search slicer  

New visuals in AppSource 

Mapa Polski – Województwa, Powiaty, Gminy   Workstream   Income Statement Table  

Gas Detection Chart  

Seasonality Chart   PlanIn BI – Data Refresh Service  

Chart Flare  

PictoBar   ProgBar  

Counter Calendar   Donut Chart image  

Financial Reporting Matrix by Profitbase 

Making financial statements with a proper layout has just become easier with the latest version of the Financial Reporting Matrix. 

Users are now able to specify which rows should be classified as cost-rows, which will make it easier to get the conditional formatting of variances correctly: 

Selecting a row, and ticking “is cost” will tag the row as cost. This can be used in conditional formatting to make sure that positive variances on expenses are a bad for the result, while a positive variance on an income row is good for the result. 

The new version also includes more flexibility in measuring placement and column subtotals. 

Measures can be placed either: 

• Default (below column headers) 
• Above column headers 

• Conditionally hide columns 
• + much more 

Highlighted new features:  

• Measure placement – In rows  
• Select Column Subtotals  
• New Format Pane design 
• Row Options  

Get the visual from AppSource and find more videos here ! 

Horizon Chart by Powerviz  

A Horizon Chart is an advanced visual, for time-series data, revealing trends and anomalies. It displays stacked data layers, allowing users to compare multiple categories while maintaining data clarity. Horizon Charts are particularly useful to monitor and analyze complex data over time, making this a valuable visual for data analysis and decision-making. 

Key Features:  

• Horizon Styles: Choose Natural, Linear, or Step with adjustable scaling. 
• Layer: Layer data by range or custom criteria. Display positive and negative values together or separately on top. 
• Reference Line : Highlight patterns with X-axis lines and labels. 
• Colors: Apply 30+ color palettes and use FX rules for dynamic coloring. 
• Ranking: Filter Top/Bottom N values, with “Others”. 
• Gridline: Add gridlines to the X and Y axis.  
• Custom Tooltip: Add highest, lowest, mean, and median points without additional DAX. 
• Themes: Save designs and share seamlessly with JSON files. 

Other features included are ranking, annotation, grid view, show condition, and accessibility support.  

Business Use Cases: Time-Series Data Comparison, Environmental Monitoring, Anomaly Detection 

🔗 Try Horizon Chart for FREE from AppSource  

📊 Check out all features of the visual: Demo file  

📃 Step-by-step instructions: Documentation  

💡 YouTube Video: Video Link  

📍 Learn more about visuals: https://powerviz.ai/  

✅ Follow Powerviz : https://lnkd.in/gN_9Sa6U  

Exciting news! Thanks to your valuable feedback, we’ve enhanced our Milestone Trend Analysis Chart even further. We’re thrilled to announce that you can now switch between horizontal and vertical orientations, catering to your preferred visualization style.

The Milestone Trend Analysis (MTA) Chart remains your go-to tool for swiftly identifying deadline trends, empowering you to take timely corrective actions. With this update, we aim to enhance deadline awareness among project participants and stakeholders alike. 

In our latest version, we seamlessly navigate between horizontal and vertical views within the familiar Power BI interface. No need to adapt to a new user interface – enjoy the same ease of use with added flexibility. Plus, it benefits from supported features like themes, interactive selection, and tooltips. 

What’s more, ours is the only Microsoft Certified Milestone Trend Analysis Chart for Power BI, ensuring reliability and compatibility with the platform. 

Ready to experience the enhanced Milestone Trend Analysis Chart? Download it from AppSource today and explore its capabilities with your own data – try for free!  

We welcome any questions or feedback at our website: https://visuals.novasilva.com/ . Try it out and elevate your project management insights now! 

Sunburst Chart by Powerviz  

Powerviz’s Sunburst Chart is an interactive tool for hierarchical data visualization. With this chart, you can easily visualize multiple columns in a hierarchy and uncover valuable insights. The concentric circle design helps in displaying part-to-whole relationships. 

• Arc Customization: Customize shapes and patterns. 
• Color Scheme: Accessible palettes with 30+ options. 
• Centre Circle: Design an inner circle with layers. Add text, measure, icons, and images. 
• Conditional Formatting: Easily identify outliers based on measure or category rules. 
• Labels: Smart data labels for readability. 
• Image Labels: Add an image as an outer label. 
• Interactivity: Zoom, drill down, cross-filtering, and tooltip features. 

Other features included are annotation, grid view, show condition, and accessibility support.  

Business Use Cases:   

• Sales and Marketing: Market share analysis and customer segmentation. 
• Finance : Department budgets and expenditures distribution. 
• Operations : Supply chain management. 
• Education : Course structure, curriculum creation. 
• Human Resources : Organization structure, employee demographics.

🔗 Try Sunburst Chart for FREE from AppSource  

Stacked Bar Chart with Line by JTA  

Clustered bar chart with the possibility to stack one of the bars  

Stacked Bar Chart with Line by JTA seamlessly merges the simplicity of a traditional bar chart with the versatility of a stacked bar, revolutionizing the way you showcase multiple datasets in a single, cohesive display. 

Unlocking a new dimension of insight, our visual features a dynamic line that provides a snapshot of data trends at a glance. Navigate through your data effortlessly with multiple configurations, gaining a swift and comprehensive understanding of your information. 

Tailor your visual experience with an array of functionalities and customization options, enabling you to effortlessly compare a primary metric with the performance of an entire set. The flexibility to customize the visual according to your unique preferences empowers you to harness the full potential of your data. 

Features of Stacked Bar Chart with Line:  

• Stack the second bar 
• Format the Axis and Gridlines 
• Add a legend 
• Format the colors and text 
• Add a line chart 
• Format the line 
• Add marks to the line 
• Format the labels for bars and line 

If you liked what you saw, you can try it for yourself and find more information here . Also, if you want to download it, you can find the visual package on the AppSource . 

We have added an exciting new feature to our Combo PRO, Combo Bar PRO, and Timeline PRO visuals – Legend field support . The Legend field makes it easy to visually split series values into smaller segments, without the need to use measures or create separate series. Simply add a column with category names that are adjacent to the series values, and the visual will do the following:  

• Display separate segments as a stack or cluster, showing how each segment contributed to the total Series value. 
• Create legend items for each segment to quickly show/hide them without filtering.  
• Apply custom fill colors to each segment.  
• Show each segment value in the tooltip 

Read more about the Legend field on our blog article  

Drill Down Combo PRO is made for creators who want to build visually stunning and user-friendly reports. Cross-chart filtering and intuitive drill down interactions make data exploration easy and fun for any user. Furthermore, you can choose between three chart types – columns, lines, or areas; and feature up to 25 different series in the same visual and configure each series independently.  

📊 Get Drill Down Combo PRO on AppSource  

🌐 Visit Drill Down Combo PRO product page  

Documentation | ZoomCharts Website | Follow ZoomCharts on LinkedIn  

We are thrilled to announce that Fabric Core REST APIs are now generally available! This marks a significant milestone in the evolution of Microsoft Fabric, a platform that has been meticulously designed to empower developers and businesses alike with a comprehensive suite of tools and services. 

The Core REST APIs are the backbone of Microsoft Fabric, providing the essential building blocks for a myriad of functionalities within the platform. They are designed to improve efficiency, reduce manual effort, increase accuracy, and lead to faster processing times. These APIs help with scale operations more easily and efficiently as the volume of work grows, automate repeatable processes with consistency, and enable integration with other systems and applications, providing a streamlined and efficient data pipeline. 

The Microsoft Fabric Core APIs encompasses a range of functionalities, including: 

• Workspace management: APIs to manage workspaces, including permissions.  
• Item management: APIs for creating, reading, updating, and deleting items, with partial support for data source discovery and granular permissions management planned for the near future. 
• Job and tenant management: APIs to manage jobs, tenants, and users within the platform. 

These APIs adhere to industry standards and best practices, ensuring a unified developer experience that is both coherent and easy to use. 

For developers looking to dive into the details of the Microsoft Fabric Core APIs, comprehensive documentation is available. This includes guidelines on API usage, examples, and articles managed in a centralized repository for ease of access and discoverability. The documentation is continuously updated to reflect the latest features and improvements, ensuring that developers have the most current information at their fingertips. See Microsoft Fabric REST API documentation  

We’re excited to share an important update we made to the Fabric Admin APIs. This enhancement is designed to simplify your automation experience. Now, you can manage both Power BI and the new Fabric items (previously referred to as artifacts) using the same set of APIs. Before this enhancement, you had to navigate using two different APIs—one for Power BI items and another for new Fabric items. That’s no longer the case. 

The APIs we’ve updated include GetItem , ListItems , GetItemAccessDetails , and GetAccessEntities . These enhancements mean you can now query and manage all your items through a single API call, regardless of whether they’re Fabric types or Power BI types. We hope this update makes your work more straightforward and helps you accomplish your tasks more efficiently. 

We’re thrilled to announce the public preview of the Microsoft Fabric workload development kit. This feature now extends to additional workloads and offers a robust developer toolkit for designing, developing, and interoperating with Microsoft Fabric using frontend SDKs and backend REST APIs. Introducing the Microsoft Fabric Workload Development Kit . 

The Microsoft Fabric platform now provides a mechanism for ISVs and developers to integrate their new and existing applications natively into Fabric’s workload hub. This integration provides the ability to add net new capabilities to Fabric in a consistent experience without leaving their Fabric workspace, thereby accelerating data driven outcomes from Microsoft Fabric. 

By downloading and leveraging the development kit , ISVs and software developers can build and scale existing and new applications on Microsoft Fabric and offer them via the Azure Marketplace without the need to ever leave the Fabric environment. 

The development kit provides a comprehensive guide and sample code for creating custom item types that can be added to the Fabric workspace. These item types can leverage the Fabric frontend SDKs and backend REST APIs to interact with other Fabric capabilities, such as data ingestion, transformation, orchestration, visualization, and collaboration. You can also embed your own data application into the Fabric item editor using the Fabric native experience components, such as the header, toolbar, navigation pane, and status bar. This way, you can offer consistent and seamless user experience across different Fabric workloads. 

This is a call to action for ISVs, software developers, and system integrators. Let’s leverage this opportunity to create more integrated and seamless experiences for our users. 

We’re excited about this journey and look forward to seeing the innovative workloads from our developer community. 

We are proud to announce the public preview of external data sharing. Sharing data across organizations has become a standard part of day-to-day business for many of our customers. External data sharing, built on top of OneLake shortcuts, enables seamless, in-place sharing of data, allowing you to maintain a single copy of data even when sharing data across tenant boundaries. Whether you’re sharing data with customers, manufacturers, suppliers, consultants, or partners; the applications are endless. 

How external data sharing works  

Sharing data across tenants is as simple as any other share operation in Fabric. To share data, navigate to the item to be shared, click on the context menu, and then click on External data share . Select the folder or table you want to share and click Save and continue . Enter the email address and an optional message and then click Send . 

The data consumer will receive an email containing a share link. They can click on the link to accept the share and access the data within their own tenant. 

Click here for more details about external data sharing . 

Following the release of OneLake data access roles in public preview, the OneLake team is excited to announce the availability of APIs for managing data access roles. These APIs can be used to programmatically manage granular data access for your lakehouses. Manage all aspects of role management such as creating new roles, editing existing ones, or changing memberships in a programmatic way.  

Do you have data stored on-premises or behind a firewall that you want to access and analyze with Microsoft Fabric? With OneLake shortcuts, you can bring on-premises or network-restricted data into OneLake, without any data movement or duplication. Simply install the Fabric on-premises data gateway and create a shortcut to your S3 compatible, Amazon S3, or Google Cloud Storage data source. Then use any of Fabric’s powerful analytics engines and OneLake open APIs to explore, transform, and visualize your data in the cloud. 

Try it out today and unlock the full potential of your data with OneLake shortcuts! 

Data Warehouse 

We are excited to announce Copilot for Data Warehouse in public preview! Copilot for Data Warehouse is an AI assistant that helps developers generate insights through T-SQL exploratory analysis. Copilot is contextualized your warehouse’s schema. With this feature, data engineers and data analysts can use Copilot to: 

• Generate T-SQL queries for data analysis.  
• Explain and add in-line code comments for existing T-SQL queries. 
• Fix broken T-SQL code. 
• Receive answers regarding general data warehousing tasks and operations. 

There are 3 areas where Copilot is surfaced in the Data Warehouse SQL Query Editor: 

• Code completions when writing a T-SQL query. 
• Chat panel to interact with the Copilot in natural language. 
• Quick action buttons to fix and explain T-SQL queries. 

Learn more about Copilot for Data Warehouse: aka.ms/data-warehouse-copilot-docs. Copilot for Data Warehouse is currently only available in the Warehouse. Copilot in the SQL analytics endpoint is coming soon. 

Unlocking Insights through Time: Time travel in Data warehouse (public preview)

As data volumes continue to grow in today’s rapidly evolving world of Artificial Intelligence, it is crucial to reflect on historical data. It empowers businesses to derive valuable insights that aid in making well-informed decisions for the future. Preserving multiple historical data versions not only incurred significant costs but also presented challenges in upholding data integrity, resulting in a notable impact on query performance. So, we are thrilled to announce the ability to query the historical data through time travel at the T-SQL statement level which helps unlock the evolution of data over time. 

The Fabric warehouse retains historical versions of tables for seven calendar days. This retention allows for querying the tables as if they existed at any point within the retention timeframe. Time travel clause can be included in any top level SELECT statement. For complex queries that involve multiple tables, joins, stored procedures, or views, the timestamp is applied just once for the entire query instead of specifying the same timestamp for each table within the same query. This ensures the entire query is executed with reference to the specified timestamp, maintaining the data’s uniformity and integrity throughout the query execution. 

From historical trend analysis and forecasting to compliance management, stable reporting and real-time decision support, the benefits of time travel extend across multiple business operations. Embrace the capability of time travel to navigate the data-driven landscape and gain a competitive edge in today’s fast-paced world of Artificial Intelligence. 

We are excited to announce not one but two new enhancements to the Copy Into feature for Fabric Warehouse: Copy Into with Entra ID Authentication and Copy Into for Firewall-Enabled Storage!

Entra ID Authentication  

When authenticating storage accounts in your environment, the executing user’s Entra ID will now be used by default. This ensures that you can leverage A ccess C ontrol L ists and R ole – B ased a ccess c ontrol to authenticate to your storage accounts when using Copy Into. Currently, only organizational accounts are supported.  

How to Use Entra ID Authentication  

• Ensure your Entra ID organizational account has access to the underlying storage and can execute the Copy Into statement on your Fabric Warehouse.  
• Run your Copy Into statement without specifying any credentials; the Entra ID organizational account will be used as the default authentication mechanism.  

Copy into firewall-enabled storage

The Copy Into for firewall-enabled storage leverages the trusted workspace access functionality ( Trusted workspace access in Microsoft Fabric (preview) – Microsoft Fabric | Microsoft Learn ) to establish a secure and seamless connection between Fabric and your storage accounts. Secure access can be enabled for both blob and ADLS Gen2 storage accounts. Secure access with Copy Into is available for warehouses in workspaces with Fabric Capacities (F64 or higher).  

To learn more about Copy into , please refer to COPY INTO (Transact-SQL) – Azure Synapse Analytics and Microsoft Fabric | Microsoft Learn  

We are excited to announce the launch of our new feature, Just in Time Database Attachment, which will significantly enhance your first experience, such as when connecting to the Datawarehouse or SQL endpoint or simply opening an item. These actions trigger the workspace resource assignment process, where, among other actions, we attach all necessary metadata of your items, Data warehouses and SQL endpoints, which can be a long process, particularly for workspaces that have a high number of items.  

This feature is designed to attach your desired database during the activation process of your workspace, allowing you to execute queries immediately and avoid unnecessary delays. However, all other databases will be attached asynchronously in the background while you are able to execute queries, ensuring a smooth and efficient experience. 

Data Engineering 

We are advancing Fabric Runtime 1.3 from an Experimental Public Preview to a full Public Preview. Our Apache Spark-based big data execution engine, optimized for both data engineering and science workflows, has been updated and fully integrated into the Fabric platform. 

The enhancements in Fabric Runtime 1.3 include the incorporation of Delta Lake 3.1, compatibility with Python 3.11, support for Starter Pools, integration with Environment and library management capabilities. Additionally, Fabric Runtime now enriches the data science experience by supporting the R language and integrating Copilot. 

We are pleased to share that the Native Execution Engine for Fabric Runtime 1.2 is currently available in public preview. The Native Execution Engine can greatly enhance the performance for your Spark jobs and queries. The engine has been rewritten in C++ and operates in columnar mode and uses vectorized processing. The Native Execution Engine offers superior query performance – encompassing data processing, ETL, data science, and interactive queries – all directly on your data lake. Overall, Fabric Spark delivers a 4x speed-up on the sum of execution time of all 99 queries in the TPC-DS 1TB benchmark when compared against Apache Spark.  This engine is fully compatible with Apache Spark™ APIs (including Spark SQL API). 

It is seamless to use with no code changes – activate it and go. Enable it in your environment for your notebooks and your SJDs. 

This feature is in the public preview, at this stage of the preview, there is no additional cost associated with using it. 

We are excited to announce the Spark Monitoring Run Series Analysis features, which allow you to analyze the run duration trend and performance comparison for Pipeline Spark activity recurring run instances and repetitive Spark run activities from the same Notebook or Spark Job Definition.   

• Run Series Comparison: Users can compare the duration of a Notebook run with that of previous runs and evaluate the input and output data to understand the reasons behind prolonged run durations.  
• Outlier Detection and Analysis: The system can detect outliers in the run series and analyze them to pinpoint potential contributing factors. 
• Detailed Run Instance Analysis: Clicking on a specific run instance provides detailed information on time distribution, which can be used to identify performance enhancement opportunities. 
• Configuration Insights : Users can view the Spark configuration used for each run, including auto-tuned configurations for Spark SQL queries in auto-tune enabled Notebook runs. 

You can access the new feature from the item’s recent runs panel and Spark application monitoring page. 

We are excited to announce that Notebook now supports the ability to tag others in comments, just like the familiar functionality of using Office products!   

When you select a section of code in a cell, you can add a comment with your insights and tag one or more teammates to collaborate or brainstorm on the specifics. This intuitive enhancement is designed to amplify collaboration in your daily development work. 

Moreover, you can easily configure the permissions when tagging someone who doesn’t have the permission, to make sure your code asset is well managed. 

We are thrilled to unveil a significant enhancement to the Fabric notebook ribbon, designed to elevate your data science and engineering workflows. 

In the new version, you will find the new Session connect control on the Home tab, and now you can start a standard session without needing to run a code cell. 

You can also easily spin up a High concurrency session and share the session across multiple notebooks to improve the compute resource utilization. And you can easily attach/leave a high concurrency session with a single click. 

The “ View session information ” can navigate you to the session information dialog, where you can find a lot of useful detailed information, as well as configure the session timeout. The diagnostics info is essentially helpful when you need support for notebook issues. 

Now you can easily access the powerful “ Data Wrangler ” on Home tab with the new ribbon! You can explore your data with the fancy low-code experience of data wrangler, and the pandas DataFrames and Spark DataFrames are all supported.   

We recently made some changes to the Fabric notebook metadata to ensure compliance and consistency: 

Notebook file content: 

• The keyword “trident” has been replaced with “dependencies” in the notebook content. This adjustment ensures consistency and compliance. 
• Notebook Git format: 
• The preface of the notebook has been modified from “# Synapse Analytics notebook source” to “# Fabric notebook source”. 
• Additionally, the keyword “synapse” has been updated to “dependencies” in the Git repo. 

The above changes will be marked as ‘uncommitted’ for one time if your workspace is connected to Git. No action is needed in terms of these changes , and there won’t be any breaking scenario within the Fabric platform . If you have any further updates or questions, feel free to share with us. 

We are thrilled to announce that the environment is now a generally available item in Microsoft Fabric. During this GA timeframe, we have shipped a few new features of Environment. 

• Git support  

The environment is now Git supported. You can check-in the environment into your Git repo and manipulate the environment locally with its YAML representations and custom library files. After updating the changes from local to Fabric portal, you can publish them by manual action or through REST API. 

• Deployment pipeline  

Deploying environments from one workspace to another is supported.  Now, you can deploy the code items and their dependent environments together from development to test and even production. 

With the REST APIs, you can have the code-first experience with the same abilities through Fabric portal. We provide a set of powerful APIs to ensure you the efficiency in managing your environment. You can create new environments, update libraries and Spark compute, publish the changes, delete an environment, attach the environment to a notebook, etc., all actions can be done locally in the tools of your choice. The article – Best practice of managing environments with REST API could help you get started with several real-world scenarios.  

• Resources folder   

Resources folder enables managing small resources in the development cycle. The files uploaded in the environment can be accessed from notebooks once they’re attached to the same environment. The manipulation of the files and folders of resources happens in real-time. It could be super powerful, especially when you are collaborating with others. 

Sharing your environment with others is also available. We provide several sharing options. By default, the view permission is shared. If you want the recipient to have access to view and use the contents of the environment, sharing without permission customization is the best option. Furthermore, you can grant editing permission to allow recipients to update this environment or grant share permission to allow recipients to reshare this environment with their existing permissions. 

We are excited to announce the REST api support for Fabric Data Engineering/Science workspace settings.  Data Engineering/Science settings allows users to create/manage their Spark compute, select the default runtime/default environment, enable or disable high concurrency mode or ML autologging.  

Now with the REST api support for the Data Engineering/Science settings, you would be able to  

• Choose the default pool for a Fabric Workspace 
• Configure the max nodes for Starter pools 
• Create/Update/Delete the existing Custom Pools, Autoscale and Dynamic allocation properties  
• Choose Workspace Default Runtime and Environment  
• Select a default runtime 
• Select the default environment for the Fabric workspace  
• Enable or Disable High Concurrency Mode 
• Enable or Disable ML Auto logging.  

Learn more about the Workspace Spark Settings API in our API documentation Workspace Settings – REST API (Spark) | Microsoft Learn  

We are excited to give you a sneak peek at the preview of User Data Functions in Microsoft Fabric. User Data Functions gives developers and data engineers the ability to easily write and run applications that integrate with resources in the Fabric Platform. Data engineering often presents challenges with data quality or complex data analytics processing in data pipelines, and using ETL tools may present limited flexibility and ability to customize to your needs. This is where User data functions can be used to run data transformation tasks and perform complex business logic by connecting to your data sources and other workloads in Fabric.  

During preview, you will be able to use the following features:  

• Use the Fabric portal to create new User Data Functions, view and test them.  
• Write your functions using C#.   
• Use the Visual Studio Code extension to create and edit your functions.  
• Connect to the following Fabric-native data sources: Data Warehouse, Lakehouse and Mirrored Databases.   

You can now create a fully managed GraphQL API in Fabric to interact with your data in a simple, flexible, and powerful way. We’re excited to announce the public preview of API for GraphQL, a data access layer that allows us to query multiple data sources quickly and efficiently in Fabric by leveraging a widely adopted and familiar API technology that returns more data with less client requests.  With the new API for GraphQL in Fabric, data engineers and scientists can create data APIs to connect to different data sources, use the APIs in their workflows, or share the API endpoints with app development teams to speed up and streamline data analytics application development in your business. 

You can get started with the API for GraphQL in Fabric by creating an API, attaching a supported data source, then selecting specific data sets you want to expose through the API. Fabric builds the GraphQL schema automatically based on your data, you can test and prototype queries directly in our graphical in-browser GraphQL development environment (API editor), and applications are ready to connect in minutes. 

Currently, the following supported data sources can be exposed through the Fabric API for GraphQL: 

• Microsoft Fabric Data Warehouse 
• Microsoft Fabric Lakehouse via SQL Analytics Endpoint 
• Microsoft Fabric Mirrored Databases via SQL Analytics Endpoint 

Click here to learn more about how to get started. 

Data Science 

As you may know, Copilot in Microsoft Fabric requires your tenant administrator to enable the feature from the admin portal. Starting May 20th, 2024, Copilot in Microsoft Fabric will be enabled by default for all tenants. This update is part of our continuous efforts to enhance user experience and productivity within Microsoft Fabric. This new default activation means that AI features like Copilot will be automatically enabled for tenants who have not yet enabled the setting.  

We are introducing a new capability to enable Copilot on Capacity level in Fabric. A new option is being introduced in the tenant admin portal, to delegate the enablement of AI and Copilot features to Capacity administrators.  This AI and Copilot setting will be automatically delegated to capacity administrators and tenant administrators won’t be able to turn off the delegation.   

We also have a cross-geo setting for customers who want to use Copilot and AI features while their capacity is in a different geographic region than the EU data boundary or the US. By default, the cross-geo setting will stay off and will not be delegated to capacity administrators automatically.  Tenant administrators can choose whether to delegate this to capacity administrators or not. 

Figure 1.  Copilot in Microsoft Fabric will be auto enabled and auto delegated to capacity administrators. 

Capacity administrators will see the “Copilot and Azure OpenAI Service (preview)” settings under Capacity settings/ Fabric Capacity / <Capacity name> / Delegated tenant settings. By default, the capacity setting will inherit tenant level settings. Capacity administrators can decide whether to override the tenant administrator’s selection. This means that even if Copilot is not enabled on a tenant level, a capacity administrator can choose to enable Copilot for their capacity. With this level of control, we make it easier to control which Fabric workspaces can utilize AI features like Copilot in Microsoft Fabric. 

To enhance privacy and trust, we’ve updated our approach to abuse monitoring: previously, we retained data from Copilot in Fabric, including prompt inputs and outputs, for up to 30 days to check for misuse. Following customer feedback, we’ve eliminated this 30-day retention. Now, we no longer store prompt related data, demonstrating our unwavering commitment to your privacy and security. We value your input and take your concerns seriously. 

Real-Time Intelligence 

This month includes the announcement of Real-Time Intelligence, the next evolution of Real-Time Analytics and Data Activator. With Real-Time Intelligence, Fabric extends to the world of streaming and high granularity data, enabling all users in your organization to collect, analyze and act on this data in a timeline manner making faster and more informed business decisions. Read the full announcement from Build 2024. 

Real-Time Intelligence includes a wide range of capabilities across ingestion, processing, analysis, transformation, visualization and taking action. All of this is supported by the Real-Time hub, the central place to discover and manage streaming data and start all related tasks.  

Read on for more information on each capability and stay tuned for a series of blogs describing the features in more detail. All features are in Public Preview unless otherwise specified. Feedback on any of the features can be submitted at https://aka.ms/rtiidea    

Ingest & Process  

• Introducing the Real-Time hub 
• Get Events with new sources of streaming and event data 
• Source from Real-Time Hub in Enhanced Eventstream  
• Use Real-Time hub to Get Data in KQL Database in Eventhouse 
• Get data from Real-Time Hub within Reflexes 
• Eventstream Edit and Live modes 
• Default and derived streams 
• Route data streams based on content 

Analyze & Transform  

• Eventhouse GA 
• Eventhouse OneLake availability GA 
• Create a database shortcut to another KQL Database 
• Support for AI Anomaly Detector  
• Copilot for Real-Time Intelligence 
• Tenant-level private endpoints for Eventhouse 

Visualize & Act  

• Visualize data with Real-Time Dashboards  
• New experience for data exploration 
• Create triggers from Real-Time Hub 
• Set alert on Real-time Dashboards 
• Taking action through Fabric Items 

Ingest & Process 

Real-Time hub is the single place for all data-in-motion across your entire organization. Several key features are offered in Real-Time hub: 

1. Single place for data-in-motion for the entire organization  

Real-Time hub enables users to easily discover, ingest, manage, and consume data-in-motion from a wide variety of sources. It lists all the streams and KQL tables that customers can directly act on. 

2. Real-Time hub is never empty  

All data streams in Fabric automatically show up in the hub. Also, users can subscribe to events in Fabric gaining insights into the health and performance of their data ecosystem. 

3. Numerous connectors to simplify data ingestion from anywhere to Real-Time hub  

Real-Time hub makes it easy for you to ingest data into Fabric from a wide variety of sources like AWS Kinesis, Kafka clusters, Microsoft streaming sources, sample data and Fabric events using the Get Events experience.  

There are 3 tabs in the hub:  

• Data streams : This tab contains all streams that are actively running in Fabric that user has access to. This includes all streams from Eventstreams and all tables from KQL Databases. 
• Microsoft sources : This tab contains Microsoft sources (that user has access to) and can be connected to Fabric. 
• Fabric events : Fabric now has event-driven capabilities to support real-time notifications and data processing. Users can monitor and react to events including Fabric Workspace Item events and Azure Blob Storage events. These events can be used to trigger other actions or workflows, such as invoking a data pipeline or sending a notification via email. Users can also send these events to other destinations via Event Streams. 

Learn More  

You can now connect to data from both inside and outside of Fabric in a mere few steps.  Whether data is coming from new or existing sources, streams, or available events, the Get Events experience allows users to connect to a wide range of sources directly from Real-Time hub, Eventstreams, Eventhouse and Data Activator.  

This enhanced capability allows you to easily connect external data streams into Fabric with out-of-box experience, giving you more options and helping you to get real-time insights from various sources. This includes Camel Kafka connectors powered by Kafka connect to access popular data platforms, as well as the Debezium connectors for fetching the Change Data Capture (CDC) streams. 

Using Get Events, bring streaming data from Microsoft sources directly into Fabric with a first-class experience.  Connectivity to notification sources and discrete events is also included, this enables access to notification events from Azure and other clouds solutions including AWS and GCP.  The full set of sources which are currently supported are: 

• Microsoft sources : Azure Event Hubs, Azure IoT hub 
• External sources : Google Cloud Pub/Sub, Amazon Kinesis Data Streams, Confluent Cloud Kafka 
• Change data capture databases : Azure SQL DB (CDC), PostgreSQL DB (CDC), Azure Cosmos DB (CDC), MySQL DB (CDC)  
• Fabric events : Fabric Workspace Item events, Azure Blob Storage events  

Learn More   

With enhanced Eventstream, you can now stream data not only from Microsoft sources but also from other platforms like Google Cloud, Amazon Kinesis, Database change data capture streams, etc. using our new messaging connectors. The new Eventstream also lets you acquire and route real-time data not only from stream sources but also from discrete event sources, such as: Azure Blob Storage events, Fabric Workspace Item events. 

To use these new sources in Eventstream, simply create an eventstream with choosing “Enhanced Capabilities (preview)”. 

You will see the new Eventstream homepage that gives you some choices to begin with. By clicking on the “Add external source”, you will find these sources in the Get events wizard that helps you to set up the source in a few steps. After you add the source to your eventstream, you can publish it to stream the data into your eventstream.  

Using Eventstream with discrete sources to turn events into streams for more analysis. You can send the streams to different Fabric data destinations, like Lakehouse and KQL Database. After the events are converted, a default stream will appear in Real-Time Hub. To turn them, click Edit on ribbon, select “Stream events” on the source node, and publish your eventstream. 

To transform the stream data or route it to different Fabric destinations based on its content, you can click Edit in ribbon and enter the Edit mode. There you can add event processing operators and destinations. 

With Real-Time hub embedded in KQL Database experience, each user in the tenant can view and add streams which they have access to and directly ingest it to a KQL Database table in Eventhouse.  

This integration provides each user in the tenant with the ability to access and view data streams they are permitted to. They can now directly ingest these streams into a KQL Database table in Eventhouse. This simplifies the data discovery and ingestion process by allowing users to directly interact with the streams. Users can filter data based on the Owner, Parent and Location and provides additional information such as Endorsement and Sensitivity. 

You can access this by clicking on the Get Data button from the Database ribbon in Eventhouse. 

This will open the Get Data wizard with Real-Time hub embedded. 

You can use events from Real-Time hub directly in reflex items as well. From within the main reflex UI, click ‘Get data’ in the toolbar: 

This will open a wizard that allows you to connect to new event sources or browse Real-Time Hub to use existing streams or system events. 

Search new stream sources to connect to or select existing streams and tables to be ingested directly by Reflex. 

You then have access to the full reflex modeling experience to build properties and triggers over any events from Real-Time hub.  

Eventstream offers two distinct modes, Edit and Live, to provide flexibility and control over the development process of your eventstream. If you create a new Eventstream with Enhanced Capabilities enabled, you can modify it in an Edit mode. Here, you can design stream processing operations for your data streams using a no-code editor. Once you complete the editing, you can publish your Eventstream and visualize how it starts streaming and processing data in Live mode .   

In Edit mode, you can:   

• Make changes to an Eventstream without implementing them until you publish the Eventstream. This gives you full control over the development process.  
• Avoid test data being streamed to your Eventstream. This mode is designed to provide a secure environment for testing without affecting your actual data streams. 

For Live mode, you can :  

• Visualize how your Eventstream streams, transforms, and routes your data streams to various destinations after publishing the changes.  
• Pause the flow of data on selected sources and destinations, providing you with more control over your data streams being streamed into your Eventstream.  

When you create a new Eventstream with Enhanced Capabilities enabled, you can now create and manage multiple data streams within Eventstream, which can then be displayed in the Real-Time hub for others to consume and perform further analysis.  

There are two types of streams:   

• Default stream : Automatically generated when a streaming source is added to Eventstream. Default stream captures raw event data directly from the source, ready for transformation or analysis.  
• Derived stream : A specialized stream that users can create as a destination within Eventstream. Derived stream can be created after a series of operations such as filtering and aggregating, and then it’s ready for further consumption or analysis by other users in the organization through the Real-Time Hub.  

The following example shows that when creating a new Eventstream a default stream alex-es1-stream is automatically generated. Subsequently, a derived stream dstream1 is added after an Aggregate operation within the Eventstream. Both default and derived streams can be found in the Real-Time hub.  

Customers can now perform stream operations directly within Eventstream’s Edit mode, instead of embedding in a destination. This enhancement allows you to design stream processing logics and route data streams in the top-level canvas. Custom processing and routing can be applied to individual destinations using built-in operations, allowing for routing to distinct destinations within the Eventstream based on different stream content. 

These operations include:  

• Aggregate : Perform calculations such as SUM, AVG, MIN, and MAX on a column of values and return a single result. 
• Expand : Expand array values and create new rows for each element within the array.  
• Filter : Select or filter specific rows from the data stream based on a condition. 
• Group by : Aggregate event data within a certain time window, with the option to group one or more columns.  
• Manage Fields : Customize your data streams by adding, removing, or changing data type of a column.  
• Union : Merge two or more data streams with shared fields (same name and data type) into a unified data stream.  

Analyze & Transform 

Eventhouse, a cutting-edge database workspace meticulously crafted to manage and store event-based data, is now officially available for general use. Optimized for high granularity, velocity, and low latency streaming data, it incorporates indexing and partitioning for structured, semi-structured, and free text data. With Eventhouse, users can perform high-performance analysis of big data and real-time data querying, processing billions of events within seconds. The platform allows users to organize data into compartments (databases) within one logical item, facilitating efficient data management.  

Additionally, Eventhouse enables the sharing of compute and cache resources across databases, maximizing resource utilization. It also supports high-performance queries across databases and allows users to apply common policies seamlessly. Eventhouse offers content-based routing to multiple databases, full view lineage, and high granularity permission control, ensuring data security and compliance. Moreover, it provides a simple migration path from Azure Synapse Data Explorer and Azure Data Explorer, making adoption seamless for existing users. 

Engineered to handle data in motion, Eventhouse seamlessly integrates indexing and partitioning into its storing process, accommodating various data formats. This sophisticated design empowers high-performance analysis with minimal latency, facilitating lightning-fast ingestion and querying within seconds. Eventhouse is purpose-built to deliver exceptional performance and efficiency for managing event-based data across diverse applications and industries. Its intuitive features and seamless integration with existing Azure services make it an ideal choice for organizations looking to leverage real-time analytics for actionable insights. Whether it’s analyzing telemetry and log data, time series and IoT data, or financial records, Eventhouse provides the tools and capabilities needed to unlock the full potential of event-based data. 

We’re excited to announce that OneLake availability of Eventhouse in Delta Lake format is Generally Available. 

Delta Lake  is the unified data lake table format chosen to achieve seamless data access across all compute engines in Microsoft Fabric. 

The data streamed into Eventhouse is stored in an optimized columnar storage format with full text indexing and supports complex analytical queries at low latency on structured, semi-structured, and free text data. 

Enabling data availability of Eventhouse in OneLake means that customers can enjoy the best of both worlds: they can query the data with high performance and low latency in their  Eventhouse and query the same data in Delta Lake format via any other Fabric engines such as Power BI Direct Lake mode, Warehouse, Lakehouse, Notebooks, and more. 

To learn more, please visit https://learn.microsoft.com/en-gb/fabric/real-time-analytics/one-logical-copy 

A database shortcut in Eventhouse is an embedded reference to a source database. The source database can be one of the following: 

• (Now Available) A KQL Database in Real-Time Intelligence  
• An Azure Data Explorer database  

The behavior exhibited by the database shortcut is similar to that of a follower database  

The owner of the source database, the data provider, shares the database with the creator of the shortcut in Real-Time Intelligence, the data consumer. The owner and the creator can be the same person. The database shortcut is attached in read-only mode, making it possible to view and run queries on the data that was ingested into the source KQL Database without ingesting it.  

This helps with data sharing scenarios where you can share data in-place either within teams, or even with external customers.  

AI Anomaly Detector is an Azure service for high quality detection of multivariate and univariate anomalies in time series. While the standalone version is being retired October 2026, Microsoft open sourced the anomaly detection core algorithms and they are now supported in Microsoft Fabric. Users can leverage these capabilities in Data Science and Real-Time Intelligence workload. AI Anomaly Detector models can be trained in Spark Python notebooks in Data Science workload, while real time scoring can be done by KQL with inline Python in Real-Time Intelligence. 

We are excited to announce the Public Preview of Copilot for Real-Time Intelligence. This initial version includes a new capability that translates your natural language questions about your data to KQL queries that you can run and get insights.  

Your starting point is a KQL Queryset, that is connected to a KQL Database, or to a standalone Kusto database:  

Simply type the natural language question about what you want to accomplish, and Copilot will automatically translate it to a KQL query you can execute. This is extremely powerful for users who may be less familiar with writing KQL queries but still want to get the most from their time-series data stored in Eventhouse. 

Stay tuned for more capabilities from Copilot for Real-Time Intelligence!   

Customers can increase their network security by limiting access to Eventhouse at a tenant-level, from one or more virtual networks (VNets) via private links. This will prevent unauthorized access from public networks and only permit data plane operations from specific VNets.  

Visualize & Act 

Real-Time Dashboards have a user-friendly interface, allowing users to quickly explore and analyze their data without the need for extensive technical knowledge. They offer a high refresh frequency, support a range of customization options, and are designed to handle big data.  

The following visual types are supported, and can be customized with the dashboard’s user-friendly interface: 

You can also define conditional formatting rules to format the visual data points by their values using colors, tags, and icons. Conditional formatting can be applied to a specific set of cells in a predetermined column or to entire rows, and lets you easily identify interesting data points. 

Beyond the support visual, Real-Time Dashboards provide several capabilities to allow you to interact with your data by performing slice and dice operations for deeper analysis and gaining different viewpoints. 

• Parameters are used as building blocks for dashboard filters and can be added to queries to filter the data presented by visuals. Parameters can be used to slice and dice dashboard visuals either directly by selecting parameter values in the filter bar or by using cross-filters. 
• Cross filters allow you to select a value in one visual and filter all other visuals on that dashboard based on the selected data point. 
• Drillthrough capability allows you to select a value in a visual and use it to filter the visuals in a target page in the same dashboard. When the target page opens, the value is pushed to the relevant filters.    

Real-Time Dashboards can be shared broadly and allow multiple stakeholders to view dynamic, real time, fresh data while easily interacting with it to gain desired insights. 

Directly from a real-time dashboard, users can refine their exploration using a user-friendly, form-like interface. This intuitive and dynamic experience is tailored for insights explorers craving insights based on real-time data. Add filters, create aggregations, and switch visualization types without writing queries to easily uncover insights.  

With this new feature, insights explorers are no longer bound by the limitations of pre-defined dashboards. As independent explorers, they have the freedom for ad-hoc exploration, leveraging existing tiles to kickstart their journey. Moreover, they can selectively remove query segments, and expand their view of the data landscape.  

Dive deep, extract meaningful insights, and chart actionable paths forward, all with ease and efficiency, and without having to write complex KQL queries.  

Data Activator allows you to monitor streams of data for various conditions and set up actions to be taken in response. These triggers are available directly within the Real-Time hub and in other workloads in Fabric. When the condition is detected, an action will automatically be kicked off such as sending alerts via email or Teams or starting jobs in Fabric items.  

When you browse the Real-Time Hub, you’ll see options to set triggers in the detail pages for streams. 

Selecting this will open a side panel where you can configure the events you want to monitor, the conditions you want to look for in the events, and the action you want to take while in the Real-Time hub experience. 

Completing this pane creates a new reflex item with a trigger that monitors the selected events and condition for you. Reflexes need to be created in a workspace supported by a Fabric or Power BI Premium capacity – this can be a trial capacity so you can get started with it today! 

Data Activator has been able to monitor Power BI report data since it was launched, and we now support monitoring of Real-Time Dashboard visuals in the same way.

From real-time dashboard tiles you can click the ellipsis (…) button and select “Set alert”

This opens the embedded trigger pane, where you can specify what conditions, you are looking for. You can choose whether to send email or Teams messages as the alert when these conditions are met.

When creating a new reflex trigger, from Real-time Hub or within the reflex item itself, you’ll notice a new ‘Run a Fabric item’ option in the Action section. This will create a trigger that starts a new Fabric job whenever its condition is met, kicking off a pipeline or notebook computation in response to Fabric events. A common scenario would be monitoring Azure Blob storage events via Real-Time Hub, and running data pipeline jobs when Blog Created events are detected. 

This capability is extremely powerful and moves Fabric from a scheduled driven platform to an event driven platform.  

Pipelines, spark jobs, and notebooks are just the first Fabric items we’ll support here, and we’re keen to hear your feedback to help prioritize what else we support. Please leave ideas and votes on https://aka.ms/rtiidea and let us know! 

Real-Time Intelligence, along with the Real-Time hub, revolutionizes what’s possible with real-time streaming and event data within Microsoft Fabric.  

Learn more and try it today https://aka.ms/realtimeintelligence   

Data Factory 

Dataflow gen2 .

We are thrilled to announce that the Power Query SDK is now generally available in Visual Studio Code! This marks a significant milestone in our commitment to providing developers with powerful tools to enhance data connectivity and transformation. 

The Power Query SDK is a set of tools that allow you as the developer to create new connectors for Power Query experiences available in products such as Power BI Desktop, Semantic Models, Power BI Datamarts, Power BI Dataflows, Fabric Dataflow Gen2 and more. 

This new SDK has been in public preview since November of 2022, and we’ve been hard at work improving this experience which goes beyond what the previous Power Query SDK in Visual Studio had to offer.  

The latest of these biggest improvements was the introduction of the Test Framework in March of 2024 that solidifies the developer experience that you can have within Visual Studio Code and the Power Query SDK for creating a Power Query connector. 

The Power Query SDK extension for Visual Studio will be deprecated by June 30, 2024, so we encourage you to give this new Power Query SDK in Visual Studio Code today if you haven’t.  

To get started with the Power Query SDK in Visual Studio Code, simply install it from the Visual Studio Code Marketplace . Our comprehensive documentation and tutorials are available to help you harness the full potential of your data. 

Join our vibrant community of developers to share insights, ask questions, and collaborate on exciting projects. Our dedicated support team is always ready to assist you with any queries. 

We look forward to seeing the innovative solutions you’ll create with the Power Query SDK in Visual Studio Code. Happy coding! 

Introducing a convenient enhancement to the Dataflows Gen2 Refresh History experience! Now, alongside the familiar “X” button in the Refresh History screen, you’ll find a shiny new Refresh Button . This small but mighty addition empowers users to refresh the status of their dataflow refresh history status without the hassle of exiting the refresh history and reopening it. Simply click the Refresh Button , and voilà! Your dataflow’s refresh history status screen is updated, keeping you in the loop with minimal effort. Say goodbye to unnecessary clicks and hello to streamlined monitoring! 

• [New] OneStream : The OneStream Power Query Connector enables you to seamlessly connect Data Factory to your OneStream applications by simply logging in with your OneStream credentials. The connector uses your OneStream security, allowing you to access only the data you have based on your permissions within the OneStream application. Use the connector to pull cube and relational data along with metadata members, including all their properties. Visit OneStream Power BI Connector to learn more. Find this connector in the other category. 

Data workflows  

We are excited to announce the preview of ‘Data workflows’, a new feature within the Data Factory that revolutionizes the way you build and manage your code-based data pipelines. Powered by Apache Airflow, Data workflows offer seamless authoring, scheduling, and monitoring experience for Python-based data processes defined as Directed Acyclic Graphs (DAGs). This feature brings a SaaS-like experience to running DAGs in a fully managed Apache Airflow environment, with support for autoscaling , auto-pause , and rapid cluster resumption to enhance cost-efficiency and performance.  

It also includes native cloud-based authoring capabilities and comprehensive support for Apache Airflow plugins and libraries. 

To begin using this feature: 

• Access the Microsoft Fabric Admin Portal. 
• Navigate to Tenant Settings. 

Under Microsoft Fabric options, locate and expand the ‘Users can create and use Data workflows (preview)’ section. Note: This action is necessary only during the preview phase of Data workflows. 

2. Create a new Data workflow within an existing or new workspace. 

3. Add a new Directed Acyclic Graph (DAG) file via the user interface. 

4.  Save your DAG(s). 

5. Use Apache Airflow monitoring tools to observe your DAG executions. In the ribbon, click on Monitor in Apache Airflow. 

For additional information, please consult the product documentation .   If you’re not already using Fabric capacity, consider signing up for the Microsoft Fabric free trial to evaluate this feature. 

Data Pipelines 

We are excited to announce a new feature in Fabric that enables you to create data pipelines to access your firewall-enabled Azure Data Lake Storage Gen2 (ADLS Gen2) accounts. This feature leverages the workspace identity to establish a secure and seamless connection between Fabric and your storage accounts. 

With trusted workspace access, you can create data pipelines to your storage accounts with just a few clicks. Then you can copy data into Fabric Lakehouse and start analyzing your data with Spark, SQL, and Power BI. Trusted workspace access is available for workspaces in Fabric capacities (F64 or higher). It supports organizational accounts or service principal authentication for storage accounts. 

How to use trusted workspace access in data pipelines  

Create a workspace identity for your Fabric workspace. You can follow the guidelines provided in Workspace identity in Fabric . 

Configure resource instance rules for the Storage account that you want to access from your Fabric workspace. Resource instance rules for Fabric workspaces can only be created through ARM templates. Follow the guidelines for configuring resource instance rules for Fabric workspaces here . 

Create a data pipeline to copy data from the firewall enabled ADLS gen2 account to a Fabric Lakehouse. 

To learn more about how to use trusted workspace access in data pipelines, please refer to Trusted workspace access in Fabric . 

We hope you enjoy this new feature for your data integration and analytics scenarios. Please share your feedback and suggestions with us by leaving a comment here. 

Introducing Blob Storage Event Triggers for Data Pipelines 

A very common use case among data pipeline users in a cloud analytics solution is to trigger your pipeline when a file arrives or is deleted. We have introduced Azure Blob storage event triggers as a public preview feature in Fabric Data Factory Data Pipelines. This utilizes the Fabric Reflex alerts capability that also leverages Event Streams in Fabric to create event subscriptions to your Azure storage accounts. 

Parent/Child pipeline pattern monitoring improvements

Today, in Fabric Data Factory Data Pipelines, when you call another pipeline using the Invoke Pipeline activity, the child pipeline is not visible in the monitoring view. We have made updates to the Invoke Pipeline activity so that you can view your child pipeline runs. This requires an upgrade to any pipelines that you have in Fabric that already use the current Invoke Pipeline activity. You will be prompted to upgrade when you edit your pipeline and then provide a connection to your workspace to authenticate. Another additional new feature that will light up with this invoke pipeline activity update is the ability to invoke pipeline across workspaces in Fabric. 

We are excited to announce the availability of the Fabric Spark job definition activity for data pipelines. With this new activity, you will be able to run a Fabric Spark Job definition directly in your pipeline. Detailed monitoring capabilities of your Spark Job definition will be coming soon!  

To learn more about this activity, read https://aka.ms/SparkJobDefinitionActivity  

We are excited to announce the availability of the Azure HDInsight activity for data pipelines. The Azure HDInsight activity allows you to execute Hive queries, invoke a MapReduce program, execute Pig queries, execute a Spark program, or a Hadoop Stream program. Invoking either of the 5 activities can be done in a singular Azure HDInsight activity, and you can invoke this activity using your own or on-demand HDInsight cluster. 

To learn more about this activity, read https://aka.ms/HDInsightsActivity  

We are thrilled to share the new Modern Get Data experience in Data Pipeline to empower users intuitively and efficiently discover the right data, right connection info and credentials.   

In the data destination, users can easily set destination by creating a new Fabric item or creating another destination or selecting existing Fabric item from OneLake data hub. 

In the source tab of Copy activity, users can conveniently choose recent used connections from drop down or create a new connection using “More” option to interact with Modern Get Data experience. 

Related blog posts

Microsoft fabric april 2024 update.

Welcome to the April 2024 update! This month, you’ll find many great new updates, previews, and improvements. From Shortcuts to Google Cloud Storage and S3 compatible data sources in preview, Optimistic Job Admission for Fabric Spark, and New KQL Queryset Command Bar, that’s just a glimpse into this month’s update. There’s much more to explore! … Continue reading “Microsoft Fabric April 2024 Update”

Microsoft Fabric March 2024 Update

Welcome to the March 2024 update. We have a lot of great features this month including OneLake File Explorer, Autotune Query Tuning, Test Framework for Power Query SDK in VS Code, and many more! Earn a free Microsoft Fabric certification exam!  We are thrilled to announce the general availability of Exam DP-600, which leads to … Continue reading “Microsoft Fabric March 2024 Update”

• Site Search:
• Site Search
•  Help/Tutorials
•  Settings
•  Messages

Job Posting: Office Technician (Typing)

Employment Development Department

$3,609.00 - $4,518.00 per Month

Final Filing Date: 5/31/2024

Job Description and Duties

THIS POSITION MAY BE ELIGIBLE FOR A HYBRID WORK SCHEDULE. THE AMOUNT OF TELEWORK IS AT THE DISCRETION OF THE DEPARTMENT AND IS SUBJECT TO CHANGE AS BUSINESS NEEDS ARISE. The Tax Processing and Accounting Division of the Employment Development Department is looking for an enthusiastic individual to join the Electronic Data Integrity Section (EDIS) as an Office Technician (Typing) (OT).

The OT provides clerical support functions for the section. The OT is responsible for attendance and personnel functions and must be able to handle sensitive and confidential assignments with tact and diplomacy. The OT must be able to work both independently or in a team environment, have great attention to detail, must possess good organizational skills, have the ability to prioritize workloads to meet deadlines, be proficient in the use of Microsoft Software applications, and perform other duties as required.

This position is headquartered in Sacramento and may be eligible for telework under EDD's telework policy. California Government Code Section 14200 requires employees to reside in California to telecommute. Employees are required to report to their headquarters office, as needed. Travel expenses to and from the assigned headquarters are the responsibility of the employee.

For applicants new to State service, you must first pass an open competitive examination. If you are new to State employment, you may apply only for exams designated as "open" to the public. If you are a veteran, you may apply for both "open" and "promotional" exams. If you wish to find out more about a particular classification, go to the calcareers.ca.gov website and click on Exam/Assessment Search option.

You will find additional information about the job in the Duty Statement .

Working Conditions

Visa Sponsorship

This position is not eligible for visa sponsorship. Applicants must be authorized to work in the US without the need for visa sponsorship by the start date of employment.

Minimum Requirements

• OFFICE TECHNICIAN (TYPING)

Additional Documents

• Job Application Package Checklist
• Duty Statement

Position Details

Department information, special requirements.

• The position(s) require(s) the ability to type at a minimum speed as designated on the Class Specifications (link available in the additional documentation section). You must obtain a valid typing certificate confirming your ability to meet the minimum typing speed, prior to being hired. Additional information regarding acceptable typing tests is available at the CalCareers.ca.gov website.

Please only submit ONE application.  Electronic applications submitted through your CalCareer Account are highly recommended and will be received/processed faster than other methods of filing.

If you are unable to apply electronically through your CalCareer account, please mail a completed and signed State Examination/Employment Application STD Form 678 and application package to the mailing address provided in the “Application Instructions’ section below and ensure the following:

• Clearly indicate the Job Code #, Position Number and the Classification Title of this position in the “Examination or Job Title(s) For Which You Are Applying” section located on Page 3 of your State Examination/Employment STD Form 678.
• Clearly indicate the basis of your eligibility (list, transfer, reinstatement, etc.) in the “Explanations” section located on Page 3 of your State Examination/Employment Application STD Form 678.
• Remove and do not submit the “Equal Employment Opportunity” questionnaire (Page 10) with your completed State Examination/Employment Application STD Form 678.  This page is for examination use only.
• Do not include your full Social Security Number on your documents and/or do not provide any LEAP information.

Application Instructions

Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.

Who May Apply

How To Apply

Address for Mailing Application Packages

You may submit your application and any applicable or required documents to:

Address for Drop-Off Application Packages

You may drop off your application and any applicable or required documents at:

Required Application Package Documents

The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job:

• Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at www.CalCareers.ca.gov. All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
• Resume is required and must be included.
• Other - A  Cover Letter  is required and must be included.
• Other - A  Typing Certificate  is required and must be included

Desirable Qualifications

• Solid communication skills (oral and written)
• Strong interpersonal skills
• Ability to exercise good judgment
• Good attention to detail

Contact Information

The Hiring Unit Contact is available to answer questions regarding the position or application process.

Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office.

Background Investigation Requirement

The position(s) may require an applicant to pass a background investigation. However, applicants will not be asked to provide information about a conviction history unless they receive a conditional offer of employment.

 The department will make an individualized assessment of whether the conviction history has a direct or adverse relationship with the specific duties of the job and the work performed by the department. The department will consider potential mitigating factors, including, but not limited to, evidence and extent of rehabilitation, recency, nature and seriousness, and age at the time of the offense(s).

 The investigation will consist of completion of a personal history statement and fingerprinting checks with the Federal Bureau of Investigation, Department of Justice, and/or local law enforcement agencies. Anyone failing to pass the background investigation will be provided information on how to appeal the process. A criminal conviction may not result in an automatic determination of "Not Qualified."

ADDITIONAL DEPARTMENT INFORMATION:

The Employment Development Department may require a new probation in accordance with applicable probationary period rules.

Click on the link to complete the Employment Development Department Recruitment Survey:  EDD Recruitment Survey

Merit System Principles Information regarding Merit System Principles provided to public employees by the State Civil Service Act can be found on the CalHR website at  https://www.calhr.ca.gov/Training/Pages/performance-management-merit-system-principles.aspx

Equal Opportunity Employer

The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.

It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.

Automatic log out in

Select 'Stay Logged In' below to resume your activity.

You must enable Javascript to use this site.

Releasing Windows 11, version 24H2 to the Release Preview Channel

• Windows Insider Program Team

UPDATE 5/29: We’re aware that some Windows Insiders in Release Preview are not seeing Windows 11, version 24H2 offered yet. We’ve just begun the rollout and will gradually increase the rollout over time so not everyone will see it right away. If you are not seeing it yet and want to update to Windows 11, version 24H2 right away, you can do so by using the ISO which are available for download here . The ISO is Build 26100.560 but once you update using the ISO and join Release Preview, you’ll get Build 26100.712.

Hello Windows Insiders!

Today, we are making this year’s annual feature update Windows 11, version 24H2 (Build 26100.712) available in the Release Preview Channel for customers to preview ahead of general availability later this calendar year.

Windows 11, version 24H2* includes a range of new features such as the HDR background support, energy saver, Sudo for Windows , Rust in the Windows kernel, support for Wi-Fi 7, voice clarity and more. It also includes many improvements across Windows. For example, we are introducing a scrollable view of the quick settings flyout from the taskbar, the ability to create 7-zip and TAR archives in File Explorer (in addition to ZIP), and improvements for connecting Bluetooth® Low Energy Audio devices. We will be sharing more details in the coming months on many of the new features and improvements included as part of Windows 11, version 24H2 leading up to general availability. Please note that the new AI features such as Recall announced earlier this week will not be available on your PC after installing this update today as they require a Copilot+ PC. For more information on those new AI features and Copilot+ PCs, see this blog post here .

As part of this update, we’re also evolving the Copilot** experience on Windows as an app that will be pinned to the taskbar. This enables users to get the benefits of a traditional app experience, including the ability to resize, move, and snap the window – feedback we’ve heard from users throughout the preview of Copilot in Windows. This model also allows Microsoft to more agilely develop and optimize the experience based on user feedback. This change will be making is way to Insiders in the Canary, Dev, and Beta Channels shortly.

[ADDED 5/30] As part of the Copilot experience’s evolution on Windows to become an app that is pinned to the taskbar, we are retiring the WIN + C keyboard shortcut. For new devices that ship with a Copilot key , this key will open Copilot. For existing devices without that key, using the WIN + (number position for Copilot pinned to your taskbar) is a great way to open Copilot.

Windows Insiders in the Release Preview Channel can install Windows 11, version 24H2 via our “seeker” experience in Windows Update. This means if you are an Insider currently in the Release Preview Channel on a PC that meets the Windows 11  hardware requirements , you can go to Settings and Windows Update and choose to download and install Windows 11, version 24H2 if you want. Once you update your PC to Windows 11, version 24H2, you will continue to automatically receive new servicing updates through Windows Update (the typical monthly update process). For instructions on how to join the Windows Insider Program and join your PC to the Release Preview Channel,  click here .

PLEASE NOTE: Windows Insiders in the Canary and Dev Channels will not be able to switch to the Release Preview Channel as they are on builds already based on Windows 11, version 24H2 but are on higher build numbers. These Insiders don’t need to switch. 

Commercial*** customers enrolled in the  Windows Insider Program for Business  can begin validating Windows 11, version 24H2 on PCs in their organizations. For these customers, the Windows 11, version 24H2 feature update is available through Windows Update for Business (WUfB) and Windows Server Update Service (WSUS). Azure Marketplace will be coming soon. You can learn more about deploying pre-release feature updates using  these deployment methods here . Should any issues arise, IT admins in organizations deploying Release Preview updates can request Microsoft Support .

And finally – ISOs are now available for download for Windows 11, version 24H2 via the Windows Insider ISO download page .

Thanks, Windows Insider Program Team

*Please note that Cortana, Tips, and WordPad are removed after upgrading to Windows 11, version 24H2. These apps are deprecated .

**Copilot in Windows is being rolled out gradually to Windows Insiders across our global markets. Customers in the European Economic Area will be able to download the Copilot in Windows experience as an app from the Microsoft Store (coming soon).

***We consider a device a commercial device if it is not running the Windows 11 Home edition AND is being managed by an IT administrator (whether via Microsoft Endpoint Manager or other management solution) or has a volume license key or commercial ID or is joined to a domain.

• Manage notifications
• Troubleshoot mobile notifications
• Explore the Activity feed
• Change your notifications style
• Change how often you receive missed activity emails
• Change your profile picture
• Manage accounts and organizations

Enable location sharing

• Update Microsoft Teams
• Change app settings
• Check your spelling in multiple languages
• Use high fidelity music mode to play music in Teams
• Change your status
• Set your status message
• Schedule an out of office status
• Screen reader support for Microsoft Teams
• Use a screen reader
• Keyboard shortcuts
• Answer a call with the keyboard
• Navigate conversations with the keyboard
• Zoom in and out
• Change message font size
• Video: Manage notification settings

Enable location services 

To enable location services, you'll first need to provide location permissions to Teams within your OS settings. 

Enable Maps to show your current location on your Mac. 

On Windows 

Set your Windows location service and privacy settings .

By default, the Windows 10 location service is disabled when a device is turned on for the first time. You'll need to ensure your Windows 10 location service is enabled .

Enable Teams to access your location  

Turn on Let apps access your location .

Turn on Let desktop apps access your location .

Add, edit, or reset your emergency location in Teams 

You can check your emergency location below the dial pad in  Calls  or at the bottom of the calls section in your Teams Settings.  

Note:  you can only edit your Emergency Location in Calls .

On the Teams dial pad, add, confirm, edit, or reset your emergency location .

Enable location services on mobile

Your location is required for emergency services and to make and receive PSTN calls in some regions.

Teams will prompt you to allow location sharing the first time you open the app on your mobile device. To turn location sharing on or off after Teams has already been installed, go to Teams Settings on your device and Allow location access .

Note:  Without location services, you won't be able to confirm your emergency location in Teams. Every emergency location you've confirmed is saved and doesn't need to be reconfirmed when returning. When you move to a new physical location, the Teams emergency location will change to reflect what location services detects. 

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Thank you for your feedback.