Categories: World News

Microsoft brings support for Power BI connected PivotTables to Excel on the web


Continuing its efforts to improve the reach of Excel on the web for power users, Microsoft today announced a new feature for the spreadsheet tool on the web that brings support for Power BI connected PivotTables. The capability greatly enhances Excel’s capabilities on the web, allowing for analyzing data pulled from huge data sets.

The Redmond firm has for long enabled pulling data from multiple sources in Excel on the desktop, letting users connect their spreadsheets to data sets larger than what Excel can accommodate. That capability now comes to the web app, letting users create PivotTables to filter through, analyze, and derive insights from updated tables in Power BI. This is especially useful for analytics use cases where backend data constantly changes and/or increases.

The feature also respects existing Microsoft Information Protection labels set in Power BI to avoid unauthorized users from accessing sensitive information. This applies to data in SharePoint, OneDrive, and Teams. Users will need access to the “underlying datasets” in Power BI for them to be able to access PivotTables connected to that source. The company does note that users will be unable to refresh and interact with Power BI datasets when Excel on the web is connected to live Analysis Services.

The firm has also detailed a few improvements coming to Power BI connected PivotTables on the desktop. These include support for drag and drop on aggregation fields such as sum, average, count, and others. This negates the need for users to create measures for these aggregate functions in Power BI datasets. Additionally, these PivotTables will also support date fields, enabling date sorting and filtering.

Lastly, PivotTable field lists are getting a few improvements. These include new icons and a change that now places pre-defined measures in tables that they are present in on Power BI. There are also performance improvements to Power BI connected PivotTables, thanks to recent updates to the Analysis Service engine in Power BI.

Support for Power BI connected PivotTables on the web is beginning to roll out to Microsoft 365 tenants now. However, the release will be a staggered one, and it will take a few months before being made completely available. As for the improvements for the desktop, those will first make it to Office Insiders before being shipped to all users.


Source link
Leave a Comment
Published by

Recent Posts

Gigabyte’s Liquid-Cooled AMD Radeon RX 6900 XTX Could Soon Be With Us

According to reports from VideoCardz, Gigabyte is readying an Aorus-branded AMD Radeon RX 6900 XT…

6 mins ago

TSMC Pressured by U.S. Government for More Chips to Automakers

The United States Department of Commerce is reportedly pressing TSMC to meet chip orders by…

16 mins ago

How to Remove Empty Lines from a Word Document

Manually removing extra blank lines from a Microsoft Word document is tedious. Luckily, a feature…

18 mins ago

There’s a single Dogecoin holder with 28% of supply worth $23 billion

The internet is waiting for Elon Musk to mention or discuss Dogecoin on Saturday Night…

21 mins ago

WhatsApp Drops Its May 15 Deadline for Accepting New Privacy Policy

WhatsApp will still limit the functionality of your account if you don't accept its new…

22 mins ago

Here’s how you can stop websites from sending annoying notification prompts in Google Chrome

Browsers allow websites to send push notifications to users about new updates and articles published.…

27 mins ago