power bi video presentation

May 26, 2022

Interactive data storytelling with Power BI in PowerPoint

Camille Birch

• Add our blog to your RSS feed reader" href="/rss/blog.xml" data-bi-name="RSS Subscription" data-bi-id="rss_feed" data-bi-bhvr="120" data-bi-socchn="RSSSubscription" title="Microsoft 365 Insider Blog RSS" target="blank" class="d-inline-block">

Hi, Office Insiders! My name is Camille Birch, and I’m a Product Manager on the PowerPoint team. I’m incredibly excited to share that PowerPoint now supports embedding live, interactive Power BI reports right into your slides! 

Interactive data storytelling with Power BI

By embedding live Power BI reports in your slides, you can tell interactive, data-focused stories. No more copying and pasting inevitably out-of-date screenshots or switching between your PowerPoint slides and your Power BI report during a presentation. You can now build narratives around your data and drive meaningful conversations through interactive reports right in PowerPoint.  

This feature is a long-standing customer request. We are happy to bring it to you and support your growing needs for data storytelling in increasingly data-driven workplaces and cultures. 

How it works

• Open a new or existing presentation in PowerPoint. 

NOTE: If you don’t see the Power BI button in the ribbon, you can get the add-in from the Microsoft App Store. 

• Copy the link to the Power BI report you want to insert, paste it into the Pa st e report page URL here box, and then select Insert .

When the report has been loaded into the slide, it is live and interactive both in Edit and Slide Show view. Any change that you make in Edit view–such as updating a slicer or changing a filter–is automatically saved. So feel free to customize the view of the data you want to present in advance. 

You can also filter and pivot to different views of the data to showcase key points and insights.

Tip and tricks

• If you want your data view to remain static (to prevent data refresh or changes to filters/slicers), you can freeze the current live view to turn it into an image. In the top-right corner of the report, open the menu and select Show as Saved Image . This will convert the report view into an image until you select this option again to unfreeze it.
• To view the interactive data during your presentation, attendees will need to have a Power BI subscription and be logged in with an active account, and have access to the report (unless you’ve frozen the view as an image, as discussed above). To ensure that anyone you share the presentation with will have access to the report, share a link from Power BI by clicking Share > PowerPoint .  

Known issues

• Reports are not interactive in PowerPoint Live. 
• When viewing the Power BI report in Slide Show view in PowerPoint for web, you may be prompted to authenticate. 
• The presentation will not inherit the sensitivity label assigned to the Power BI report when inserted. For example, if a Power BI report labeled as Confidential is inserted into a presentation labeled as Public, the presentation’s label will not change and will remain as Public. 

Requirements

You must have an active Power BI subscription to use this feature.

Availability

The Power BI ribbon button in PowerPoint is rolling out to Insiders who are running Beta Version 2201 (Build 14825.10000) or later.

All users can install the Power BI add-in from the Microsoft App store.

Don’t have it yet? It’s probably us, not you.

Features are released over some time to ensure things are working smoothly. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as an Insider, have had the opportunity to try it.

We want to hear from you! Please click Help > Feedback to give us input about this feature. 

Learn what  other information you should include in your feedback  to ensure it’s actionable and reaches the right people.

Sign up for the Office Insider newsletter  and get the latest information about Insider features in your inbox once a month! 

Sorry, JavaScript must be enabled to use this app.

• Courses Business Charts in Excel Master Excel Power Query – Beginner to Pro Fast Track to Power BI View all Courses
• For Business

• Power Excel
• Dashboards, Charts & Features
• VBA & Scripts

Business Charts in Excel course is NOW AVAILABLE! Discover more

Create Business charts that grab attention AND auto-update. Wow your coworkers and managers with smart time-saving techniques.

Power Query is essential for Excel users who work with lots of data. This course teaches you how to use Excel in Power Mode and create meaningful reports with far less effort.

Stay ahead of the game in 2024. Get access to our best-selling Power BI course now and become a highly sought-after Power BI professional. This course gets you started in Power BI – Fast!

Present Power BI Reports in PowerPoint

Building a super-cool Power BI dashboard with full interactivity (slicers, bookmarks, drill-through, etc.) can be quite satisfying.

But what do you do if you need to present this interactive dashboard in a meeting where PowerPoint is your only means of presentation?

Power BI does have a feature that allows you to export the screen as an image, but the image lacks all the wonderful interactivity.  Plus, if you must give the presentation at a later date, you’ll need to update all the exported images because the data will likely have changed.

Hope is just around the corner.

Power BI released a feature that allows you to export the dashboard to PowerPoint while retaining most if not all the functionalities.

Let’s give a warm, XelPlus welcome to  Embed Live Data .

Watch video tutorial

In this tutorial:

• Obtaining the Power BI Add-In for PowerPoint
• Testing Report Interactivity
• Adding a Power BI Report to an Existing Presentation
• Deeper Analysis During a Presentation
• Additional Presentation Features
• Sharing the Report

Working with the Power BI service online, we have a dashboard with the following interactive features:

• Slicers that allow us to filter by years
• Buttons that switch us between pages
• Slicers that allow us to select departments and channels

We want to export this dashboard to PowerPoint and retain interactivity.

Power BI now has an option behind the  Export  button called  Embed Live Data .

When selected, we have the option to open the dashboard in PowerPoint with or without the current filter selections.

NOTE:  As of this post’s publish date (July 2022), this feature was still in preview release.  It has since become generally available with the March 2023 release .

Selecting the  Open in PowerPoint  option presents the following message.

Clicking the “ Trust this add-in ” will load the Power BI report into a PowerPoint slide.

Featured Course

Fast Track to Power BI

We need to take a step back and talk about obtaining the Power BI add-in for PowerPoint.

Before we can just drop a Power BI report into PowerPoint as easily as has been demonstrated, you need to first visit the Microsoft Store and download and install the Power BI add-in for PowerPoint.

• Launch the Microsoft Office Add-Ins feature by selecting  Insert (tab) -> Add-ins -> Get Add-ins .
• Search the Office Add-Ins for “ Power BI ”.

Once added to PowerPoint, you will see the add-in on the  Insert  ribbon.

Power Excel Bundle

By having the Power BI add-in as part of PowerPoint, we have full interactivity in our PowerPoint slide, both in Presentation Mode and standard Slide Design Mode.

Notice that the only page we have from our report was the page displayed when we performed the  Embed Live Data  action.

If you need other pages from the report, those pages will need to be inserted separately.

One workaround to this is to include a page navigation interface on the needed pages.

Buttons and bookmarks are fully operational.

Excel Essentials for the Real World

When working with an existing presentation, we can easily add a Power BI report by creating a new, blank slide and selecting  Insert (tab) -> Power BI .

Our slide presents a placeholder that requests the link we saw earlier from the Power Bi service when we perform the initial export routine.

Click the  Copy  button to place the Power BI report link on the Clipboard.

Return to PowerPoint and paste the link in the placeholder and click  Insert .

In addition to the report’s slicers and buttons working during the presentation, we can also leverage Power BI’s filter controls.

This embedded report is arguably superior to embedding Excel dashboards as Excel’s interactivity does not carry over to PowerPoint.

Capturing a Screenshot

If you need to capture a screenshot of the report during the presentation, click the arrow button in the upper-right corner and select  Show as Saved image .

You can then right-click the report and copy it to the Clipboard for pasting it onto another slide or any other application.

To return to the interactive version of the report, click the arrow button in the upper-right corner and deselect  Show as Saved image .

Report Options

In the lower-right corner reside controls for hiding the filter pane, refreshing the data, and resetting the report.

Changing the Report’s Story

Any changes made to the Power Bi report in the PowerPoint slide  do not  flow back to Power BI.

However, changes to the Power BI report at the source  will  flow down to PowerPoint when the slide link is refreshed.

Deleting a Report from a Slide

Clicking a Power BI report on a slide and pressing the  Delete  key will not remove the report from the slide.

To remove the report from the slide, click the arrow button in the upper-right corner and select  Delete .

Hiding the Status Bar

If you don’t wish to display the bottom banner with the report add-in controls, click the down-arrow button in the lower-right of the report.

Viewing Report Status

The lower-left corner of the report displays the name of the Power BI report file as well as the date and time of the last refresh.

Clicking the report’s name will take you to the full report on the Power BI website.

If you share the report with an associate, the person with which you are sharing must have a Power BI account and have been granted access to the report and its underlying dataset.

The report and its data are not stored in the PowerPoint file, only a connection is created between PowerPoint and Power BI.  The interactivity is displayed in real-time as the presentation is being used.

All security permissions are retained and respected.

Leila Gharani

I'm a 6x Microsoft MVP with over 15 years of experience implementing and professionals on Management Information Systems of different sizes and nature.

My background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert, SAP BW Project Manager. My passion is teaching, experimenting and sharing. I am also addicted to learning and enjoy taking online courses on a variety of topics.

Need help deciding?

Find your ideal course with this quick quiz. Takes one minute.

Master Excel Power Query – Beginner to Pro

Featured tutorials.

Black Belt Excel Package

You might also like...

Import Power BI Data into Excel

How to Add a Slicer in Power BI

Power BI – How to add Drill Through to Reports

EXCLUSIVE FREE NEWSLETTER

Join between the sheets.

Kickstart your week with our free newsletter covering Excel hacks, Power BI tips, and the latest in AI. You get to stay updated and get all the insights you need, delivered straight to your inbox.

You can unsubscribe anytime of course.

Stay Ahead with Weekly Insights!

Dive into Excel, AI and other essential tech news:

carefully crafted for the modern professional.

Success! Now check your email to confirm your subscription.

There was an error submitting your subscription. Please try again.

TechRepublic

Account information.

Share with Your Friends

How to integrate Power BI reports with a presentation in Microsoft PowerPoint

Your email has been sent

If your organization is using Microsoft Power BI mobile, you have access to a lot of data via interactive reporting. That information is vital when making decisions and presenting growth, goals, and other benchmarks to others in your organization. Now Power BI reports are easier than ever to share because you can add them to Microsoft PowerPoint presentations.

SEE: Windows, Linux, and Mac commands everyone needs to know (free PDF) (TechRepublic)

In this tutorial, I’ll show you how to share Power BI reports as live reports or embedded images working from PowerPoint or Power BI mobile. Working with existing Power BI reports will save you a lot of preparation time.

This feature is available to Microsoft 365 and Power BI mobile users.

How to get the Power BI add-in for Microsoft PowerPoint

You may already have this feature in PowerPoint. Click the Insert tab and look for the Power BI group in the middle of the ribbon. Click the button to add a frame and start the process.

If you don’t find that button, download Power BI as follows:

• Click the Insert tab.
• In the Add-ins group, click Get Add-ins.
• In the resulting dialog, search for Power BI.
• Choose Microsoft Power BI, as shown in Figure A , and click OK. Downloading might take a few seconds.

Regardless of whether you used the Power BI button or the add-in, you’re now ready to link to the report. To do so, access the report online using Power BI mobile, paste its URL into the add-in control, as shown in Figure B , and click Insert. Allow a few seconds for this feature to link to the appropriate report.

Figure C shows the resulting report in a PowerPoint slide. During the show, you can filter the reports as if you were using Power BI mobile. In addition, the link is live, so as you update information via the data source, the link updates the reports in PowerPoint. To embed another report, you will need to download a new add-in frame or click the Power BI button via the PowerPoint interface.

You don’t have to start with PowerPoint. You can also share the report from Power BI mobile to PowerPoint.

How to share a Power BI report to Microsoft PowerPoint

If you prefer to start with Microsoft Power BI mobile, open the report and then use Share or Export. Both options offer a PowerPoint choice and end up displaying the dialog shown in Figure D .

After copying the link, open PowerPoint and insert the URL in a Power BI frame as you did above.

The difference with this route is that Export lets you embed the report as an image, which won’t update, or a live link, which will. Share lets you send a link to people via email or open the report in a new PowerPoint file.

Using either Export or Share you can bypass the add-in download task by clicking Open in PowerPoint ( Figure D ). Doing so opens a new .pptx file and imports the report into a slide without downloading the add-in frame first.

Sharing in Microsoft PowerPoint

Those with which you share the PowerPoint presentation will need an active Power BI account and access to the report to view the data in the presentation. Use the Share option to PowerPoint shown in the previous section.

Users without permission must request access to the report from its owner directly from inside the PowerPoint presentation.

Thanks to this new connection capability between Microsoft Power BI and Microsoft PowerPoint, you can share your data’s story in your PowerPoint presentations using existing Power BI reports. That link is live, so regardless of when you share that story, your reports will be up to date. For working efficiently, you can’t beat this combination.

Subscribe to the Developer Insider Newsletter

From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays

• Windows 11 cheat sheet: Everything you need to know
• Windows PowerToys: A cheat sheet
• Google Workspace vs. Microsoft 365: A side-by-side analysis w/checklist
• Best software for businesses and end users

Create a TechRepublic Account

Get the web's best business technology news, tutorials, reviews, trends, and analysis—in your inbox. Let's start with the basics.

* - indicates required fields

Sign in to TechRepublic

Lost your password? Request a new password

Reset Password

Please enter your email adress. You will receive an email message with instructions on how to reset your password.

Check your email for a password reset link. If you didn't receive an email don't forgot to check your spam folder, otherwise contact support .

Welcome. Tell us a little bit about you.

This will help us provide you with customized content.

Want to receive more TechRepublic news?

You're all set.

Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add [email protected] to your contacts list.

• Power BI forums
• News & Announcements
• Get Help with Power BI
• Report Server
• Power Query
• Mobile Apps
• DAX Commands and Tips
• Custom Visuals Development Discussion
• Health and Life Sciences
• Power BI Spanish forums
• Translated Spanish Desktop
• Power Platform Integration - Better Together!
• Power Platform Integrations (Read-only)
• Power Platform and Dynamics 365 Integrations (Read-only)
• Training and Consulting
• Instructor Led Training
• Dashboard in a Day for Women, by Women
• Community Connections & How-To Videos
• COVID-19 Data Stories Gallery
• Themes Gallery
• Data Stories Gallery
• R Script Showcase
• Webinars and Video Gallery
• Quick Measures Gallery
• 2021 MSBizAppsSummit Gallery
• 2020 MSBizAppsSummit Gallery
• 2019 MSBizAppsSummit Gallery
• Custom Visuals Ideas
• Upcoming Events
• Community Blog
• Power BI Community Blog
• Custom Visuals Community Blog
• Community Support
• Community Accounts & Registration
• Using the Community
• Community Feedback

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge .

Data Presentation

• Subscribe to RSS Feed
• Mark Topic as New
• Mark Topic as Read
• Float this Topic for Current User
• Printer Friendly Page
• All forum topics
• Previous Topic

• Mark as New
• Report Inappropriate Content

Helpful resources

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

This browser is no longer supported.

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

View reports and dashboards in presentation mode on Windows devices

• 9 contributors

The Power BI Windows app was retired on December 31st, 2023, and is no longer supported. It's been removed from the Microsoft apps store, and no further product updates for it will be released. Please use the Power BI service to view your Power BI content on Windows devices.

This notice only applies to the Power BI Windows app. It does not affect the Power BI Desktop app.

You can use presentation mode to display reports and dashboards in full-screen on Windows devices. Presentation mode is useful for displaying Power BI at meetings or conferences, or on a dedicated projector at the office, or even just for maximizing space on a small screen.

In presentation mode:

• All the "chrome" (such as the navigation and menu bars) disappears, making it easier to focus on the data in your report.
• An action toolbar becomes available to enable you to interact with your data and to control the presentation.
• You can play a slideshow that cycles automatically between pages, bookmarks, or both pages and bookmarks.

Use presentation mode

From the toolbar you can tap to perform the following actions:

You can undock the toolbar and drag and drop it to anywhere on the screen. This is useful for large screens, when you want to focus on a specific area in your report and want to have the tools available next to it. Just place your finger on the toolbar and swipe it into the report canvas.

You can play a slideshow to automatically cycle through your presentation. You can set the slideshow to cycle through pages, bookmarks, or both pages and bookmarks. During the slideshow, report pages with auto page refresh will continue to automatically refresh as configured, ensuring that the most current data is always shown.

When you select the Play button on the action toolbar, the slideshow begins. A controller appears that allows you to pause the slideshow or to change what's being played: pages, bookmarks, or both pages and bookmarks.

The controller shows the name of the currently displayed view (page or bookmark and page). In the image above, we see that in the report called Sales , we are currently viewing the Asia Pacific bookmark on the Sales Performance page.

By default, a slideshow cycles through pages only, at a rate of one every 30 seconds. You can change the default behavior in the Slideshow settings .

Auto play a slideshow on startup

You can set up the Power BI Windows app to start playing a slideshow automatically whenever the app is launched. This option is useful for creating a kiosk-like experience that runs a report in public displays without any manual intervention. See Slideshow settings for detail about setting up a report for autoplay.

Slideshow settings

By default, a slideshow cycles through pages only, at a rate of one every 30 seconds. You can change this default behavior by going to Settings > Options , as illustrated below. You can also turn on autoplay and choose a report to play.

Select the settings icon.

Open the options page.

If desired, change the default settings for what the slideshow will cycle over (pages, bookmarks, or both) and how frequently the slides will transition.

If you want your report to start playing automatically when the app is launched, turn on the toggle and choose Select Report . You will be able to search for reports you have access to.

Related content

• Display dashboards and reports in full-screen mode from the Power BI service
• Questions? Try asking the Power BI Community

Was this page helpful?

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

Submit and view feedback for

Additional resources

• Skip to main content
• Keyboard shortcuts for audio player

The huge solar storm is keeping power grid and satellite operators on edge

Geoff Brumfiel

Willem Marx

NASA's Solar Dynamics Observatory captured this image of solar flares early Saturday afternoon. The National Oceanic and Atmospheric Administration says there have been measurable effects and impacts from the geomagnetic storm. Solar Dynamics Observatory hide caption

NASA's Solar Dynamics Observatory captured this image of solar flares early Saturday afternoon. The National Oceanic and Atmospheric Administration says there have been measurable effects and impacts from the geomagnetic storm.

Planet Earth is getting rocked by the biggest solar storm in decades – and the potential effects have those people in charge of power grids, communications systems and satellites on edge.

The National Oceanic and Atmospheric Administration says there have been measurable effects and impacts from the geomagnetic storm that has been visible as aurora across vast swathes of the Northern Hemisphere. So far though, NOAA has seen no reports of major damage.

The Picture Show

Photos: see the northern lights from rare, solar storm.

There has been some degradation and loss to communication systems that rely on high-frequency radio waves, NOAA told NPR, as well as some preliminary indications of irregularities in power systems.

"Simply put, the power grid operators have been busy since yesterday working to keep proper, regulated current flowing without disruption," said Shawn Dahl, service coordinator for the Boulder, Co.-based Space Weather Prediction Center at NOAA.

NOAA Issues First Severe Geomagnetic Storm Watch Since 2005

• LISTEN & FOLLOW
• Apple Podcasts
• Google Podcasts
• Amazon Music
• Amazon Alexa

Your support helps make our show possible and unlocks access to our sponsor-free feed.

"Satellite operators are also busy monitoring spacecraft health due to the S1-S2 storm taking place along with the severe-extreme geomagnetic storm that continues even now," Dahl added, saying some GPS systems have struggled to lock locations and offered incorrect positions.

NOAA's GOES-16 satellite captured a flare erupting occurred around 2 p.m. EDT on May 9, 2024.

As NOAA had warned late Friday, the Earth has been experiencing a G5, or "Extreme," geomagnetic storm . It's the first G5 storm to hit the planet since 2003, when a similar event temporarily knocked out power in part of Sweden and damaged electrical transformers in South Africa.

The NOAA center predicted that this current storm could induce auroras visible as far south as Northern California and Alabama.

Extreme (G5) geomagnetic conditions have been observed! pic.twitter.com/qLsC8GbWus — NOAA Space Weather Prediction Center (@NWSSWPC) May 10, 2024

Around the world on social media, posters put up photos of bright auroras visible in Russia , Scandinavia , the United Kingdom and continental Europe . Some reported seeing the aurora as far south as Mallorca, Spain .

The source of the solar storm is a cluster of sunspots on the sun's surface that is 17 times the diameter of the Earth. The spots are filled with tangled magnetic fields that can act as slingshots, throwing huge quantities of charged particles towards our planet. These events, known as coronal mass ejections, become more common during the peak of the Sun's 11-year solar cycle.

A powerful solar storm is bringing northern lights to unusual places

Usually, they miss the Earth, but this time, NOAA says several have headed directly toward our planet, and the agency predicted that several waves of flares will continue to slam into the Earth over the next few days.

While the storm has proven to be large, predicting the effects from such incidents can be difficult, Dahl said.

Shocking problems

The most disruptive solar storm ever recorded came in 1859. Known as the "Carrington Event," it generated shimmering auroras that were visible as far south as Mexico and Hawaii. It also fried telegraph systems throughout Europe and North America.

Stronger activity on the sun could bring more displays of the northern lights in 2024

While this geomagnetic storm will not be as strong, the world has grown more reliant on electronics and electrical systems. Depending on the orientation of the storm's magnetic field, it could induce unexpected electrical currents in long-distance power lines — those currents could cause safety systems to flip, triggering temporary power outages in some areas.

my cat just experienced the aurora borealis, one of the world's most radiant natural phenomena... and she doesn't care pic.twitter.com/Ee74FpWHFm — PJ (@kickthepj) May 10, 2024

The storm is also likely to disrupt the ionosphere, a section of Earth's atmosphere filled with charged particles. Some long-distance radio transmissions use the ionosphere to "bounce" signals around the globe, and those signals will likely be disrupted. The particles may also refract and otherwise scramble signals from the global positioning system, according to Rob Steenburgh, a space scientist with NOAA. Those effects can linger for a few days after the storm.

Like Dahl, Steenburgh said it's unclear just how bad the disruptions will be. While we are more dependent than ever on GPS, there are also more satellites in orbit. Moreover, the anomalies from the storm are constantly shifting through the ionosphere like ripples in a pool. "Outages, with any luck, should not be prolonged," Steenburgh said.

What Causes The Northern Lights? Scientists Finally Know For Sure

The radiation from the storm could have other undesirable effects. At high altitudes, it could damage satellites, while at low altitudes, it's likely to increase atmospheric drag, causing some satellites to sink toward the Earth.

The changes to orbits wreak havoc, warns Tuija Pulkkinen, chair of the department of climate and space sciences at the University of Michigan. Since the last solar maximum, companies such as SpaceX have launched thousands of satellites into low Earth orbit. Those satellites will now see their orbits unexpectedly changed.

"There's a lot of companies that haven't seen these kind of space weather effects before," she says.

The International Space Station lies within Earth's magnetosphere, so its astronauts should be mostly protected, Steenburgh says.

In a statement, NASA said that astronauts would not take additional measures to protect themselves. "NASA completed a thorough analysis of recent space weather activity and determined it posed no risk to the crew aboard the International Space Station and no additional precautionary measures are needed," the agency said late Friday.

People visit St Mary's lighthouse in Whitley Bay to see the aurora borealis on Friday in Whitley Bay, England. Ian Forsyth/Getty Images hide caption

People visit St Mary's lighthouse in Whitley Bay to see the aurora borealis on Friday in Whitley Bay, England.

While this storm will undoubtedly keep satellite operators and utilities busy over the next few days, individuals don't really need to do much to get ready.

"As far as what the general public should be doing, hopefully they're not having to do anything," Dahl said. "Weather permitting, they may be visible again tonight." He advised that the largest problem could be a brief blackout, so keeping some flashlights and a radio handy might prove helpful.

I took these photos near Ranfurly in Central Otago, New Zealand. Anyone can use them please spread far and wide. :-) https://t.co/NUWpLiqY2S — Dr Andrew Dickson reform/ACC (@AndrewDickson13) May 10, 2024

And don't forget to go outside and look up, adds Steenburgh. This event's aurora is visible much further south than usual.

A faint aurora can be detected by a modern cell phone camera, he adds, so even if you can't see it with your eyes, try taking a photo of the sky.

The aurora "is really the gift from space weather," he says.

• space weather
• solar flares
• solar storm

Blog do Microsoft Power BI

Power bi december 2023 feature summary.

Welcome to the Power BI December 2023 update. We’ve got a lot of great features this month. Here are some key highlights:

• Learn how you can skill up and get ready for the upcoming Fabric Analytics Engineer certification with the Cloud Skills Challenge .
• Join us at the first annual Microsoft Fabric Community Conference  (Mar 26-28 2024)
• We’ve made lots of improvement for reporting , for example there are many more options for styling your column and bar charts.
• If you are a fan of our PowerPoint add-in , you’ll be happy to know we’ve made it easier to find and insert Power BI content into your PowerPoint presentations.
• Developers can now handle with git merge conflicts directly in the workspace.

Skill up on Fabric: Take the Microsoft Fabric Challenge

Join the thousands of professionals that have completed the Microsoft Fabric Challenge  as part of the Microsoft Ignite  Cloud Skills Challenge .  In less than 8 hours, you will learn how to connect, ingest, store, analyze, and report on data with Power BI and Microsoft Fabric. The Microsoft Fabric challenge prepares you for the Microsoft Certified: Fabric Analytics Engineer Associate  certification that is coming in the next months. The challenge is on until January 15, 2024.

The Microsoft Learn Cloud Skills Challenge  enables you to skill up for in-demand technologies like Power BI and Microsoft Fabric, track your progress in a leaderboard and get rewards for your work once you complete the challenge. As part of the Ignite edition, you have a chance to win a VIP pass to the next Microsoft Ignite .

The Microsoft Fabric Community Conference

Join us at the first annual Microsoft Fabric Community Conference and see firsthand how Microsoft Fabric and the rest of the data and AI products at Microsoft can help your organization prepare for the era of AI. You’ll hear from leading Microsoft and community experts from around the world and get hands on experiences with the latest features from Microsoft Fabric, Power BI, Databases, Azure AI, Microsoft Purview, and more. We have just release more sessions to the website today!

Register today  to immerse yourself in the future of data and AI and connect with thousands of data innovators like yourself eager to share their insights.

About our January 2024 Feature Summary blog

Due to the holidays, we will not publish the monthly feature summary blog in January. Instead, to begin the new year we will post a special blog looking back at 2023 and call out some key highlights!

Also, we will be making a very important and exciting announcement about certifications and learning for Microsoft Fabric! So, make sure you read the January blog.

• Version number: 2.124.1052.0
• Date published: 12/18/2023

More styling options for column and bar charts

Extended customization for data labels, azure maps clustering aggregation support for bubble layer, alerting on your power bi reports with data activator, onelake data hub in power bi desktop, power bi connector updates, storytelling in powerpoint – suggested content, ability to search and sort in paginated reports, power bi custom visuals authentication api.

• Dynamic Drill down API

Git integration conflict resolution

New visuals in appsource, activity gauge by powerviz, navigate financial risks and rewards with profitbase’s power bi visualization, intuitive multi-level donut charts for your reports, inforiver analytics+ 3.2, videoplayer visual, ridgeline plot by powerviz.

On-object Interaction updates 

New on-object default setup is here! 

Each month we’ve been working toward giving users more flexibility in how they prefer to work with the PBI editor. This month we’re introducing a new default setup that feels closer to the previous classic look. With this new default, we’ll help you preset the following options with just one click!

• Move the “build a visual” menu to the pane switcher by default
• Show both build and data panes expanded by default
• Format pane in the pane switcher by default
• “Always open in new pane” set to ON, thereby stacking panes by default
• Collapse panes to the pane switcher instead of close “X” by default

Upon updating to the new December build, with the new on-object preview switch ON, you’ll be greeted with a dialog to update to the new default setup. If you like your existing on-object setup and do not wish to have a more classic look, choose Keep setup and no changes will be made.

If you change your mind, you can always go back to the Options menu to customize the experience to your needs. Here’s a walkthrough of what each of these options do:

• Suggest a type by default – If you prefer option in the Build menu to be off by default, expanding all the field wells always, make sure this is not checked.
• In the Build a visual menu, always show all the visualization types – If you prefer to see all the visualization types shown by default in the Build menu, be sure to check this option.
• Always show pane switcher – When checked, this provides the right-hand pane switcher shown even when working with zero panes. Provides access to the “+” menu and setting gear always.
• Always show the Build a visual menu in the pane switcher – This moves the build menu from showing next to the visual, to the pane switcher on the right side instead. Check this option if you prefer to work with the Build menu as a pane.
• Always open a new pane – Instead of switching between panes, check this option if you prefer the stacking behavior as before. With this option on, opening a new pane will open side-by-side by default.

To summarize, here’s the state of these settings for the new default setup:

Multi-select in data flyout

To cut down on the extra clicks when first adding data using the new “add data” button, the data flyout now allows you to multi-select fields to add fields in bulk to your visual, just like the data pane! Simply check all the fields you’d like to add to your visual in one go.

This works best when “ suggest a type ” is ON so you can add as many fields as you like and PBI will place the fields in the appropriate field wells for you.

In-product user education

With the many changes the on-object interaction introduced, it can hard to know where certain features may have moved. This month we’ve added four teaching bubbles to help users along the way.

• Where’s drillthrough and tooltip page set up?
• A teaching bubble will now point to the new location within Format > Page information.
• Where did the analytics pane go?
• Analytics options like error bars, max, min or percentile lines are now consolidated in the Format pane at the bottom. You can set a max, min or other reference line using the new “ Reference line ” card in the format pane.
• What happened to the right click options for a field like rename or ‘show value as’?
• They are still available at the right click! Simply right click on the field name to see the same options as before.
• How do I bring back my data pane if the pane switcher is gone?
• You shouldn’t run into this as frequently now that we’ve updated the behavior to collapse panes by default instead of closing. But in case you do, you can always re-open a pane from the View tab in the ribbon.

We’re thrilled to announce that this month brings many new formatting enhancements for col u m n a n d bar charts in Power BI. These additions are designed to i mprove your data visualization, enabling more impactful analysis and storytelling capabilities . Here’s a quick look at the new features available now!  

Key Enhancements:  

• Apply Settings to All or Series: Enjoy the  versatility  of applying formatting options globally across all categories or tailor them for each unique individual series , effortlessly and efficiently!  
• Transparency Control: You can now adjust the fill color transparency to achieve the perfect balance of visibility and design.  
• Border Customization: Gaining superior control, you can now introduce borders with unmatched precision, choosing a distinct color, or match it to the column’s fill, and define both the border’s width and transparency for a polished look.  
• Layout: We’ve renamed the Spacing card to be the new Layout card, relocated the familiar Reverse Order toggle that allows you to invert series, and introduced Sort by Value , Space between categories , and Space between series . And, with clustered columns and bar charts, you now have the option to Erode or Explode the stacked series.  
• Advanced ribbon settings: Highlight a series or create visual continuity with an array of options including matching series color or choosing a color selection, transparency, border color matching or color selection, border width, and border spacing.  

These features aim to provide you with greater flexibility and creative freedom in presenting your data, ensuring that your insights stand out with clarity and style. Enjoy exploring these new capabilities and crafting compelling narratives with your data in Power BI.  

If you’re looking to learn more comprehensive information about these new features we’ve rolled out for column and bar charts, look for our dedicated blog post .  

Data labels are also getting more options this month !  With this month’s update, you’ll d iscover some new   enhanced capabilities   for Data l abels , giving you extended customization choices  to seamlessly match your reporting needs , and it brings the  simple integration  of additional metrics , dramatically improving your  data analysis experience. Here are this month’s highlights !  

• Title: The new Title card feature enables the display of legend fields on your data labels, offering the option to  omit the legend  for a cleaner look. It also allows  customized data label titles  using different data fields, adjustable font style, color, and transparency.  
• Value: Easily spot the  active field  for your data label in the field well. Modifying it to another field is  quick and easy , with customization options like font, color, transparency, and more, plus a new feature for  blank value display .  
• Detail: Our new Detail card feature  unlocks new potential  by allowing the inclusion of a  secondary metric  to your data labels. Choose any field to add an extra value, with the  full range of formatting options at your disposal.  
• Visual label layout: A new feature that lets you choose between a  sleek single-line  data label or a  multi-line  data label, where desired.  

We invite you to explore these remarkable new features of Data labels to significantly enhance the data density in your charts. Available for Columns, Bars, Lines, and Ribbon charts, these advancements are ready to transform your reporting. We’re excited to hear your thoughts on these innovations and value your input on future Data Label enhancements!   

For more detailed information about these new Data label features, look for our dedicated blog post .  

We are thrilled to introduce a powerful enhancement to the Power BI Azure Maps visual – the clustering aggregation feature for the bubble layer with customizable styling options. This innovative capability not only enables users to dynamically aggregate data within bubble layers based on distinct zoom levels but also empowers you to tailor the visual representation of clustered data.

Users can now effortlessly style their cluster bubbles, choosing from a range of options including bubble colors, font size and more. This level of customization enhances the user experience by allowing them to visually highlight and emphasize specific aspects of the data, creating more impactful and informative geospatial visualizations. With this added flexibility, the Power BI Azure Maps visual is poised to become an even more powerful tool for users seeking dynamic and engaging geospatial analyses.

In October we announced the public preview of Data Activator. Many Power BI users have been asking for alerting capabilities within reports, and Data Activator is here to help! From the visual context menu or report toolbar you can choose ‘Set alert’. This opens a pane where you can set the measure you want to monitor and the conditions you want to detect:

When you select Continue, it will create a Data Activator reflex and connect it to the data in your Power BI dataset. Data Activator will automatically start monitoring your data and notify you when the condition is met!

If you want to further customize the trigger to watch for more complex conditions, notify different users, or even launch a Power Automate workflow, or for more information on Data Activator, you can read our documentation at https://aka.ms/dataActivatorDocs , or watch our intro video:

Data Connectivity

Connectivity to Fabric items (Datamarts, Lakehouses, Warehouses, KQL Databases) via the OneLake data hub is now generally available, following the earlier announcement of Fabric’s general availability.

Amazon Athena (Connector Update)

The Amazon Athena connector has been updated. Please find below update release notes from the Amazon team.

In this Power BI connector release, we eliminate an issue that prevents users from connecting to Athena using AAD authentication without a role parameter.

BQE Core (Connector Update)

The BQE Core connector has been updated. Please find below update release notes from the BQE Core team.

Added Target Utilization and Birth Date properties to Employee table.

Databricks (Connector Update)

The Databricks connector has been updated. Please find below update release notes from the Databricks team.

In this release we add AAD auth support for Databricks AWS workspace

Inwink (New Connector)

We are excited to announce the release of the inwink connector. Please find below release notes from the inwink team.

Visualize your inwink data and create dashboards using the inwink connector for Power BI. Combine data in inwink with data from other business apps (like Salesforce, SAP, etc) to drive better decision making and analyze the performance of your events and communities.

Starburst Enterprise (Connector Update)

The Starburst Enterprise connector has been updated. Please find below update release notes from the Starburst team.

All changes are backwards compatible:

Added support for canceling queries using “CancelQueryExplicity”.

Added “Use default proxy” checkbox.

Added support for Starburst Galaxy OAuth authentication.

Removed “Safe metadata read (optional)” from connector dialog, it’s now enabled by default for all queries.

Public change log:  https://docs.starburst.io/clients/powerbi.html#version-53-public-preview-under-microsoft-certification

Snowflake (Connector Update)

The Snowflake connector has been updated to enable cancellation of a Snowflake query when the operation is cancelled in the Power BI user interface.

Eduframe Reporting (Connector Update)

The Eduframe Reporting connector has been updated. Please find below update release notes from the Eduframe team.

Added teacher enrollments.

Added teacher roles.

Added catalog variants.

Added planning event materials.

Added meeting materials.

Fixed the loading of teachers.

This month we’re introducing a new feature for the Power BI add-in for PowerPoint that makes it easier to find and insert the Power BI reports you need for your presentation.

When you add the Power BI add-in to your slide, the add-in automatically scans the title of the slide and suggests Power BI content that might be relevant. For example, if the title of your slide is “Holiday campaign status”, the add-in will show you a list of Power BI reports that contain data about campaigns.

The add-in also shows you reports you’ve recently visited in Power BI, so you can easily access reports you’re working on or frequently use.

Note : If the report you wanted to add doesn’t appear in the list of suggestions, you can just copy the report’s URL and paste it into the input box, as you’ve always done.

Once you find the report you want to insert, you can choose to insert a complete page or a specific visual from the report. You can also update filters or slicers before you insert your selection. Filter and slicer values are saved together with the report or visual you picked.

And, if you have permission to grant others access to this report, you can also select the “Give people automatic access to this data” checkbox, so that when others in your org view this presentation, they’ll be able to see the data you’ve just added to the slide.

See the Storytelling in Power BI documentation here .

This month, we introduced the ability to search for content across all pages of a paginated report on the PBI service. The paginated report can either be published to the service or can be authored on the PBI service. Specify any required parameters to view the report before searching. The search works across all pages of the report.

You can also sort on a column by simply clicking on the sort icon when the report is rendered on the PBI service.

Note: Both sort and search are available only in the Web layout. Read more about viewing a paginated report .

This API allows Custom Visuals to obtain Azure Active Directory (AAD) access tokens through single sign-on (SSO), facilitating secure and efficient user-contextual operations. The API will be controlled by a global admin setting. Learn more about this API

Dynamic drill control

This feature allows the visual to enable or disable the drill feature dynamically using an API call.

• When the drill feature is enabled, all the functionalities of drilldown and expand/collapse features are available. These functionalities include API calls, context menu commands, header drill buttons, and support for hierarchy data.
• When the drill feature is disabled, these functionalities aren’t available.

Find more information here

Check out the coming soon APIs

When working with Git integration in Fabric, conflicts can occur if the same items are edited in both the Fabric workspace and in the connected Git repository. To avoid any mistakes, items in conflict are marked as such, and the conflicts must be resolved before any further changes can be made. In these cases, it is up to you to decide which changes to keep and which to discard.

To make things easier, we’ve added the option to resolve conflicts and select which content to keep directly within the Fabric workspace, so that you don’t have to navigate elsewhere or revert to previous versions.

Accessed by updating items from the source control pane, resolving conflicts is as simple as selecting whether to accept incoming changes or keep the current content for each item in conflict:

Once the selections are made, all items can be merged and updated, and any further changes can be made in the workspace.

Resolving conflicts can also be done by reverting either the workspace or the Git branch to a previous state, or directly in Git if you need to further inspect what changes were made and which version to choose. Read more on how to Resolve conflicts with Git integration – Microsoft Fabric | Microsoft Learn .

Visualizations

Risk Matrix by Profitbase

PowerBI User Activity Tracker

ilionx ZorgControl KPI Gauge Tabulator for PowerBI Funnel Charts

The Activity Gauge by Powerviz is an advanced visual used to measure the progress against a set target or goal for multiple categories. It is typically presented in the form of a radial bar chart/gauge, displaying a range of values or percentages. This visual is commonly used for project management, performance tracking, and monitoring Key Performance Indicators (KPIs).

Key Features:

• Gauge Customization : Shape, style, and add icons for a unique design.
• Targets: Choose from options or use a custom field to set a target.
• Data Colors : Offers 7 schemes and 30+ color palettes.
• Center Circle: Customize center circle with text, icons, measures, and images.
• Interactive Mouseover: Hover for Interactive Info Display.
• Conditional Formatting – Create rules based on measure or category rules.

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

Business Use Cases:

• Project Management : Track task progress for efficient management.
• Financial Dashboard: Gain insights into key financial metrics.
• Employee Performance : Evaluate contributions and identify areas for improvement.

Try Activity Gauge for FREE from AppSource

Check out all features of the visual: Demo file

Step-by-step documentation and Feature Video

Follow Powerviz for more updates. Learn more about visuals .

Risk is an inherent part of doing business. That doesn’t mean you have to settle for total unpredictability. Profitbase’s new Risk Matrix visualization for Power BI provides businesses with a better way to visualize and assess potential risks. This helps them handle and minimize potential damage, in addition to discovering opportunities that the business can benefit from.

Advantages of the Risk Matrix by Profitbase :

• Efficient Risk Assessment : Quickly evaluate risks by impact and likelihood.
• Focused Prioritization : Spotlight and tackle high-priority risks, focusing your resources effectively.
• Strategic Allocation : Employ our tool to guide wise resource distribution for better efficiency.
• Harmonized Communication : Establish a common understanding among teams and stakeholders with a well-recognized method.
• Flexible Customization : Personalize the matrix size, from 5×5 to 3×3 or 3×5, and colors to align with your company’s branding.
• Dynamic Visualization : Adjustable bubble sizes animate your data, offering a clear financial perspective.

View an introduction video of the visual here .

Drill Down Donut PRO for Power BI guarantees the best user experience when it comes to multi-level donut charts. All interactions take place as on-chart interactions, ensuring a quick and easy data exploration experience. Control every aspect of the chart through extensive customization, and even select from multiple chart types (donut, pie, gauge). Get Drill Down Donut PRO now from AppSource .

Main features:

• Adjustable “Others” slice – set the number of visible slices and group the rest.
• On-chart interactions – no need to learn hidden controls.
• Custom tooltips – select ZoomCharts custom tooltip or Power BI built-in tooltip.
• Full customization – customize every slice, label, and legend.
• Desktop and mobile device navigation – explore charts the same way on any device.

Popular use cases:

• Sales and marketing – measuring campaign performance and research results.
• Human resources – staff composition, salary distribution, performance data.
• Accounting and finance – income and expense analysis, billings, creditors, and debtors.
• Project management – risk distribution, resource allocation.

For the full list of features, see ZoomCharts’s official product page. 

ZoomCharts Drill Down Visuals are known for interactive drilldowns, cross-filtering, and rich customization options. They support interactions, selections, custom and native tooltips, filtering, bookmarks, and context menu.

Inforiver Analytics+ (50+ Charts + Cards + Tables) by Lumel is now a complete No-Code storytelling visualization platform that is designed to help customers migrate legacy dashboards from Tableau, Spotfire, Qlik, Cognos, SAP Lumira, or their static PowerPoint dashboards from Think-cell or Mekko Graphics and consolidate them with Microsoft Power BI.

Why choose Inforiver Analytics+ as your migration companion to Power BI:

• Small Multiple & Trellis everything like Tableau and Spotfire
• “Visual PivotTable” for your Hierarchical data on all three axes (x,y,z) like Spotfire.
• Split and Group Measures into Trellis panels like Tableau
• Storytelling features like Think-cell and Mekko Graphics
• Dynamic Deviations (CAGR),
• Annotations,
• Series connector lines,
• Automatic series and categorical sorting.
• Trellis Tables with Excel-like formatting
• Advanced visualizations:
• Box and Whisker Plot – dynamic and pre-calculated quartiles
• Marimekko Chart (Variable Width column or Cascade chart) – stacking and 100% scales
• Advanced Waterfall- Measure-based Interim, Stacked & Dual Breakdown, Variance, and Combination
• Special Charts for Story Telling:
• Slope graph,
• Lollipop and dumbbell,
• Arrow & range Plots

Multivariate visualizations (Bubble/Scatter and Radar/Polar) and pie/donut types will be added to this visual soon with our vision and roadmap here.

Try Inforiver Analytics+ today after watching the 2-minute video highlights .

The Microsoft Purview hub in Fabricfor creators

The Microsoft Purview hub is a centralized page in Fabric that helps Fabric administrators and users gain insights about their Fabric data estate. It contains reports that provide insights into sensitive data and item endorsement and serves as a gateway to more advanced capabilities in Microsoft Purview. Following the public preview release of the Microsoft Purview hub for Fabric tenant admins in May, the hub is now available in public preview for all Fabric users.

See Microsoft Purview hub documentation here .

We are excited to introduce the VideoPlayer visual for Power BI Desktop! This new custom visual allows you to seamlessly integrate videos into your Power BI reports, enhancing your data storytelling capabilities. With VideoPlayer, you can enrich your reports with dynamic multimedia content to engage your audience effectively.

Key Features

• Video Integration : Easily embed videos from various sources, such as YouTube, Vimeo (including password protected videos), and many others, directly into your Power BI reports.
• Interactive Playback : Control video playback using intuitive play, pause, and seeking functionality, ensuring your audience can interact with the content as needed.
• Customization : Customize the appearance of the VideoPlayer to match your report’s style and design, including changing the video player’s dimensions and controls.
• Data-Driven Video Selection : Utilize data-driven techniques to determine which video to play based on your dataset, making your reports more insightful.

Link: https://appsource.microsoft.com/en-us/product/power-bi-visuals/pbicraft1694192953706.videoplayer

A Ridgeline Plot or Joy plot is an advanced Power BI visual, that visually represents numeric variable distributions across multiple categories on a continuous axis. The overlapping mountain ranges allow easy comparison. Ridgeline Plot effectively highlights patterns of distribution change across different categories, providing insights into the variability and trends within the data.

• Multiple Distribution: Ability to plot more than one value in Measures.
• Ridge Style: Different lines, and marker styles available.
• Scaling : Control Y-axis scaling and overlaps.
• Colors: Apply color schemes across X-axis, Y-axis and based on FX rules.
• Ranking: Filter Top/Bottom N values, with “Others”.
• Reference Line: Highlight ranges or important data points on X and Y axis.
• Mode Line: Emphasize peak points and display labels.
• Custom Tooltip: Add highest, lowest, mean, and median points without any DAX.
• Themes: Save designs and share seamlessly with JSON files.

Business Use Cases: 

Time Series Data, Statistical Analysis, Distribution Data

🔗 Try Ridgeline Plot for FREE from AppSource

📊 Download: Demo file

📃 Step-by-step instructions: Documentation

💡 Feature video: Video Link

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

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

• Microsoft Fabric