can you save a powerpoint in presentation mode

Start a presentation automatically with a PowerPoint Show

If you’re sending your PowerPoint presentation to colleagues or friends, or if you're running it in a booth or kiosk, you might want people to immediately watch your presentation as a slide show instead of seeing the slides in edit mode. Save your PowerPoint presentation as a PowerPoint Show (a .ppsx file) so it automatically starts the slide show when the file is opened.

Make a slide show that starts automatically when opened

Select File > Save as (or Save a Copy ).

Click More options .

Browse to the folder where you want to save your presentation.

In the File name box, type a name for your presentation.

Under Save as type , select PowerPoint Show .

The file is saved as a .ppsx file. When the file is double-clicked, it opens as a slide show.

Edit a .ppsx file

In PowerPoint, click File > Open .

Browse to the .ppsx file, and open it.

Saving a presentation as a PowerPoint Show (.ppsx file) isn't available in PowerPoint for the web.

To start a slide show in PowerPoint for the web , open the file, and on the Slide Show tab of the ribbon, select Play from Beginning .

(If you've turned off the Simplified Ribbon, you don't have a Slide Show tab; instead use the View tab to start Presenter Coach.)

For more details on running a slide show, see Present your slide show in PowerPoint for the web .

Set the speed and timing of transitions

Create a self-running presentation

Record a slide show with narration and slide timings

Turn your presentation into a video

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.

• Slidesgo School
• PowerPoint Tutorials

How to Use the Presentation Modes and the Screen Recording Features in PowerPoint

After designing all the slides for your presentation, the next and last step is presenting in front of your audience. In this new Slidesgo School tutorial, you’ll see how the presenter view works and how you can record your presentation .

Presentation Modes

Presentation modes — set up slide show, presentation modes — record slide show.

• There are different presentation modes in PowerPoint, besides the one you can find at the bottom of the screen.
• To access the presentation modes, go to the Slide Show tab.
• The first two options allow you to start the presentation from the beginning or from the currently selected slide.

• If you choose Present Online, an URL will be generated, which you can then share with your potential online viewers. After clicking this button, a new window will open, displaying info about the Microsoft Office online presentation service and a checkbox to enable remote download for your online audience. To enjoy this service, you need an Office 365 account. When you’re ready, click Connect to generate the URL.
• If you choose Custom Slide Show, you can select which slides to display in your presentation.  First, create a new custom slide show and select the slides that you want to display. Then, click Add, enter the name of the presentation and click OK. This new custom presentation will appear on the list. Select it and click Show to begin the presentation.
• In the Set Up group you’ll find options to set up the presentation, hide slides, rehearse your presentation and even record it.
• Click Set Up Slide Show to adjust several settings regarding your presentation. You’ll find more information in the next section of this tutorial .
• If you click Hide Slide, the selected slide won’t show up during your presentation. Hidden slides will appear faded out on the list and their numbers will be crossed out.
• If you click Record Slide Show, you’ll be able to record your presentation from the beginning or from the current slide. We’ll go into detail in the last section of this tutorial.
• There are several checkboxes regarding whether to play narrations, use timings and show media controls.

• In the Monitors group you can choose which screen to display your presentation.
• The last group, Captions & Subtitles, is only available in Office 365. You’ll find options to enable subtitles, which will be generated out of your speech (so you’ll need to have a mic). There are settings to change the language and the position of the subtitles.
• Open your presentation in PowerPoint.
• Go to the Slide Show tab.
• In the Set Up group, click Set Up Slide Show. A new window will open, where you’ll find several options.
• In the top-left corner, under “Show type”, you can choose whether the presentation will be in fullscreen with speaker notes, windowed, or in fullscreen without speaker notes or the menu bar.

• Under “Show options” you can choose whether to show the presentation without narration or animations, or disable the hardware graphics acceleration (for better performance). You can also set the pen and laser pointer color.

• Under “Show slides”, you can choose which slides to show in your presentation. You can select all of them, a specific range or a custom slideshow.
• There are other settings to determine how to advance slides (manually or using timings), what the resolution will be and whether to use the presenter view.
• Click Record Slide Show. From the drop-down menu, select From the Current Slide or From the Beginning.
• A new window will open, along with the presentation in fullscreen mode. At the top-left you’ll find a button to start recording.

Do you find this article useful?

Related tutorials.

How to Use the Presenter View in Google Slides

Google Slides, like PowerPoint, has different presentation modes that can come in handy when you’re presenting and you want your slideshow to look smooth. Whether you’re looking for slides only, speaker notes or the Q&A feature, in this new Google Slides tutorial, you’ll learn about these and their respective settings. Ready? Then let’s explore the presenter view! 

How to Download Google Slides Templates

When preparing a presentation, many people start panicking because they realize how much time it will take to edit each and every slide. Creating them from scratch, filling them in, looking for pictures, moving the elements...How stressful! But there is a solution that saves you a lot of time. We're sure that you've browsed the internet for templates, or basically, pre-established designs and elements, that can be downloaded for free and can be edited to your liking. Are we right? Then, we have some good news for you!

Discover our collection of printable templates

With the advance of technology, printing has become something that is no longer a necessity. Smartphones have made the paper format less and less frequent, but there are still certain cases in which having physical resources is much more convenient. Whether it's for taking notes, handing out assignments, making worksheets or handing out business cards or invitations, it's necessary to print your customized designs.From now on, in every Slidesgo printable presentation that you download, you will find the instructions for printing on the third slide. Depending on the style, colors or format of each presentation, we will tell you if you can...

How to Add Superscript and Subscript in Google Slides

Let’s take the most famous formula: E=mc^2, Einstein’s relativity equation. It wouldn’t be the same if it was E=mc2, right? Okay, yes, some people write it like that because it’s very famous and it won’t be misunderstood. But technically… It can! This is where the sophistication of superscript or subscript enters the room! Do you know how to write them in equations, copyright brands or even footnotes in your presentations? Let’s figure out how.

Stack Exchange Network

Stack Exchange network consists of 183 Q&A communities including Stack Overflow , the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

How can I edit a presentation while in presentation mode?

I'm looking for a way to present to a live audience and incorporate their input into my presentation. With a "static" presentation, you have to keep taking down, editing, and then re-presenting the slide deck. I'm looking for a way to incorporate and save changes directly into the live presentation.

I use Keynote and PowerPoint, so a method to accomplish this with either would be ideal. But I am open to a solution that requires something else.

• microsoft-powerpoint
• presentations
• iwork-keynote

• I would gladly take a hack for PowerPoint or Keynote. That would be the preferred method –  Max Phillips Jan 10, 2017 at 21:46
• Would a PDF with fillable forms meet your requirements? It's not clear what sort of input you want to accept. If it's just text, then running a PDF reader in full-screen mode might do what you want. –  AFH Jan 10, 2017 at 22:19
• There is no hack. This behavior has been "normal" in Powerpoint at least for quite a while. 99% of people present by duplicating their screen (same thing on projector and their computer) but if you extend your display to the projector Powerpoint by default uses a different mode that has a special view on the computer display an the full-screen slide on the projecting display. And... you can edit in real time, while presenting, with live updates to the slides. –  music2myear Jan 10, 2017 at 23:00

3 Answers 3

For Windows:

PowerPoint has had this capability for quite some time. The key is to NOT duplicate your computer screen with the presenting screen ( TV, projector, other screen, etc. I'll use "projector" in this how-to for simplicity purposes. ) The only requirement is that you have some screen besides the projector.

With a Windows computer, when you connect to a projector use the Win + P command and choose the Extend the display. This means that your computer screen and the projector will show different things. You can also do this in Display Settings if you're more familiar with that.

PowerPoint has some intelligence to determine which screen is a projector and which is not, but if you need more control over which screen the presentation is on and which one will be your control screen, in the Slide Show tab you'll find Set Up Slide Show, which includes settings for this.

Another thing to keep in mind is that Presenter View (also an option in the Slide Show tab) can make things a little more difficult, but not much. When using Presenter Mode, the default behavior is for the Presenter Mode window to go full-screen, and you cannot edit in Presenter Mode. However, resizing the Presenter Mode window should allow you to easily bring up the main PowerPoint window, which is where the magic will happen.

So, all that aside, the meat of the solution:

Just edit the darn thing. That's all it takes.

With the presentation running happily away on the projector and the main PowerPoint window up on your computer screen, you can edit as much as you please and your edits will be reflected in real-time in the presentation itself ( Note: I've known about the Presenter Mode and running presentations on multiple monitors for years, but am only testing the specifics of editing in PowerPoint 2016. I do not know how the behavior is different in previous versions. ).

I don't know. I could not find specific documentation of this ability/feature for either Keynote or PowerPoint for Mac. While in Windows the Presenter view can be resized, some suggest this is not an option in Office for Mac.

One work around would be to use the Freeze capability of most projectors to freeze the current image on the screen, then exit the presentation on the computer, edit the slideshow, begin it at that slide again, and then unfreeze the projector image.

• I'm pretty familiar with extended desktop. It's what I work in most of the time. Is this procedure the same on Mac? And what version of PowerPoint are you using? –  Max Phillips Jan 11, 2017 at 16:26
• Macs an Keynote have generally encouraged people to use the extended desktop, so I'm not surprised you're more familiar with that mode. Unfortunately, I do not have the ability to test on an Apple computer. I tested this while writing the answer on Office 2016, which is the same version available for Mac. –  music2myear Jan 11, 2017 at 16:38
• I just can't figure out how to resize the Presenter Mode window. If I play the show without presenter view it takes over the PowerPoint module, there is no window behind it. –  Max Phillips Jan 11, 2017 at 16:44
• Interesting. I know the feature isn't new (or limited) to 2016 because of the answers to this question from 3 years ago: superuser.com/questions/681019/… –  music2myear Jan 11, 2017 at 17:04
• I'm trying to find documentation on the Mac versions. –  music2myear Jan 11, 2017 at 17:04

For Mac using PowerPoint 16:

Open the presentation you want to show. On the Mac menu bar go to window and click New Window.

This will pop out a duplicate PowerPoint presentation. Drag one of them to the second monitor and run it under setup option: "Browsed by an individual (window)"

You can now edit and add slides on the fly in the window that remains on your main desktop without interrupting the presentation. You can even edit the slide that you are currently showing on the screen and it will update automatically as you change it.

• TIL. Sweet. I'm glad you were able to figure it out. Feel free to mark this as the answer, but I'd also recommend modifying your original question to indicate you're talking about Mac OS, which would help clarify why my answer was not the best. –  music2myear Jan 11, 2017 at 23:11
• I want to give credit it where it's deserved. I wasn't trying to steal it. Just wanted to make sure that it was out there for people to find. –  Max Phillips Jan 12, 2017 at 4:43
• No worries. We're about the best answers, and sometimes details such as the OS you're limited to help make sure answers that sound like they may have multiple possible answers can be narrowed down to the right one. –  music2myear Jan 15, 2017 at 19:23

Windows 7 x64 using PowerPoint 2016

When using two screens make sure to uncheck "Use Presenter View" and start your slideshow

On Screen 1 you will be able to edit text on the fly and even add slides.

On Screen 2 you will see updates in real-time. If a slide is added in Screen 1 then you will need to activate Screen 2 and press the left or right arrows respectively.

You must log in to answer this question.

Not the answer you're looking for browse other questions tagged microsoft-powerpoint presentations iwork-keynote ..

• The Overflow Blog
• Is GenAI the next dot-com bubble?
• Featured on Meta
• New Focus Styles & Updated Styling for Button Groups
• Upcoming initiatives on Stack Overflow and across the Stack Exchange network
• Google Cloud will be Sponsoring Super User SE

Hot Network Questions

• Select elements from a list based on alphabetical order criteria
• Why has the number of Germans in Kazakhstan begun to increase?
• Questioning why LVM for the OS Disks in cloud environments is not recommended
• Why did the original ‘d’ in the word ‘weather’ (< Middle English ‘weder, wedir’) change to ‘th’?
• Why aren’t there advanced computers in an advanced society?
• Any possible exceptions/ways to (code compliant) put communication wire in same EMT as line voltage?
• Can the Sunburst spell kill a vampire?
• How can a senior finance building a home with no current credit score but good equity in current home?
• Prime and Composite 6x6 Chocolate Banana
• How many lands in total can be put into play with Map the Frontier?
• What's the purpose of Wormskin Folios?
• Wraping rope (paper chord) around object like wishbone chair
• How can I fix my loose Towel Hanger that is sliding down and making the bar fall
• At the start of Dune, who knew about the Spacing Guild's dependence on spice?
• How to plan a trail route?
• Making a character active in a macro
• Why is "creating jobs" seen as good and "destroying jobs" seen as bad, even when there are major labour shortages?
• What would be the grounds for the US Chamber of Commerce to sue the FTC over its new rule concerning noncompetes?
• is Batman's utility belt ever missing something he needs?
• Protecting against malicious duplicate IDs in a distributed environment
• How do I know how many breakers I can put into my main panel?
• Do I sell my prescriptive nonfiction book to an agent or directly to a publisher?
• How Do I Explain "Be Born"?
• What type of cable is this (optic fiber) connecting to router?

How to Save a PowerPoint Presentation? [PPT & Other Formats!]

By: Author Shrot Katewa

Saving a PowerPoint presentation is one of the most important things that you need to do when you are creating a presentation using PowerPoint. Unlike some of the modern web-based presentation applications, you need to make sure that you save a PowerPoint presentation when you are using an offline version!

To save a PowerPoint presentation, click on the “File” tab. Then, from the backstage view, click on the “Save” option from the left panel. Choose the location or the folder where you want to save the presentation on your computer, and click on “Save”.

In this article, we shall not only understand how to save a standard PPT or PPTx file, but we shall also take a look at how to save a PowerPoint presentation in different file formats such as a PDF, video or an image!

So, let’s get started!

1. How to Save a PowerPoint Presentation?

Once you have saved a PowerPoint presentation, you can easily save it again with just one click. Furthermore, you can also save a PowerPoint presentation in other formats. However, the process of saving a PowerPoint presentation is slightly different on Windows and on Mac.

Let’s understand the process in further detail.

1a. Saving a PowerPoint Presentation on Windows

To save a PowerPoint Presentation on Windows PC, you can follow either of the 2 simple methods.

Method-1: Using the “Save” button on Quick Access Toolbar

In the Quick Access Toolbar located at the very top of the screen, click on the “Save” icon.

The “Save” icon is located on the left side in the Quick Access Toolbar and looks like a floppy disk. Clicking on the “Save” button will immediately save the PowerPoint presentation in its current location as a “.pptx” file.

If you have opened a new presentation and you are saving it for the first time, clicking on the “Save” button will open a new explorer window. Simply navigate to the folder where you wish to save the new presentation on your computer, and click on “ Save “.

Method-2: Using the “File” tab

Another, more common method is to use the “File” tab in PowerPoint to save your PowerPoint presentation.

Here’s what you need to do –

Step 1 – Click on the “File” Tab

Another way to save a PowerPoint presentation is to use the “File” menu. You have to first click on the “File” tab located at the left corner of the menu ribbon at the top of the screen.

Step 2 – Click on the “Save” option

This will open the backstage view in PowerPoint. Now, click on the “Save” option from the sidebar on the left side of the screen. This will save the Microsoft PowerPoint as a “.pptx” file in the current location.

1b. Saving a PowerPoint Presentation on Mac

On a Mac computer, you can use the “File” menu as well to save the PowerPoint presentation.

The first step is to click on the “File” menu in the menu bar located at the top of the screen (above the PowerPoint window). This will open a dropdown menu. Click on the “Save” option from the dropdown menu to save the presentation as a “.pptx” file which is the standard format for presentations.

1c. Shortcut Keys to Save a PowerPoint Presentation

Microsoft PowerPoint also allows you to save a presentation with keyboard shortcuts. All you have to do is press the “Ctrl+S” keys on your keyboard in an open PowerPoint file. This will save the PowerPoint presentation.

1d. Best Format to Save a PowerPoint Presentation?

PowerPoint allows you to save a presentation in various different file formats! For instance, you can use the .ppt format if you wish to open the presentation file using PowerPoint 2007 or earlier. You can use .ppsx to open presentation directly as a PowerPoint Show file that opens it in the presentation mode.

In fact, there are several other formats you can save a presentation in. We shall explore how to save a PowerPoint presentation in several different formats later in the article.

However, the best format to save a PowerPoint Presentation is a “.pptx” file. This type can support all the latest as well as the older features of the PowerPoint presentation.

If you will be opening the presentation using a different software other than Microsoft PowerPoint, “.odp” is the best format. For printing, make sure to save the PowerPoint presentation as a PDF. That said, .pptx file format can help serve these purposes too.

2. How to Save a PowerPoint Presentation as PDF

Saving a PowerPoint presentation in PDF format is the suitable method for printing out your presentation. To save the PowerPoint presentation as a PDF file, follow the 4 easy steps.

Step-1: Click on the “File” Tab

First, click on the “ File ” tab in PowerPoint to open the back stage view of PowerPoint.

Step 2 – Click on the “Save As” option

In the menu ribbon located at the top of the screen, click on the “File” tab. In the “File” menu, click on the “Save As” option from the sidebar on the left side of the screen.

Step-3: Click on the “PDF (*.pdf)” option

In the “Save As” screen, click on the box that shows “PowerPoint Presentation (*.pptx)” . This will open a dropdown menu. Click on the “PDF (*.pdf)” option from the dropdown menu.

Step-4: Click on the “Save” button

Now all you have to do is click on the “Save” button beside the box to save the PowerPoint presentation as a PDF file (as shown in the image in step 2).

3. How to Save a PowerPoint Presentation as a Video?

In Microsoft PowerPoint, you can also save a presentation as a video. This allows you to play the presentation slides as a video rather than a slide show.

3a. On Windows

To save a PowerPoint presentation as a video on a Windows PC, follow the 3 easy steps.

Step-1: Click on the “File” tab

The first step is to open the “Save As” screen. To do so, click on the “File” tab in the menu ribbon. In the “File” menu, click on the “Save As” option.

Step-2: Choose the “.mp4” file format from the “Save As” tab

The next step is to click on the “Save As Options” box. It is the second box on the right side of the “Save As” screen. In the dropdown menu, click on either the “MPEG-4 Video (*.mp4)” option or the “Windows Media Video (*.wmv)” option.

Step-3: Click on the “Save” button

The final step is to click on the “Save” button (as indicated in step 2 above). It is located on the right side of the “Save As Options” box. This will save your PowerPoint presentation as a video.

To save a PowerPoint presentation as a video on a Mac device, follow the 3 simple steps.

Step-1: Click on the “Export” option

In the menu bar at the top of the screen, click on the “File” option. In the “File” dropdown menu, click on the “Export” option. This will open a dialog box.

Step-2: Click on the “File Format” box

In the dialog box, click on the “File Format” box. This will open a dropdown menu. You can click on either the “MP4” option or the “MOV” option as you prefer.

Step-3: Click on the “Export” button

In the dialog box, you can also click on the “Quality” option to select the quality of the video. Once you are satisfied with the selections in the dialog box, click on the “Export” button at the bottom (as shown in the image in the previous step). This will save the presentation as a video.

4. How to Save a PowerPoint Presentation to Open in Slideshow Mode?

Microsoft PowerPoint allows you to save the PowerPoint presentation as a “PowerPoint Show” file. This opens directly as a slideshow. To save a PowerPoint presentation to open in slideshow mode, follow the 2 easy steps.

In the open PowerPoint file, click on the “File” tab from the menu ribbon which is located at the top of the screen. In the “File” menu, click on the “Save As” option.

Step-2: Click on the “PowerPoint Show (*.ppsx)” option

In the “Save As” screen, click on the “Save As Options” box which shows “PowerPoint Presentation (*.pptx)” . This will open a dropdown menu. Click on the “PowerPoint Show (*.ppsx)” option.

Now all you have to do is click on the “Save” button to save the PowerPoint presentation to open as a slideshow.

5. How to Save a PowerPoint Presentation as an Image?

In Microsoft PowerPoint, you can save the presentation as an image in five different formats: “Animated GIF Format (*.gif)” , “JPEG File Interchange Format (*.jpeg)” , “PNG Portable Network Graphics Format (*.png)” , “TIFF Tag Image File Format (*.tif)”, and “Scalable Vector Graphics Format (*.svg)” .

To save your presentation as an image, follow the 3 simple steps.

Step-1: Click on the “Save As” option from the “File” tab

The first step is to click on the “File” tab in the menu ribbon. Then click on the “Save As” option from the “File” menu.

Step-2: Select your preferred image format

In the “Save As” screen, click on the “Save As Type” box which is the second box in the right column. From the dropdown menu, click on your preferred image format from the five available formats.

Now all you have to do is click on the “Save” button (as shown in the image in step 2) beside the “Save As Type” box. This will save your presentation in a folder containing each slide as a separate image file.

6. How to Save a PowerPoint Presentation as a Template?

A PowerPoint template is a predesigned presentation that you can edit to add your own content. To save a presentation as a template, follow the 3 easy steps.

The first step is to click on the “File” tab in the menu ribbon. Then click on the “Export” option from the sidebar in the “File” menu.

Step-2: Click on “Change File Type”

Now you have to click on the “Change File Type” option. Under the “Presentation File Types” group in the right column, click on the “Templates” option. Then click on the “Save As” button at the bottom of the screen.

In the “Save As” dialog box, you will see that the “Save as type” box shows the “PowerPoint Template” format. Now all you have to do is click on the “Save” button.

7. How to Save PowerPoint Presentation as Google Slides?

Microsoft PowerPoint does not offer any feature to upload a presentation to Google Slides directly. However, Google Slides does offer you an option to upload your PowerPoint presentation and save it in Google Slides!

Step-1: Save Your PowerPoint Presentation

The first step is to save your PowerPoint presentation using any method described in the section 1 of this article.

Make sure that you note down the location of the folder in which you have save the PowerPoint file.

Step-2: Click on the “Open file picker” option in Google Slides

Now, the next thing you need to do is open your Google Slides account by visiting slides.google.com . If you aren’t logged in, make sure you sign in with your account credentials.

Next, you will be presented with Google Slides home screen (as shown in the image above). In Google Slides, click on the “Open file picker” icon which looks like a folder. This will open the “Open a file” dialog box.

Step-2: Click on “Upload”

In the “Open a file” dialog box, click on the “Upload” tab.

From your “File Explorer” window, drag and drop the PowerPoint presentation in the dialog box. Now the presentation will automatically open in Google Slides.

Also Read – How to “ Make a Copy of a Google Slides Presentation ” and how to “ Share a Google Slides Presentation Correctly ” with others!

You can also click on the “ Select a file from your device ” button (blue button in the center of the screen). This will open the file explorer window. Navigate to the folder in which you have saved your PowerPoint presentation, and click on “OK”. This will open and save the presentation file in Google Slides.

8. How to Save a PowerPoint Presentation to a Flash Drive?

To save a PowerPoint presentation on a flash drive or any external device, follow the 3 simple steps.

In the menu ribbon located at the top of the screen, click on the “File” tab. In the “File” menu, click on the “Save As” option.

Step-2: Click on “Browse”

In the “Save As” screen, click on the “Browse” option which is the last option in the left column. This will open the “Save As” dialog box. In the sidebar on the left of the dialog box, click on the external disc.

Now all you have to do is click on the “Save” button at the bottom of the dialog box to save the PowerPoint presentation on the flash drive (as shown in the image in step 2).

9. How to Save a Copy of a PowerPoint Presentation?

The “Save A Copy” feature of Microsoft PowerPoint allows you to save changes in your presentation in a copied file without changing the original file.

Check out my article to learn detailed steps on how to save a copy of a PowerPoint presentation .

10. How to Save a Read-Only PowerPoint Presentation?

The “Read-Only” feature of Microsoft PowerPoint allows you to protect your PowerPoint presentation .

Using this feature, you can share your presentation with others without giving them the access to change your presentation. To save a read-only PowerPoint presentation, follow the steps mentioned below –

The first step is to click on the “File” tab in the menu ribbon. From the sidebar in the “File” menu, click on the “Info” option.

Step-2: Click on the “Protect Presentation” button

The next step is to click on the “Protect Presentation” option in the “Info” screen. This will open a dropdown menu. Click on the “Always Open Read-Only” option from the dropdown menu.

Step-3: Click on the “Save” option

Now all you have to do is save the presentation. To do so, click on the “Save” option in the sidebar right under the “Info” option. Alternatively, you can press the “Ctrl+S” keys on your keyboard.

If you have received a presentation that opens only in the read-only mode, but you don’t know how to work with it, check out my other article on “ How to Edit a Presentation in Read-Only Mode “.

11. How to Save a PowerPoint Presentation Without Notes?

When saving a PowerPoint presentation, you might want to remove the speaker notes. To do so, all you have to do is follow the 5 quick steps.

In the menu ribbon, click on the “File” tab. Then click on the “Info” option from the “File” menu.

Step-2: Click on “Check for Issues” on the “Info” tab

In the “Info” option, click on the “Check for Issues” button. Then click on the “Inspect Document” option from the dropdown menu. This will prompt a dialog box.

Step-3: Click on the “Inspect” option

In the “Document Inspector” dialog box, scroll all the way to the bottom and make sure the “Presentation Notes” option is selected. Then click on the “Inspect” button at the bottom of the dialog box.

Step-4: Click on the “Remove All” option

Once the inspection results are shown in the “Document Inspector” dialog, scroll to the bottom again to find the “Presentation Notes” option. Then click on the “Remove All” button at the right side of the “Presentation Notes” option.

Now all you have to do is click on the “Close” button at the bottom of the dialog box to finish the process.

Step-5: Click on the “Save” option

The final step is to click on the “ Save ” option in the sidebar of the “File” menu to save the presentation without notes. You can alternatively press the “Ctrl+S” keys on your keyboard.

12. How to Save PowerPoint Presentation Directly in Microsoft Teams?

If you are delivering a PowerPoint presentation to an audience using Microsoft teams, you can easily share a PowerPoint deck with your audience in the following steps –

• First, open the Microsoft Teams application and login to the meeting.

• On the “ Meeting Controls ” menu available in the top part of your meeting screen, locate the “ Share Content ” option.
• Click on the share content button. This will show the most recent PowerPoint files that you opened. You can either choose to click on one of the files visible. Alternatively, scroll down on the right panel and click on the “ Browse my computer ” option.

• This will open a new file browser window. Navigate to the respective location where your PowerPoint presentation is saved, click on it to select it. Then, click on “Open” to open the presentation in Microsoft Teams.
• The presentation will open by default in the presenter mode and shared with the audience of the meeting.

13. How to Enable Autosave in PowerPoint Presentation?

The autosave option is only available if you are using the Microsoft Office 365 version of PowerPoint . Other than that, you will have to manually save the PowerPoint file in all other versions.

You can autosave the PowerPoint presentation to the OneDrive cloud, and also autosave recovery files. To enable autosave in PowerPoint presentation, follow the 4 simple steps.

Step-1: Click on the “AutoSave” button

To simply turn on autosave in the OneDrive cloud for the PowerPoint presentation, all you have to do is click on the slider beside the “Autosave” option.

It is located in the left corner of the Quick Access Toolbar at the top of the screen.

Step-2: Click on “Options”

To access more autosave options, click on the “File” tab in the menu ribbon. Then click on the “Options” option which is the last option in the sidebar in the “File” menu. It will open a dialog box.

In the “PowerPoint Options” dialog, click on the “Save” option from the sidebar located on the left side. Now you can enable your preferred autosave options in the “Save presentations” section.

Click on the “Autosave OneDrive and SharePoint Online files by default on PowerPoint” for auto-saving on the cloud. You can also select how often the auto-recovery copy is saved by clicking on the box at the right side of the “Save Autorecover information” option.

Step-4: Click on the “OK” button

Now all you have to do is click on the “OK” button at the bottom of the “PowerPoint Options” dialog box to enable your autosave preference (as shown in the image in step 2).

Credit to Cookie_studio (on Freepik) for the featured image of this article (further edited).

• PRO Courses Guides New Tech Help Pro Expert Videos About wikiHow Pro Upgrade Sign In
• EXPLORE Tech Help Pro About Us Random Article Quizzes Request a New Article Community Dashboard This Or That Game Popular Categories Arts and Entertainment Artwork Books Movies Computers and Electronics Computers Phone Skills Technology Hacks Health Men's Health Mental Health Women's Health Relationships Dating Love Relationship Issues Hobbies and Crafts Crafts Drawing Games Education & Communication Communication Skills Personal Development Studying Personal Care and Style Fashion Hair Care Personal Hygiene Youth Personal Care School Stuff Dating All Categories Arts and Entertainment Finance and Business Home and Garden Relationship Quizzes Cars & Other Vehicles Food and Entertaining Personal Care and Style Sports and Fitness Computers and Electronics Health Pets and Animals Travel Education & Communication Hobbies and Crafts Philosophy and Religion Work World Family Life Holidays and Traditions Relationships Youth
• Browse Articles
• Learn Something New
• Quizzes Hot
• This Or That Game New
• Train Your Brain
• Explore More
• Support wikiHow
• About wikiHow
• Log in / Sign up
• Computers and Electronics
• Presentation Software
• PowerPoint Presentations

How to Save a PowerPoint Presentation

Last Updated: May 26, 2022

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time. This article has been viewed 50,680 times. Learn more...

A PowerPoint presentation is an excellent way of presenting information or ideas to an audience. The software is easy to use and offers a lot of cool effects for your slideshows, too. But, what's all the use of this if you don't even know how to save your finished PowerPoint? This wikiHow will teach you how to save your file.

Design your PowerPoint presentation.

• You don't have to wait until you're totally finished to save your work. It can help to save along the way, too, to ensure you don't lose any progress.

Open the File menu when you're ready to save.

Choose the Save or Save As option.

Decide where to save the presentation.

Name and save your presentation.

Expert Q&A

You might also like.

About This Article

• Send fan mail to authors

Is this article up to date?

Featured Articles

Trending Articles

Watch Articles

• Terms of Use
• Privacy Policy
• Do Not Sell or Share My Info
• Not Selling Info

wikiHow Tech Help Pro:

Level up your tech skills and stay ahead of the curve

How-To Geek

How to automatically save powerpoint presentations to onedrive.

Want to automatically save your PowerPoint presentations?

Quick Links

Automatically save powerpoint presentations to onedrive, change where powerpoint presentations are saved in onedrive.

If you regularly work on Microsoft PowerPoint, you should consider enabling AutoSave for your presentations. Here's how you can directly save PowerPoint presentations to OneDrive if you have a Microsoft 365 subscription .

Remember that you'll have to enable this once every time you open a new PowerPoint presentation. After that, AutoSave will keep saving changes to the presentation when you make them.

Related: What Is Microsoft 365?

You should note that OneDrive needs to be set up separately, even if you've logged in to Microsoft Office on your computer. You just need to open the OneDrive app on your computer and sign in to your Microsoft account. Once you've done that, OneDrive will be set up and ready to use on your computer.

With OneDrive set up, open Microsoft PowerPoint and select the "File" menu at the top.

Click "New" on the left pane.

Select "Blank Presentation" or any template that you like.

Hit the toggle next to AutoSave and make sure that it's set to "On."

You'll see a pop-up message where you'll need to select "OneDrive."

Now, name your presentation, and then click "OK."

From this moment on, PowerPoint will keep saving your presentation automatically. You can find your saved presentations in the Documents folder in OneDrive by default. If you use OneDrive just to store your Office documents, you're unlikely to run out of storage anytime soon, because you get 1TB of storage along with your Microsoft 365 subscription.

Changing the location of your saved PowerPoint presentations is a good idea if you like to sort your work into neat folders. You can do this easily by opening any presentation in MicrosoftPowerPoint and clicking "File."

Now, select "Save a Copy."

Click "OneDrive," which is in the pane labeled Save a Copy.

Here, you can click "More options" to open a window.

Alternatively, you can click "New Folder" in PowerPoint and start organizing your presentations.

When you're done, select the folder that you just created.

Hit "Save."

This will save your presentation in a new folder in OneDrive. The next time you create a PowerPoint presentation, you can use this method to either save it in the same folder or to create a new one if you wish to.

To verify that your file is saved in the correct folder, click the file name at the top and check the directory under OneDrive.

Now that AutoSave is enabled on PowerPoint, you should try embedding a Microsoft PowerPoint slide in a Word Document. You can also try sharing your Word document using OneDrive.

Related: How to Share Your Microsoft Word Document Using OneDrive

Contribute to the Microsoft 365 and Office forum! Click  here  to learn more  💡

April 9, 2024

Contribute to the Microsoft 365 and Office forum!

Click  here  to learn more  💡

PowerPoint Top Forum Contributors: Steve Rindsberg  -  John Korchok   👍✅

April 17, 2024

PowerPoint Top Forum Contributors:

Steve Rindsberg  -  John Korchok   👍✅

• Search the community and support articles
• Microsoft 365 and Office
• Search Community member

Ask a new question

Powerpoint in Read-Only mode

Hi, I want to ask why my PowerPoint is still in read-only mode, and it can't use this solution to mark it as final, because when I try to mark as final, the file cannot be saved. it keeps popping up the error about how I don't have permission to save in this file location, contact the administrator to obtain the permission. Actually the administrator is me so why I still cannot get rid of the read-only mode. please help me to find the solution. Thank you in advanced.

My PowerPoint version is 2403 16.0.17425.20176

• Subscribe to RSS feed

Report abuse

Replies (1) .

• Microsoft Agent |

Dear Maharani Qonita Jannah,

Apologies for the inconvenience caused and please don’t worry, let’s work together on your concern and move towards a resolution path.

I understand your concern and I would like to convey that I have tested the behavior at my end in the latest version of the PowerPoint application on the current channel, where I am able to mark the presentation as a final.

Since you are the administrator of your computer but still getting the no administrator permission, I would like to confirm the following scenarios which will help us to better understand your scenario:

1. PowerPoint app Account page: Open the PowerPoint presentation> File> Account> Take a screenshot and share it with us.

2. Does the problem happens with the presentations stored in the specific location or any location on your computer?

3. What’s the behavior when you mark the Word document as a final?

4. If you create a new presentation and try to mark the presentation as a final, do you encounter the same issue?

Our sincere apologies for not resolving the problem is first reply but answers to above queries will help us to better understand your situation and guide you in the right direction.

Appreciate your patience and understanding. Have a great day!!

Best Regards,

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.

Question Info

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

How To Get Free Access To Microsoft PowerPoint

E very time you need to present an overview of a plan or a report to a whole room of people, chances are you turn to Microsoft PowerPoint. And who doesn't? It's popular for its wide array of features that make creating effective presentations a walk in the park. PowerPoint comes with a host of keyboard shortcuts for easy navigation, subtitles and video recordings for your audience's benefit, and a variety of transitions, animations, and designs for better engagement.

But with these nifty features comes a hefty price tag. At the moment, the personal plan — which includes other Office apps — is at $69.99 a year. This might be the most budget-friendly option, especially if you plan to use the other Microsoft Office apps, too. Unfortunately, you can't buy PowerPoint alone, but there are a few workarounds you can use to get access to PowerPoint at no cost to you at all.

Read more: The 20 Best Mac Apps That Will Improve Your Apple Experience

Method #1: Sign Up For A Free Microsoft Account On The Office Website

Microsoft offers a web-based version of PowerPoint completely free of charge to all users. Here's how you can access it:

• Visit the Microsoft 365 page .
• If you already have a free account with Microsoft, click Sign in. Otherwise, press "Sign up for the free version of Microsoft 365" to create a new account at no cost.
• On the Office home page, select PowerPoint from the side panel on the left.
• Click on "Blank presentation" to create your presentation from scratch, or pick your preferred free PowerPoint template from the options at the top (there's also a host of editable templates you can find on the Microsoft 365 Create site ).
• Create your presentation as normal. Your edits will be saved automatically to your Microsoft OneDrive as long as you're connected to the internet.

It's important to keep in mind, though, that while you're free to use this web version of PowerPoint to create your slides and edit templates, there are certain features it doesn't have that you can find on the paid version. For instance, you can access only a handful of font styles and stock elements like images, videos, icons, and stickers. Designer is also available for use on up to three presentations per month only (it's unlimited for premium subscribers). When presenting, you won't find the Present Live and Always Use Subtitles options present in the paid plans. The biggest caveat of the free version is that it won't get any newly released features, unlike its premium counterparts.

Method #2: Install Microsoft 365 (Office) To Your Windows

Don't fancy working on your presentation in a browser? If you have a Windows computer with the Office 365 apps pre-installed or downloaded from a previous Office 365 trial, you can use the Microsoft 365 (Office) app instead. Unlike the individual Microsoft apps that you need to buy from the Microsoft Store, this one is free to download and use. Here's how to get free PowerPoint on the Microsoft 365 (Office) app:

• Search for Microsoft 365 (Office) on the Microsoft Store app.
• Install and open it.
• Sign in with your Microsoft account. Alternatively, press "Create free account" if you don't have one yet.
• Click on Create on the left side panel.
• Select Presentation.
• In the PowerPoint window that opens, log in using your account.
• Press Accept on the "Free 5-day pass" section. This lets you use PowerPoint (and Word and Excel) for five days — free of charge and without having to input any payment information.
• Create your presentation as usual. As you're using the desktop version, you can access the full features of PowerPoint, including the ability to present in Teams, export the presentation as a video file, translate the slides' content to a different language, and even work offline.

The only downside of this method is the time limit. Once the five days are up, you can no longer open the PowerPoint desktop app. However, all your files will still be accessible to you. If you saved them to OneDrive, you can continue editing them on the web app. If you saved them to your computer, you can upload them to OneDrive and edit them from there.

Method #3: Download The Microsoft PowerPoint App On Your Android Or iOS Device

If you're always on the move and need the flexibility of creating and editing presentations on your Android or iOS device, you'll be glad to know that PowerPoint is free and available for offline use on your mobile phones. But — of course, there's a but — you can only access the free version if your device is under 10.1 inches. Anything bigger than that requires a premium subscription. If your phone fits the bill, then follow these steps to get free PowerPoint on your device:

• Install Microsoft PowerPoint from the App Store or Google Play Store .
• Log in using your existing Microsoft email or enter a new email address to create one if you don't already have an account.
• On the "Get Microsoft 365 Personal Plan" screen, press Skip For Now.
• If you're offered a free trial, select Try later (or enjoy the free 30-day trial if you're interested).
• To make a new presentation, tap the plus sign in the upper right corner.
• Change the "Create in" option from OneDrive - Personal to a folder on your device. This allows you to save the presentation to your local storage and make offline edits.
• Press "Set as default" to set your local folder as the default file storage location.
• Choose your template from the selection or use a blank presentation.
• Edit your presentation as needed.

Do note that PowerPoint mobile comes with some restrictions. There's no option to insert stock elements, change the slide size to a custom size, use the Designer feature, or display the presentation in Immersive Reader mode. However, you can use font styles considered premium on the web app.

Method #4: Use Your School Email Address

Office 365 Education is free for students and teachers, provided they have an email address from an eligible school. To check for your eligibility, here's what you need to do:

• Go to the Office 365 Education page .
• Type in your school email address in the empty text field.
• Press "Get Started."
• On the next screen, verify your eligibility. If you're eligible, you'll be asked to select whether you're a student or a teacher. If your school isn't recognized, however, you'll get a message telling you so.
• For those who are eligible, proceed with creating your Office 365 Education account. Make sure your school email can receive external mail, as Microsoft will send you a verification code for your account.
• Once you're done filling out the form, press "Start." This will open your Office 365 account page.

You can then start making your PowerPoint presentation using the web app. If your school's plan supports it, you can also install the Office 365 apps to your computer by clicking the "Install Office" button on your Office 365 account page and running the downloaded installation file. What sets the Office 365 Education account apart from the regular free account is that you have unlimited personal cloud storage and access to other Office apps like Word, Excel, and Outlook.

Read the original article on SlashGear .

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

Microsoft fabric updates blog.

Microsoft Fabric April 2024 Update

• Monthly 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! Read on and let us know what update you’re most excited about and what you found the most helpful.

Fabric Conference Day 1 Keynote is now available!

Did you miss it, or want to hear it again? We are excited to release the FabCon Day 1 Keynote to the Microsoft Fabric YouTube Channel !

If you aren’t already, be sure to subscribe to the Microsoft Fabric Channel! Check out the amazing announcements & demos from Arun, Amir, Wangui, and other awesome presenters. The Day 3 keynotes will be released later this month, and more content will be released regularly moving forward.

Make sure you check out the blog post from Arun, that highlights the announcements from FabCon you can find that here:  Announcements from the Microsoft Fabric Community Conference

Earn a free Microsoft Fabric certification exam! 

We are thrilled to announce the general availability of  Exam DP-600 , which leads to the  Microsoft Certified: Fabric Analytics Engineer Associate  certification.  

Microsoft Fabric’s common analytics platform is built on the instantly  familiar Power BI experience , making your transition to Fabric Analytics Engineer easier. With Fabric, you can build on your prior knowledge – whether that is Power BI, SQL, or Python – and master how to enrich data for analytics in the era of AI. 

To help you learn quickly and get certified, we created the  Fabric Career Hub.  We have curated the  best   free   on-demand and live training, exam crams, practice tests and more . 

And because the best way to learn is live, we will have  free live learning sessions  led by the best Microsoft Fabric experts from Apr 16 to May 8, in English and Spanish. Register now at the  Learn Together  page.

Also,  become eligible for a  free certification exam  by completing the  Fabric AI Skills Challenge.  But hurry, the challenge only runs from  March 19 – April 19  and free certs are first-come, first-served! (limit one per participant,  terms and conditions  apply). 

New Visual – 100% Stacked Area Chart

Line enhancements, enhance q&a with copilot-generated linguistic relationships, snowflake (connector update), storytelling in powerpoint – improved image mode in the power bi add-in for powerpoint, storytelling in powerpoint – continuous slide show auto refresh, storytelling in powerpoint – auto populating the slide title, introducing the fabric metadata scanning sample app, dynamic subscriptions for power bi and paginated reports, supporting folders in workspace, new “clear barcode” action in the report footer, open power bi items in full screen mode, new visuals in appsource kpi matrix growth rate chart by djeeni v1.4 aimplan comment visual.

• Financial Reporting Matrix by Profitbase 

Horizon Chart by Powerviz

Drill down scatter pro by zoomcharts, image gallery, horizontal bar chart, multi-pane card 1.1.

• Introducing Copilot pane in Power BI Desktop (preview) 
• Shortcuts to Google Cloud Storage and S3 compatible data sources (preview)
• OneLake data access roles – public preview

Tenant level Private Link

Managed private endpoints for microsoft fabric.

• Trusted Workspace Access for OneLake Shortcuts
• Git Integration

Partition elimination performance improvement for tables with a large number of files 

Mirroring (public preview) .

• Optimistic Job Admission for Fabric Spark 
• Single Node Support for Starter Pools
• Container Image for Synapse VS Code 
• Git Integration with Spark Job Definition 
• New Revamped Object Explorer experience in the notebook 
• %run your scripts in Notebook
• Semantic Link is now GA! 

Capacity level delegation for AI and Copilot 

Eu customers can use ai and copilot without cross-geo setting .

• New KQL Queryset Command Bar 
• New Update Command Public Preview 
• Introducing Pause and Resume Feature in Eventstream
• Fabric Real-Time Analytics Integrates with Newly Announced Database Watcher for Azure SQL (preview)

Service Principal Name authentication kind support for On-Premises and VNET data gateways 

• Certified connector updates

Spark job definition activity 

Updated fabric data pipeline homepage .

• Pipeline support for CI/CD in public preview 
• Data Factory Data Pipelines APIs
• Increase in Pipeline activity limit
• Fabric Warehouse in ADF copy activity
• Edit column type to destination table support added to Fabric Warehouse and other SQL data stores
• SFTP: performance improvements when writing data to SFTP

Introducing the new 100% Stacked Area Chart, now available in our core visuals gallery. These visuals display the relative percentage of multiple data series in stacked areas, where the total always equals 100%. It’s perfect for showing the proportion of individual series to the whole and how they change over time. Find it in the visual gallery, on-object dialog, or format pane, right next to the Stacked Area Chart. Give it a try and share your feedback with us!

For more detailed information about this new visual, and the new line enhancements you can read our article: PBI Core Visuals

Take your line charts to the next level with our new line control features.

• Adjust line color transparency under Lines > Colors > Transparency.
• Control the color and transparency of each series by selecting them in the ‘Apply settings to’ dropdown.
• Use Monotone and the new Cardinal smooth type for full control of smooth lines.
• Choose from before, center, and after step lines to align your visual with your story.

Try out these new features and enhance your line charts.

These new line enhancements are just the beginning, there is more to come. Try them out and stay ahead of the curve. We would love to hear about your experience and the amazing things you can achieve with these new features.

Improving your linguistic schema is an important step in making sure that the Q&A visual can understand the wide range of questions people might ask about their data. This is why, back in September , we added a new section into the Q&A setup menu to help you add linguistic relationships to teach Q&A about words which qualify or relate your data.  

But we also know that coming up with all the different words people might be using to refer to your data can take time and effort, and we’ve been working on ways to make that process easier for you! In November , we introduced a way for you to quickly generate new synonyms for the names of tables and columns in your model; this month, we’ve introduced the same functionality for linguistic relationships!  

When you open a report with a Q&A visual, if you have Copilot enabled and you’ve already added synonyms, you’ll now see a banner prompting you to get relationships with Copilot as well.  

Unlike with synonyms, Copilot generated relationships will not be used to understand natural language inputs until you have approved them, so make sure you accept the ones which work for your model!  

Allow Copilot to help interpret Q&A questions.

You can also now use Copilot to improve the Q&A engine’s term recognition when you ask questions! This new feature will trigger when you ask Q&A a question which uses words or phrases which Q&A doesn’t recognize, but which it detects might be referring to data entities like tables or columns. Then, Copilot will also check those unknown words or phrases to see if there is any reasonable match and if so, return the answer as a visual as though a suggested synonym had been applied.

This feature is not a replacement for synonyms! In fact, adding synonyms for the entities in your semantic model is even more important to create good matches, as they increase the surface area to check for similarities. It will widen the range of inputs Q&A will recognize, but like a multiplier, it will improve recognition for well modeled data much better than it will for poorly modeled data.  

This feature will be automatically enabled when you choose to get synonyms with Copilot, but you can also turn it on or off manually in the suggestion settings menu in the Synonyms tab in Q&A setup. 

Data Connectivity

The Snowflake connector has been updated to support the use of Snowflake dynamic tables .

We’ve made saving Power BI content as an image more simple and more powerful. 

First, we’ve added a new dropdown menu to the add-in’s footer. In that menu, you can choose whether you want to see live data or a snapshot. So now it is much easier to find where to switch between live data and a static image.

Second, for snapshots, you now have two options:

Public snapshot: Anyone who can view the presentation can view the image.

Snapshot: Only those who have permission to view the report in Power BI will be able to see the snapshot.

Third, we’ve disabled the default snapshot, so that the slide thumbnail doesn’t show the image by default (this also applies when you copy & paste the slide into an email for example), but only after the add-in is loaded and the required permissions have been checked.

And lastly, we honor this setting when you open the presentation in PowerPoint for the web. You still cannot change a live view into a snapshot in PowerPoint for the web, but if you or someone else has changed the view to snapshot in the PowerPoint desktop app, this will be respected, and you will see the snapshot also in PowerPoint for the web.

PowerPoint allows you to continuously playback a presentation. This is especially useful when you want to present information in public displays without any human interaction.

If a presentation that is running continuously has slides that include the Power BI add-in, the data in the add-in might become outdated, since the add-in gets the data from Power BI when the slide is loaded, or when the user manually refreshes the data being presented.

With the new automatic refresh in slide show feature, you can set the add-in to automatically pull fresh data from Power BI while the presentation is in slide show mode, ensuring that the presentation will always show the most recent data.

To enable automatic refresh, go to the add-in footer, select Add-in options, choose Slide show settings, check Automatic refresh in slide show and set the desired frequency.

Note that auto refresh only happens in slide show mode and not while you’re editing the presentation.

When you add the Power BI add-in to an empty slide that doesn’t have a title yet, the Power BI add-in is here to help. It offers you suggestions for the slide title based on the content of you add-in. The title can be the report name, the page/visual name, or both. Just select the desired option and hit Add title.

We’re delighted to announce the availability of the new Fabric metadata scanning app. This sample application builds upon the metadata scanning capabilities of Fabric’s set of Admin REST APIs collectively known as the scanner APIs. This new app can be used as a reference for admins interested in utilizing the Scanner API to catalog and report on all the metadata of their organization’s Fabric items.

The Fabric metadata scanning sample app handles all the steps for calling the scanner API including authentication, parallelism, throttling, and incremental scanning. In addition, it provides a central configuration file which can be easily modified to suit the specific needs of the caller. Currently authentication is supported both by using a service principal and a delegated token.

The app is available as a Microsoft open-source project, and is open for suggestions and improvements here: Fabric Metadata Scanning

We’re pleased to announce that you can now send dynamic per recipient subscriptions to up to 1000 recipients instead of the earlier limit of 50 recipients from the data in the Power BI semantic model. For existing subscriptions, we will automatically send subscriptions up to 1000 recipients if your Power BI semantic model contains that many rows of data. You need to edit the subscription if you don’t want to automatically send subscriptions. Learn more about creating dynamic per recipient subscriptions for Power BI Reports and paginated reports .

This feature will be available in some regions as soon as today, however depending on the geography in which your Power BI tenant is located, it may take up to two weeks to appear.

The Power BI Mobile apps support folders in workspace. So, you can access items that are organized in folders inside of your workspace directly from the mobile app.

Workspace and folders are Fabric entities, which means that you can add items that are not necessarily Power BI items to a workspace. But the Power BI Mobile apps only support a subset of Power BI items. Therefore, only the Power BI item will be accessible when you are browsing the folder content from the app. If a folder contains only non-Power BI items, it will appear empty in the mobile app.

When a field in your model is marked as a barcode, you can use your mobile device camera to scan the barcodes of real objects to filter reports that are built on this model. This feature is extremely useful for retail, where you can scan the barcode on a piece of merchandise to get a report showing data about the item directly in your mobile app (for example, inventory information, product selling data, etc.).

To make it easier and more intuitive to use barcodes and based on feedback we’ve gotten from our users in stores, we’ve added a new button to the report footer that makes it a one-click action to clear any previously scanned barcode from the report’s filter.

Learn more about scanning barcode from the mobile app

We continue to simplify the experience of using the Power BI Mobile apps, always keeping in mind the frontline workers who need quick access to their content. In this monthly update we’ve made it possible to open Power BI items in full screen, so users can view their data at its max.

Opening an item in full screen is supported both for launch items and when using a universal link.

A launch item is a Power BI item (report, page, app, etc.) that the user has selected to automatically open when they open the app. Now, you can also tell the Power BI Mobile app to open this item in full screen mode.

To set a launch item to open in full screen mode, go to:

Settings > Launch item and enable the Open in full screen toggle.

Using an MDM tool that supports an AppConfig file, mobile device administrators can also configure a launch item to be opened in full screen mode for their users.

You can also add the query parameter? fullscreen=1 to a Power BI item’s link. When you use a link with this parameter on your mobile device, the mobile app will open the item in full screen mode.

Visualizations

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

If you have multiple fields showing on your column headers, you can now decide which of these fields you want a column subtotal for.

This is in addition to the already existing features of the Financial Reporting Matrix:

Adding custom rows

Applying company/customer specific themes

Expand/collapse columns

Conditionally hide columns

+ much more

Highlighted new features:

New Format Pane design

Measure placement – In rows

Select Column Subtotals

Row Options

*Get the visual from AppSource (fix link) and find more videos here !

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

ZoomCharts has just launched the latest addition to their suite of user-friendly custom visuals – Drill Down Scatter PRO. It provides all the features you would expect from a great scatter chart visual, but what sets Scatter PRO apart is the ability to easily drill down. Simply click on a data point and see all the values underneath it.

This way, you can quickly find your answers while also gaining a full understanding of where they come from. Furthermore, the visual’s UI is designed to be smooth and user-friendly for PCs and touch devices, and with cross-chart filtering you can use Scatter PRO to build incredible reports for immersive data exploration.

Main features:

Drill Down: Create a multi-level hierarchy and drill down with just a click.

Dynamic formatting: Apply custom marker colors, shapes, or images to each data point directly from data.

Trendlines: Show a linear or polynomial regression line on the chart.

Thresholds: Display up to 4 line or area thresholds on each axis.

Area Shading: Highlight up to 8 custom areas with rectangles or ellipses.

🌐 Learn more about Drill Down Scatter PRO

Documentation | ZoomCharts Website | Follow ZoomCharts on LinkedIn

The Image Gallery is the first visual to be certified by Microsoft that allows for the display of high-quality images and their exportation along with other report content. There is no need to upload images to the Cloud, a CDN, or use any datasets. Simply import your images directly into the visual and share them instantly with your colleagues.

This visual boasts several impressive capabilities:

Microsoft certification ensures that the visual doesn’t interact with external services, ensuring that your images are securely stored and encrypted within the report, consistent with your report’s sensitivity settings.

Automatically saves your selected image in preview mode, allowing your colleagues to view the exact image you have highlighted.

Images can be uploaded or removed exclusively in Edit Mode. Users in View Mode can only view the images.

The visual is compatible with Power BI’s export functionality to PDF and PowerPoint.

Image Gallery Link

A space-saving horizontal bar chart designed with category labels placed inside the bars for clarity.

This horizontal bar chart serves as an efficient filter to navigate through your data more effectively, optimizing space by placing the category labels within the bars themselves.

Adjustable Bar Thickness and Spacing: Offers the flexibility to adjust the thickness of the bars and the spacing between them. This allows for optimal use of space and improves readability, especially when dealing with large datasets.

Tooltip Details on Hover: Displays detailed information about each category when the user hovers over a bar. This feature provides additional context and insights without cluttering the visual.

Data-Driven Category Labels: Automatically updates category labels based on the data source. This ensures that the chart remains accurate and up to date, reflecting any changes in the underlying data.

Support for Hierarchical Data: Allows users to drill down into hierarchical categories within the chart. This functionality enables a more detailed data analysis without leaving the context of the initial visual.

Export Options: Offers the ability to export the chart as an image or PDF, facilitating easy sharing and reporting outside of Power BI.

HorizontalBarChart Link

Introducing the “ Trends ” visual for Power BI – your gateway to leveraging Google Trends data for strategic business analysis. This innovative visual tool allows you to compare brand popularity, monitor market trends, and gain insights into consumer search behaviors directly within your Power BI environment.

With Trends visual, you can:

Analyze the ebb and flow of brand interest over time to identify market opportunities and competitive threats.

Compare the popularity of products to inform marketing strategies and product development decisions.

Understand seasonal trends to optimize your marketing campaigns and inventory planning.

Securely integrated and easy to use, “Trends” transforms your Power BI reports into a dynamic analysis tool, offering a comprehensive view of the market landscape. Dive into data-driven decision-making with “Trends” and stay one step ahead in the competitive business environment.

New visual: Multi-pane Card can be used to group and show data in multiple collapsible panes in Power BI reports. It is an alternative to multi-row card visual, but it can combine columns into a few groups and put each group’s data in each pane. It is suitable to show data in detail with a reduced number of report pages.

Screenshot 1 (Show data in 3 groups: Area and Population, GDP and Foreign Exchange Reserves for countries)

Data can be sorted by a specified column and numbers can be converted to a human readable string. You can also set up how many rows that you want to show on the card. Using these features, it will be very easy to show “Top 10 best performing stores” or “Top 10 worst performing stores” for retail businesses.

Screenshot2 (Combined with drilldown choropleth map to show the top 10 richest countries by GDP per capita for each continent and subregion)

You can go to Microsoft AppSource: Multi-pane Card , to download and try it.

To learn more on how to use it, please read tutorials ( https://www.mylocs.ca/tutorials.html#multi-pane-card ).

Introducing Copilot pane in Power BI Desktop (preview)

Earlier this year, we announced preview of Copilot for all customers with Premium/Fabric capacity in Power BI web . We’re thrilled to share that the same Copilot experience for report creation is now available for preview in Power BI Desktop. With our current preview, users can create reports faster and easier in the Power BI Desktop experience. You can now open the Copilot pane in report view and ask Copilot to:

Create a report page – Copilot will create an entire report page for you by identifying the tables, fields, measures, and charts that would help you get started.

Summarize a semantic model – Copilot will help you understand your Power BI semantic model by summarizing the data in your model.

Suggest a topic – Copilot will suggest topics for your report pages.

Click here to learn more about how to get started.

Shortcuts to Google Cloud Storage and S3 compatible data sources (preview) 

We are excited to announce that you can now create OneLake shortcuts to your Google Cloud Storage (GCS) buckets and S3 compatible data sources! 

With the addition of GCS, you can now utilize cross-cloud shortcuts to analyze your data across all three major cloud platforms. Shortcuts in OneLake allow you to connect to your existing data through a single unified name space without having to copy or move data. Just open Lakehouse in Fabric, create a shortcut to GCS, AWS S3 or ADLS Gen2 and immediately start analyzing your data through Spark, SQL and Power BI. 

OneLake is also adding connectivity to data sources that offer an Amazon S3 compatible API, a widely supported API offered by many distributed file systems and services that offer object storage. With this new feature, it’s quick and easy to create a shortcut that references your cloud based S3 compatible data sources. The data source endpoint simply needs to offer S3 compatible APIs, be publicly hosted and accessible, and accept the key/secret credentials you provide during shortcut creation. Once you set up your shortcut, you can access and use your data with the many Fabric engines or other services using OneLake’s open APIs . 

Learn more in our recent blog posts for S3 compatible shortcuts and GCS shortcuts ! 

OneLake data access roles (preview)

OneLake data access roles for folders are a new feature that enables you to apply role-based access control (RBAC) to your data stored in OneLake. You can define security roles that grant read access to specific folders within a Fabric item and assign them to users or groups. The access permissions determine what folders users see when accessing the lake view of the data, either through the lakehouse UX, Spark notebooks, or OneLake APIs. 

OneLake previously managed data access at the Fabric item level. Access to the OneLake data behind a Fabric item could be granted or removed for users or groups. Data access roles now allow for defining security roles that can grant access to individual OneLake folders within a Fabric item. The granted access inherits to any newly added sub-folders in a transparent manner. Role permissions and user/group assignments can be easily updated through a new folder security UX or through API calls. The security also extends to 3rd party access requests made through the OneLake APIs. 

Check out the full announcement blog or jump right into the getting started guide!  

Organizations today rely on cloud platforms for storage and analysis of data at scale and need to keep up with the accelerating volume of data while protecting sensitive information.  While enterprises in Banking, Healthcare, and similar domains require strict data security standards by default, securing business-critical data is the highest priority for all enterprises. We are excited to announce the public preview of an enhanced networking feature, Azure Private Link for Microsoft Fabric, for securing access to your sensitive data in Microsoft Fabric by providing network isolation and applying required controls on your inbound network traffic. 

Private Links enable secure connectivity to Fabric by restricting access to your Fabric tenant from an Azure VNet of your choice and blocking all public access. This ensures that only network traffic from that VNet is allowed to access Fabric experiences like Notebooks, Lakehouses, Warehouses in your tenant. 

With Azure Private Link, you can: 

• Restrict traffic from the internet to Fabric and route it through the Microsoft backbone network. 
• Ensure only authorized client machines can access Fabric. 
• Comply with regulatory and compliance requirements that mandate private access to your data and analytics services. 

While Azure private links were supported in Power BI at a tenant level, we are now extending this feature to other Fabric workloads with this release. For example, connecting to your data in Onelake using the OneLake Explorer can be protected through Private Links. Similarly, you can access Warehouses and Lakehouse SQL endpoints in SQL Managed Studio via Private Links. A list of supported scenarios and limitations can be found at Use private link to access Fabric. for detailed instructions, please refer to How to set up private endpoints to access Fabric . 

We are excited to announce the public preview of Managed Private Endpoints for Microsoft Fabric. This feature allows secure connections to data sources that are behind a firewall or not accessible from the public internet. Managed Private Endpoints enable Fabric Data Engineering items to access data sources securely without exposing them to the public network or requiring complex network configurations. These private endpoints provide a secure way to connect and access data from sources like Azure SQL DB or Storage account blocked from public access from your Fabric Spark Notebooks or Spark Job Definitions. 

Workspaces with managed private endpoints have network isolation through a dedicated managed virtual network. These managed virtual networks (Managed VNETs) separate the Spark compute clusters from the shared virtual network and enable network security features such as private links and managed private endpoints. Microsoft Fabric takes care of the provisioning and management of the virtual networks and private endpoints, so users do not have to create or manage these network infrastructure resources themselves. 

By just providing connection details, your managed private endpoint is instantly provisioned in the Managed VNET and a request for private endpoint access is submitted to the data source administrator for approval.  

Users can track the status and approval process of the managed private endpoints from the Network security section of the Workspace settings. 

Managed Private Endpoints support various data sources, including Azure Storage, Azure SQL Database, Azure Synapse Analytics, Azure Cosmos DB, Application gateway, Azure Key Vault, and many more. 

Learn more about the data sources supported, please refer to our documentation Create and use managed private endpoints in Microsoft Fabric (preview) – Microsoft Fabric | Microsoft Learn  

Note: Managed private endpoints are only supported for Fabric Trial capacity and Fabric capacities F64 or higher SKUs.  

To learn more about the benefits, detailed steps of setup and limitations of managed private endpoints in Microsoft Fabric, please refer to our documentation Overview of managed private endpoints in Fabric.   

To learn more about network isolation offered by managed virtual networks, please refer to Overview of managed virtual networks in Fabric . 

Trusted Workspace Access for OneLake Shortcuts 

Trusted workspace access allows you to securely access firewall-enabled Storage accounts. With Trusted workspace access, you can create OneLake shortcuts to Storage accounts, and then use the shortcuts in various Fabric items, such as Spark notebooks, SQL analytics endpoints, semantic models, reports, data pipelines, and dataflows Gen2.   

Trusted workspace access is designed to help you securely and easily access data stored in Storage accounts from Fabric workspaces, without compromising on performance or functionality. You can leverage the power and flexibility of Fabric and OneLake to work with data in place without compromising on security. 

How does Trusted workspace access work? 

Trusted workspace access is based on the concept of workspace identity, which is a unique identity that can be associated with workspaces that are in Fabric capacities. When you create a workspace identity, Fabric creates a service principal in Microsoft Entra ID to represent the identity.   

Workspace identity enables OneLake shortcuts in Fabric to access Storage accounts that have resource instance rules configured. Resource instance rules are a way to grant access to specific resources based on the workspace identity or managed identity. You can create resource instance rules by deploying an ARM template with the resource instance rule details.  

To leverage Trusted workspace access in Fabric workspaces, you can create a OneLake shortcut in a Lakehouse, and provide the URL of the Storage account that has been configured with a resource instance rule. While creating the shortcut, you need to select organizational account or service principle for authentication and ensure that the principle used for authenticating to Storage has the appropriate Azure RBAC roles on the Storage account. Once the shortcut is created, you can use it in various Fabric items. 

How to get started with Trusted workspace access?

Trusted workspace access is available for workspaces in Fabric capacities (F64 or higher). To get started with Trusted workspace access, you need to do the following steps:  

• Create a workspace identity for your Fabric workspace if you don’t have one already. If you face issues with creation of the workspace identity, follow the troubleshooting guidelines provided here . 

Create a workspace identity. 

2. Configure resource instance rules for the Storage account that you want to access from your Fabric workspace. Follow the guidelines for configuring resource instance rules for Fabric workspaces here . 

Resource instance rules in a Storage account 

• Create a OneLake shortcut to the Storage account in a Lakehouse and select the organizational account or service principal option for authentication.   

Create an ADLS g2 shortcut in a Lakehouse. 

4. Use the OneLake shortcut in various Fabric items, such as Spark notebooks, SQL analytics endpoints, semantic models, reports, data pipelines, and dataflows Gen2.  

Access data stored in firewall-enabled Storage accounts through OneLake shortcuts. 

For more details and guidance on how to use Trusted workspace access, please refer to the documentation links below.  

• Trusted workspace access in Fabric  
• Workspace identity in Fabric  

Data Warehouse 

Git integration .

We are excited to announce the Git integration for the Warehouse! This feature allows you to check in the changes of your Warehouse into an Azure DevOps Git repository as a SQL database project. Git integration enables source control capabilities for developers to integrate their development processes, tools, and best practices directly into the Fabric platform. 

Some scenarios that are enabled by Git: 

• Backup and version development work 
• Revert to previous stages 
• Collaborate with others or work alone using Git branches 
• Apply the capabilities of familiar source control tools to manage your Warehouse 
• Commit changes 
• Sync changes from Git 
• Manage conflict resolutions 
• …and many more! 

The SQL analytics endpoint of a Lakehouse uses partition elimination to read data from only those partitions that are relevant to the query. Recent improvements have boosted performance even more when queries are aimed at a few partitions in a table that has many files. 

We are thrilled to announce Mirroring in Fabric for Azure SQLDB, CosmosDB and Snowflake is in Public Preview!  

Mirroring in Fabric allows users to enjoy a highly integrated, end-to-end, and easy-to-use product that is designed to simplify your analytics needs. Built for openness and collaboration between Microsoft, and technology solutions that can read the open-source Delta Lake table format, Mirroring is a low-cost and low-latency turnkey solution that allows you to create a replica of your Azure SQL DB, Snowflake or CosmosDB data in OneLake which can be used for all your analytical needs. Learn more

Data Engineering 

Optimistic job admission for fabric spark.

We are excited to announce a new feature for Fabric Spark: Optimistic Job Admission. This feature aims to reduce the frequency of throttling errors (HTTP 430: Spark Capacity Limit Exceeded Response) and improve the job admission experience for our customers, especially during peak usage hours.  

Throttling errors on Spark workload occur when the Spark usage exceeds the Fabric capacity limits. In the current job admission policy, Fabric Spark reserves the maximum number of cores that a job may need during its execution, based on the maximum number of nodes that the job can scale up to. This ensures that the job will always have enough resources to run, but it also limits the number of concurrent jobs that can be admitted in the cluster. 

With Optimistic Job Admission, Fabric Spark only reserves the minimum number of cores that a job needs to start, based on the minimum number of nodes that the job can scale down to. This allows more jobs to be admitted if there are enough resources to meet the minimum requirements. If a job needs to scale up later, the scale up requests are approved or rejected based on the available cores in capacity.  

Optimistic Job Admission can significantly increase the max number of concurrent jobs for our customers, especially for those who use large SKUs. For example, if a customer is using F32 SKU, which has 64 Spark VCores (Based on 1 CU = 2 Spark VCores) and 192 Max Burst Cores for concurrency (based on the 3X burst multiplier), they can only run 3 jobs concurrently in the current job admission policy, assuming they have the default starter pool configuration. 

Now with Optimistic Job Admission, they can run up to 24 jobs concurrently with the same configuration. This is an 8x improvement!

We hope that this feature will help you run more jobs faster and more efficiently on Fabric Spark. 

Single Node Support for Starter Pools 

Do you hate waiting for your Spark sessions to start in starter pools with single node configuration? If yes, you will love the update on single node starter pool support. This feature lets you set your starter pool to max one node and get super-fast session start times for your Spark sessions. With this new support that’s been introduced, the system allocates the driver and executor with 4 cores each and 56 GB in memory, so that they fit within a single medium node configuration for Starter Pools. This improves session start times to 5 seconds in single node starter pool configurations. 

How can you use it? 

To use this feature, follow these steps: 

• Go to your Fabric workspace and choose the Workspace settings. 
• Select the Data Engineering/Science option to expand the menu. 

• Select the StarterPool option from the Pool selection and click on Edit. 

• Set the maximum node configuration for your starter pools to 1.

• Save your changes and enjoy super-fast session start times for your Spark sessions.

Container Image for Synapse VS Code

To simplify the development process for Synapse VS Code extension, we have released a container image that contains all the necessary dependencies for the extension ( Microsoft Artifact Registry) . This image is available in Microsoft artifact repository and can be pulled with a single command. By using this image, you do not need to install Java, Miniconda, or any other tools on your local machine. You can work on your Synapse projects inside the container environment, which is isolated and consistent. 

We have also integrated the container image with VS Code dev container feature, which allows you to open a folder or a repository inside a container and use the VS Code editor and extensions as usual. To use this feature, you need to install the Remote – Containers extension and create a devcontainer.json file in your project folder. We have provided a sample devcontainer.json file that you can use as a template or customize according to your needs ( SynapseVSCode/samples/.devcontainer at main · microsoft/SynapseVSCode (github.com) ). The dev container feature will automatically pull the container image, mount your project folder, and launch the VS Code editor inside the container. You can then enjoy the full functionality of the Synapse VS Code extension without any hassle. 

Git Integration with Spark Job Definition

We are excited to announce the Git integration for Spark Job Definition artifacts. This feature allows you to check in the changes of your Spark Job Definitions into a Git repository, which will include the source code of the Spark jobs and other artifact properties. By using Git as a version control system, you can track the history of your Spark Job Definitions, collaborate with other developers, and implement CI/CD workflows for your Spark projects. 

The Git integration for Spark Job Definition artifacts is designed to enhance your development experience and enable CI/CD scenarios for your Spark projects. We hope you find this feature useful, and we welcome your feedback and suggestions. 

When a new Spark Job Definition is made with a PySpark script as the main definition file, the Git status shows that this is an unsaved change that needs to be committed.

Once the change is finalized mich

The structure of the linked git repository and the file containing the source code that was submitted.

New Revamped Object Explorer experience in the notebook  

We are excited to announce the release of a revamped object explorer experience. The new experience is designed to improve flexibility and discoverability of data sources in the explorer and improve the discoverability of Resource folders. 

Try it out and add new Data sources clicking on the +Data sources button and upload new modules or create folders by clicking on the Resources folder and let us know what you think.   

%Run your scripts in Notebook  

Now you can use %run magic command to run your Python scripts and SQL scripts in Notebook resources folder, just like Jupyter notebook %run command. By this way you can easily reuse common modules that developed from your local IDE and use them in your Fabric Notebooks conveniently. We also introduced different command parameters to make sure complex cases such as reference run and high concurrency mode can be covered without friction, stay tuned for the best practice example for the usage! 

Data Science 

Semantic link is now ga  .

Semantic links are now generally available! The package comes with our default VHD, you can now use Semantic link in Fabric right away without any pip installation. Check it out .  

We introduced a new feature in December 2023 that allows tenant admins to enable AI and Copilot in Fabric for certain security groups in addition to the entire organization. Today, we are excited to announce that you can enable AI and Copilot for a specific Capacity. You can test Copilot at a certain capacity without impacting other workloads. This allows you to adapt Copilot to meet the needs of different groups in your organization and manage your capacity more effectively. 

AI and Copilot in Fabric are powered by large language models that are only available in limited datacenters. Previously, users who were not in US and France had to turn on the cross-geo setting to use AI and Copilot. Since mid-March, we updated the cross-geographic mapping logic, EU customers can use AI and Copilot without turning on the cross-geo setting, and their AI and Copilot requests will be processed within EUDB. Check it out ! 

Real-time Analytics

New kql queryset command bar.

Finding the commands for the actions you are trying to perform just got easier with our latest update to the KQL Queryset. Now, it’s easy to distinguish between actions applicable at the Queryset level and the single query level. 

Introducing a secondary command bar within the query editor dedicated to hosting query-level actions. Enjoy smoother navigation and streamlined functionality for a more efficient querying experience. 

New Update Command Public Preview  

The new update command is now in public preview! 

This allows you to update existing records in a Kusto Table.  This can be useful to fix ad hoc data issues or be integrated into a data loading pipeline.  The command has a “what if” mode to try a command before running it on your data. 

.update table Employees on Id <| 

  MyStagingTable 

  | where true 

Introducing Pause and Resume Feature in Eventstream   

We’re excited to introduce a powerful new feature in Fabric Eventstream: The Pause and Resume Feature. This powerful capability empowers you with unprecedented control over your data streams, enabling you to pause data streaming from various sources and destinations within Eventstream. You can then resume data streaming seamlessly from the paused time or a customized time, ensuring no data loss. 

Key Features: 

• Activate/Deactivate All : You can quickly pause and resume all data traffic flowing in and out of Eventstream with the Activate All and Deactivate All options on the menu bar. 
• Toggle Switch Button : Each node has a convenient toggle switch button, allowing you to activate or deactivate any data source from streaming in or out of Eventstream with ease. 

With the Pause and Resume feature in Fabric Eventstream, you can pause traffic from specific sources and destinations whenever needed. Whether it’s for troubleshooting purposes, building proof-of-concepts with test data, or minimizing unnecessary data processing costs, this feature offers unparalleled control over your data streams and leads to more efficient resource allocation.

Fabric Real-Time Analytics Integrates with Newly Announced Database Watcher for Azure SQL (preview)  

Azure SQL family users can now take advantage of an enhanced monitoring solution for their databases and leverage Microsoft Fabric integration. With the introduction of the new Database Watcher for Azure SQL (preview), users gain access to advanced monitoring capabilities. Through integration with Microsoft Fabric, they can effortlessly stream, store, and analyze monitoring data in real-time using an Eventhouse database in Fabric Real-Time Analytics. This integration enables users to stay informed about their database performance and make timely, informed decisions. 

Database watcher is a new managed monitoring solution for database services in the Azure SQL family. It supports Azure SQL Database and Azure SQL Managed Instance. 

Database watchers collect in-depth workload monitoring data to give you a detailed view of database performance, configuration, and health. Monitoring data from the databases, elastic pools, and SQL managed instances you select is collected in near real time into a central data store. To store and analyze SQL monitoring data, database watcher uses an Eventhouse database in Fabric Real-Time Analytics (as a complement option, Azure Data Explorer is also supported). 

Dashboards in Azure portal provide a single-pane-of-glass view of your Azure SQL estate and a detailed view of each database, elastic pool, and SQL managed instance. 

A conceptual diagram of a database watcher deployment, showing the flow of monitoring data from Azure SQL resources to a database watcher.  The monitoring data is stored in Fabric Real-Time Analytics .  Dashboards in the Azure portal show you a single-pane-of-glass view across your Azure SQL estate, and a detailed view of each database, elastic pool, and managed instance.    

You can query data in your Eventhouse database in Real-Time Analytics using KQL or T-SQL , analyze and model your data using Real-Time Analytics Querysets or Fabric Notebooks , build custom visualizations using KQL built-in visualizations or Power BI . 

To analyze collected monitoring data, the recommended method is to use KQL. KQL is optimal for querying telemetry, metrics, and logs. It provides extensive support for text search and parsing, time-series operators and functions, analytics and aggregation, and many other language constructs that facilitate data analysis. You can find examples of analyzing database watcher monitoring data with KQL in the documentation . 

The dashboards, complemented by KQL queries, enable you to delve deep into the performance and configuration of your databases. This means you can detect, investigate, and troubleshoot a wide variety of database performance and health issues. 

Whether you’re tackling resource bottlenecks or fine-tuning your Azure SQL resources for the best balance of cost and performance, Database Watcher equips you with the insights needed to make informed decisions. It’s your pathway to optimizing your Azure SQL setup for peak efficiency and cost-effectiveness. 

Next steps  

One effective approach to grasp the potential and the power of Database Watcher is to give it a try yourself. Set up your Azure SQL resources with Database Watcher, explore the dashboards, and start running some queries with KQL.  To read more about Database Watcher, check out the documentation . 

Data Factory 

Dataflows gen2 , fast copy  .

Dataflows help with ingesting and transforming data. With the introduction of dataflow scale out with the SQL DW compute, we are able to transform your data at scale. However, to do this on a scale, your data needs to be ingested first.  

With the introduction of fast copy, you can ingest Terabytes of data with the easy experience of dataflows, but with the scalable back end of Pipeline’s Copy Activity. 

We released support for Azure Service Principals (SPN) as an authentication kind last year. Now we’ve added support for this new authentication kind for on-premises data gateways and VNET data gateways.  

Azure service principal is a security identity that is application based and can be assigned permissions to access your data sources. Service principals are used to safely connect to data, without a user identity. Learn more about service principals.  

You can learn how to leverage the service principal authentication kind from the documentation available and leverage this in multiple connectors such as Azure Data Lake Storage, Dataverse, Azure SQL database, Web connector and more. 

Certified connector updates  

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

• [New] Topcon Aptix Insights 
• [Update] BitSight Security Ratings 
• [New] Zendesk Data 
• [Update] Planview OKR 
• [Update] BQE Core 
• [New] LinkedIn Learning 
• [New] LEAP 
• [New] Samsara 
• [Update] Celonis EMS 
• [New] Supermetrics 
• [New] Exact Online Premium 

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 . 

Data pipelines 

We are excited to announce the availability of the Spark job definition activity for data pipelines. With this new activity, you will be able to run a spark job definition in your pipeline.  

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

The Data pipeline homepage is now updated with an all-new look! You’ll now find new guidance cards to help you find what you’re looking for more quickly.  

Pipeline support for CI/CD in public preview

When developing workflows with Data Factory’s pipelines it is very important for developers to be able to save their work in a Git repository for versioning, source control, and CI/CD. We are happy to announce the public preview of CI/CD support for Data Factory pipelines! Now, you can connect your Azure DevOps (ADO) projects to your Fabric workspace and commit, merge, and branch your pipelines using Fabric’s Git integration. Additionally, you can now use the built-in Deployment Pipelines inside Fabric to assign workspaces to different environments (dev, test, prod) and promote your changes easily without using ADO! 

Data Factory Data Pipelines APIs 

You can now use our public APIs to create, execute, and monitor data pipelines in Fabric Data Factory. 

Increase in Pipeline activity limit 

As a cloud service for analytics workflows, the Data Factory team has had a limit of 40 activities per pipeline since the early days of Azure Data Factory. The same orchestration engine drives Fabric Data Factory data pipelines and we’ve reacted to your feedback that many times you need more than 40 activities in a pipeline to perform complex workflows that require error checks, branching, and other control flow capabilities. We’ve now updated the limits for the Data Factory pipeline service in both Fabric and Azure (Azure Data Factory & Synapse pipelines) to now allow up to 80 activities per pipeline. 

Fabric Warehouse in ADF copy activity  

We’re excited to announce that you can now connect to your Fabric Warehouse from Azure Data Factory/Synapse pipeline. You can find this new connector when creating a new source or sink destination in your copy activity.  

This connector is also supported in the Lookup activity, Stored Procedure activity, Script activity, and Get Metadata activity.  

Edit column type to destination table support added to Fabric Warehouse and other SQL data stores 

When moving data from any supported data sources into Fabric Warehouse or other SQL data stores (SQL Server, Azure SQL Database, Azure SQL Managed Instance; Azure Synapse Analytics) via data pipelines, users can now specify the data type for each column under the destination table, as well as customize the precision and scale to certain data types such as decimal, numeric, etc.  

SFTP: performance improvements when writing data to SFTP 

SFTP connector has been improved to offer better performance when writing to SFTP as destination.  

Related blog posts

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”

Microsoft Fabric February 2024 Update

Welcome to the February 2024 update. We have a lot of great features this month including Fabric Git Integration REST APIs, Fabric notebook status bar upgrade, Copilot in Dataflow Gen2, and many more! Fabric Community Conference Join us at the Microsoft Fabric Community Conference the ultimate Microsoft Data & AI learning event, on March 26-28, … Continue reading “Microsoft Fabric February 2024 Update”