Power BI connected PivotTables in Excel for the web

Published May 04 2021 10:00 AM 28.7K Views
Microsoft

Today we are excited to announce the initial availability of Power BI connected PivotTables in Excel for the web.  As part of our journey to simplify enterprise data discovery and analysis in Excelthis new capability unlocks more ways to consume such analysis from Excel for the web, empowering more users to make critical decisions with the benefits of Excel and Power BI. For example, you can get up-to-date insights by refreshing the PivotTable, or conduct explorations by manipulating the PivotTable fields all in a browser. You can also include live Excel PivotTables connected to Power BI data directly within your Power BI solutions and apps.

 

 

Furthermore, a layer of data protection is added by respecting any existing Microsoft Information Protection labels applied to the Power BI datasets as you connect to it with PivotTables in Excel for the web.

 

This will work on any workbooks in OneDrive for Business, SharePoint, and Teams, as well as those uploaded to the Power BI service. Users will need access to the underlying dataset to interact with PivotTables connected to Power BI datasets (see how to share Power BI datasets).  *Note: refresh and interactivity of Power BI datasets with a live connection to Analysis Services in Excel for the web is not supported.

 

This new feature has started rolling out across Microsoft 365 tenants, and we expect full roll out over the next few months.

 

Other Improvements

We are making a few other improvements to help you to be more productive with Power BI connected PivotTables.

 

Drag-and-Drop Aggregations

PivotTables connected to Power BI datasets will now support drag-and-drop aggregation of fields (e.g. sum, average, distinct count, etc.). This helps you to quickly get answers within Excel without needing pre-defined measures in the underlying Power BI datasets.

 

 

Date Fields

PivotTables connected to Power BI datasets will now support date fields, which means that date filters timelines, and date sorting will now be available.

 

cuong_2-1620075832859.png

 

Field list updates

In addition, we are making some small modifications to the field list, namely pre-defined measures will now be shown within the table they are stored in.  We are also updating some of the icons.

 

cuong_3-1620075832871.png

 

We Made it Faster Too

You may have noticed that PivotTables connected to Power BI also got faster. This is due to the recent updates to the Analysis Service engine in Power BI. Learn more details here: Analysis Services Tabular improves MDX query performance in the cloud.

 

Support for drag-and-drop aggregations, date fields, and the field list improvements will start rolling out in Excel Windows to Office Insiders soon and will be brought to Excel for web at a later stage.

 

Getting Started Now

We invite you to try out these new capabilities for yourself as they become available to you in the upcoming weeks. Send us your feedback via Help > Feedback in the app.

 

To learn more:

 

Subscribe to our Excel Blog and join our Excel Community to stay connected with us and other Excel fans around the world.

 

14 Comments

That's great, it will be interesting to try and compare with desktop version. So far not available.

Occasional Visitor

Will there be support for Analysis Services datasets as well?

Occasional Visitor

Support for Azure Analysis Services would be huge. Any timeline for this?

Regular Visitor

Date fields in connected pivot tables will now work just like, um, date fields?  Thank you!

Regular Visitor

I have tried connecting a O365 PT to a Power BI Premium Per User model with imported data and still get the "old message" of not supported :

ptmartin_0-1621062969473.png

Would appreciate any advice ?


STILL DOES NOT CONNECT 8TH JUNE ?

Does the online connection work with Pro licenses of Power BI or only Power BI Premium / Premium Per User ?

Visitor

This is a welcomed capability for my company.  Our self-serve users, especially those in accounting, will love this.

New Contributor

@yunling With regards to loading a Power BI Dataset into Excel via Get Data, if a table is later renamed, a refresh can happen (albeit with a warning dialog) but the whole existing PivotTable is cleared. Is it not possible for it to know that this is the same table - just renamed - and to keep everything in place?

Similarly for renaming an existing column or measure, it removes the renamed column/measure from PivotTable if it was already dragged in rather than just keep it there. Can it not just be kept in-place?

Occasional Visitor

@yunling Great - long awaited - feature.

 

You say "This new feature has started rolling out across Microsoft 365 tenants, and we expect full roll out over the next few months". Is there any more detail on that? Will there be a further update on this blog? Would be very useful to know

 

Thanks

Microsoft

Quick Update: Please note that the Excel for the web feature announced in this post (i.e. Power BI PivotTable refresh and interaction) is now fully rolled out.  In addition, the Windows capabilities mentioned (i.e. drag and drop aggregations, date support, and visual polish) are being rolled out to the Insiders Slow audience. 

Just in case

Insiders Slow == Current (Preview)

Microsoft

Thanks @Sergei Baklan!  I still have the bad habit of using the old terms. 

Is there any plan to remove the above note: "refresh and interactivity of Power BI datasets with a live connection to Azure Analysis Services in Excel for the web is not supported." once the feature landed in Excel Online? Or will this capability not been addressed any time soon? 

Frequent Visitor

Hello

Any ETA for the rolling out of the Windows capabilities mentioned (i.e. drag and drop aggregations, date support, and visual polish) to the general audience?

Occasional Contributor

Once you have data connected to your source with Power BI in Desktop Excel, then, you can use one of my analytics templates to detect, visualize and explore unusual data points in a dataset: Cool Number Crunching Templates (sellfy.store)

%3CLINGO-SUB%20id%3D%22lingo-sub-2322798%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2322798%22%20slang%3D%22en-US%22%3E%3CP%3EThat's%20great%2C%20it%20will%20be%20interesting%20to%20try%20and%20compare%20with%20desktop%20version.%20So%20far%20not%20available.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2175918%22%20slang%3D%22en-US%22%3EPower%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2175918%22%20slang%3D%22en-US%22%3E%3CP%3EToday%20we%20are%20excited%20to%20announce%20the%20initial%20availability%20of%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web.%20%26nbsp%3B%3CSPAN%3EAs%20part%20of%20our%20journey%26nbsp%3Bto%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fsimplifying-enterprise-data-discovery-and-analysis-in-microsoft%2Fba-p%2F1354160%22%20target%3D%22_blank%22%3E%3CSPAN%3Esimplify%20enterprise%20data%20discovery%20and%20analysis%20in%20Excel%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%3E%2C%26nbsp%3B%3C%2FSPAN%3Ethis%20new%20capability%20unlocks%20more%20ways%20to%20consume%20such%20analysis%20from%20Excel%20for%20the%20web%2C%20empowering%20more%20users%20to%20make%20critical%20decisions%20with%20the%20benefits%20of%20Excel%20and%20Power%20BI.%20For%20example%2C%20you%20can%20get%20up-to-date%20insights%20by%20refreshing%20the%20PivotTable%2C%20or%20conduct%20explorations%20by%20manipulating%20the%20PivotTable%20fields%20all%20in%20a%20browser.%20You%20can%20also%20include%20live%20Excel%20PivotTables%20connected%20to%20Power%20BI%20data%20directly%20within%20your%20Power%20BI%20solutions%20and%20apps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20style%3D%22position%3A%20relative%3B%20padding-bottom%3A%2056.25%25%3B%20padding-top%3A%2030px%3B%20height%3A%200%3B%20overflow%3A%20hidden%3B%20min-width%3A%20320px%3B%22%3E%3CIFRAME%20src%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fvideoplayer%2Fembed%2FRWD4Bd%3Fautoplay%3Dfalse%22%20frameborder%3D%220%22%20allowfullscreen%3D%22allowfullscreen%22%20style%3D%22position%3A%20absolute%3B%20top%3A%200%3B%20left%3A%200%3B%20width%3A%20100%25%3B%20height%3A%20100%25%3B%22%20class%3D%22video-iframe%22%20your%3D%22%22%20video%3D%22%22%20title%3D%22%E2%80%9Dput%22%20here%3D%22%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EFurthermore%2C%20a%20layer%20of%20data%20protection%20is%20added%20by%20respecting%20any%20existing%20Microsoft%20Information%20Protection%20labels%20applied%20to%20the%20Power%20BI%20datasets%20as%20you%20connect%20to%20it%20with%20PivotTables%20in%20Excel%20for%20the%20web.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThis%20will%20work%20on%20any%20workbooks%20%3C%2FSPAN%3Ein%20OneDrive%20for%20Business%2C%20SharePoint%2C%20and%20Teams%2C%20as%20well%20as%20those%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2Fconnect-data%2Fservice-publish-from-excel%23%3A~%3Atext%3DPublish%2520to%2520Power%2520BI%2520from%2520Microsoft%2520Excel%25201%2CPower%2520BI%2520workspace.%25203%2520Next%2520steps.%2520More%2520questions%253F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Euploaded%20to%20the%20Power%20BI%20service%3C%2FA%3E.%20%3CSPAN%3EUsers%20will%20need%20access%20to%20the%20underlying%20dataset%20to%20interact%20with%20PivotTables%20connected%20to%20Power%20BI%20datasets%20(see%20how%20to%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2Fconnect-data%2Fservice-datasets-share%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Eshare%20Power%20BI%20datasets%3C%2FA%3E%3CSPAN%3E).%20%26nbsp%3B*Note%3A%3C%2FSPAN%3E%3CSPAN%3E%20refresh%20and%20interactivity%20of%20Power%20BI%20datasets%20with%20a%20live%20connection%20to%20Analysis%20Services%20in%20Excel%20for%20the%20web%20is%20not%20supported.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20new%20feature%20has%20started%20rolling%20out%20across%20Microsoft%20365%20tenants%2C%20and%20we%20expect%20full%20roll%20out%20over%20the%20next%20few%20months.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--522340390%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%20id%3D%22toc-hId--522340387%22%3E%3CSPAN%3EOther%20Improvements%3C%2FSPAN%3E%3C%2FH2%3E%0A%3CP%3E%3CSPAN%3EWe%20are%20making%20a%20few%20other%20improvements%20to%20help%20you%20to%20be%20more%20productive%20with%20Power%20BI%20connected%20PivotTables.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-168221084%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%20id%3D%22toc-hId-168221087%22%3EDrag-and-Drop%20Aggregations%3C%2FH3%3E%0A%3CP%3E%3CSPAN%3EPivotTables%20connected%20to%20Power%20BI%20datasets%20will%20now%20support%20drag-and-drop%20aggregation%20of%20fields%20(e.g.%20sum%2C%20average%2C%20distinct%20count%2C%20etc.).%20This%20helps%20you%20to%20%3C%2FSPAN%3Equickly%20get%20answers%20within%20Excel%20without%20needing%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2Ftransform-model%2Fdesktop-measures%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Epre-defined%20measures%3C%2FA%3E%20in%20the%20underlying%20Power%20BI%20datasets.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CDIV%20style%3D%22position%3A%20relative%3B%20padding-bottom%3A%2056.25%25%3B%20padding-top%3A%2030px%3B%20height%3A%200%3B%20overflow%3A%20hidden%3B%20min-width%3A%20320px%3B%22%3E%3CIFRAME%20src%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fvideoplayer%2Fembed%2FRWD7vd%3Fautoplay%3Dfalse%22%20frameborder%3D%220%22%20allowfullscreen%3D%22allowfullscreen%22%20style%3D%22position%3A%20absolute%3B%20top%3A%200%3B%20left%3A%200%3B%20width%3A%20100%25%3B%20height%3A%20100%25%3B%22%20class%3D%22video-iframe%22%20your%3D%22%22%20video%3D%22%22%20title%3D%22%E2%80%9Dput%22%20here%3D%22%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--1639233379%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%20id%3D%22toc-hId--1639233376%22%3E%3CSPAN%3EDate%20Fields%3C%2FSPAN%3E%3C%2FH3%3E%0A%3CP%3E%3CSPAN%3EPivotTables%20connected%20to%20Power%20BI%20datasets%20will%20now%20support%20date%20fields%2C%20which%20means%20that%20date%20filters%20timelines%2C%20and%20date%20sorting%20will%20now%20be%20available.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22cuong_2-1620075832859.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277588i203C41CE9BD1030C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22cuong_2-1620075832859.png%22%20alt%3D%22cuong_2-1620075832859.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-848279454%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%20id%3D%22toc-hId-848279457%22%3EField%20list%20updates%3C%2FH3%3E%0A%3CP%3EIn%20addition%2C%20we%20are%20making%20some%20small%20modifications%20to%20the%20field%20list%2C%20namely%20pre-defined%20measures%20will%20now%20be%20shown%20within%20the%20table%20they%20are%20stored%20in.%26nbsp%3B%20We%20are%20also%20updating%20some%20of%20the%20icons.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22cuong_3-1620075832871.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277587iA7956CAD5DEA069F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22cuong_3-1620075832871.png%22%20alt%3D%22cuong_3-1620075832871.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId--959175009%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%20id%3D%22toc-hId--959175006%22%3EWe%20Made%20it%20Faster%20Too%3C%2FH3%3E%0A%3CP%3EYou%20may%20have%20noticed%20that%20PivotTables%20connected%20to%20Power%20BI%20also%20got%20faster.%20This%20is%20due%20to%20the%20recent%20updates%20to%20the%20Analysis%20Service%20engine%20in%20Power%20BI.%20Learn%20more%20details%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fupdates%2Fanalysis-services-tabular-improves-mdx-query-performance-in-the-cloud%2Fpreview%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAnalysis%20Services%20Tabular%20improves%20MDX%20query%20performance%20in%20the%20cloud%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESupport%20for%20drag-and-drop%20aggregations%2C%20date%20fields%2C%20and%20the%20field%20list%20improvements%20will%20start%20rolling%20out%20in%20Excel%20Windows%20to%20Office%20Insiders%20soon%20and%20will%20be%20brought%20to%20Excel%20for%20web%20at%20a%20later%20stage.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH3%20id%3D%22toc-hId-1528337824%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%20id%3D%22toc-hId-1528337827%22%3EGetting%20Started%20Now%3C%2FH3%3E%0A%3CP%3E%3CSPAN%3EWe%20invite%20you%20to%20try%20out%20these%20new%20capabilities%20for%20yourself%20as%20they%20become%20available%20to%20you%20in%20the%20upcoming%20weeks.%20Send%20us%20your%20feedback%20via%20Help%20%26gt%3B%20Feedback%20in%20the%20app.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ETo%20learn%20more%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-pivottable-from-power-bi-datasets-31444a04-9c38-4dd7-9a45-22848c666884%23%3A~%3Atext%3D%2520How%2520to%2520create%2520PivotTables%2520from%2520a%2520Power%2CThis%2520will%2520create%2520a%2520PivotTable%2520for...%2520More%2520%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ECreate%20a%20PivotTable%20from%20Power%20BI%20datasets%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2Fcollaborate-share%2Fservice-analyze-in-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAnalyze%20in%20Excel%20for%20Power%20BI%3C%2FA%3E%20%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Foffice%2Fconvert-text-to-an-organization-data-type-cd8938ce-f963-444d-b82a-7140848241e9%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EConvert%20text%20to%20an%20Organization%20data%20type%3C%2FA%3E%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3EFollow%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Ethe%20%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EPower%20BI%20Blog%3C%2FA%3E%20to%20get%20the%20latest%20Power%20BI%20updates%20and%20announcements%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Efrom%20the%20%3CA%20href%3D%22https%3A%2F%2Fmymbas.microsoft.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMicrosoft%20Business%20Applications%20Summit%3C%2FA%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ESubscribe%20to%20our%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fxlblog%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EExcel%20Blog%3C%2FA%3E%3CSPAN%3E%26nbsp%3Band%20join%20our%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FExcelCommunity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EExcel%20Community%3C%2FA%3E%3CSPAN%3E%26nbsp%3Bto%20stay%20connected%20with%20us%20and%20other%20Excel%20fans%20around%20the%20world%3C%2FSPAN%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2175918%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22gif1.gif%22%20style%3D%22width%3A%20447px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277738i2DEB8980F9A47DE4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22gif1.gif%22%20alt%3D%22gif1.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPower%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%20now%20available%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2175918%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EData%20Insights%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2330081%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2330081%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWill%20there%20be%20support%20for%20Analysis%20Services%20datasets%20as%20well%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2345623%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2345623%22%20slang%3D%22en-US%22%3E%3CP%3ESupport%20for%20Azure%20Analysis%20Services%20would%20be%20huge.%20Any%20timeline%20for%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2348482%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348482%22%20slang%3D%22en-US%22%3E%3CP%3EDate%20fields%20in%20connected%20pivot%20tables%20will%20now%20work%20just%20like%2C%20um%2C%20date%20fields%3F%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2380835%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2380835%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20a%20welcomed%20capability%20for%20my%20company.%26nbsp%3B%20Our%20self-serve%20users%2C%20especially%20those%20in%20accounting%2C%20will%20love%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2426137%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2426137%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F297306%22%20target%3D%22_blank%22%3E%40yunling%3C%2FA%3E%26nbsp%3BWith%20regards%20to%20loading%20a%20Power%20BI%20Dataset%20into%20Excel%20via%20Get%20Data%2C%20if%20a%20table%20is%20later%20renamed%2C%20a%20refresh%20can%20happen%20(albeit%20with%20a%20warning%20dialog)%20but%20the%20whole%20existing%20PivotTable%20is%20cleared.%20Is%20it%20not%20possible%20for%20it%20to%20know%20that%20this%20is%20the%20same%20table%20-%20just%20renamed%20-%20and%20to%20keep%20everything%20in%20place%3F%3C%2FP%3E%3CP%3ESimilarly%20for%20renaming%20an%20existing%20column%20or%20measure%2C%20it%20removes%20the%20renamed%20column%2Fmeasure%20from%20PivotTable%20if%20it%20was%20already%20dragged%20in%20rather%20than%20just%20keep%20it%20there.%20Can%20it%20not%20just%20be%20kept%20in-place%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2356750%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2356750%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20tried%20connecting%20a%20O365%20PT%20to%20a%20Power%20BI%20Premium%20Per%20User%20model%20with%20imported%20data%20and%20still%20get%20the%20%22old%20message%22%20of%20not%20supported%20%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ptmartin_0-1621062969473.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280825iBBFF736C99C4C411%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ptmartin_0-1621062969473.png%22%20alt%3D%22ptmartin_0-1621062969473.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWould%20appreciate%20any%20advice%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ESTILL%20DOES%20NOT%20CONNECT%208TH%20JUNE%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20the%20online%20connection%20work%20with%20Pro%20licenses%20of%20Power%20BI%20or%20only%20Power%20BI%20Premium%20%2F%20Premium%20Per%20User%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2561123%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2561123%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F297306%22%20target%3D%22_blank%22%3E%40yunling%3C%2FA%3E%26nbsp%3BGreat%20-%20long%20awaited%20-%20feature.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EYou%20say%20%22This%20new%20feature%20has%20started%20rolling%20out%20across%20Microsoft%20365%20tenants%2C%20and%20we%20expect%20full%20roll%20out%20over%20the%20next%20few%20months%22.%20Is%20there%20any%20more%20detail%20on%20that%3F%20Will%20there%20be%20a%20further%20update%20on%20this%20blog%3F%20Would%20be%20very%20useful%20to%20know%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2646504%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2646504%22%20slang%3D%22en-US%22%3E%3CP%3EQuick%20Update%3A%20Please%20note%20that%20the%20Excel%20for%20the%20web%20feature%20announced%20in%20this%20post%20(i.e.%20Power%20BI%20PivotTable%20refresh%20and%20interaction)%20is%20now%20fully%20rolled%20out.%26nbsp%3B%20In%20addition%2C%20the%20Windows%20capabilities%20mentioned%20(i.e.%20drag%20and%20drop%20aggregations%2C%20date%20support%2C%20and%20visual%20polish)%20are%20being%20rolled%20out%20to%20the%20Insiders%20Slow%20audience.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2646643%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2646643%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E!%26nbsp%3B%20I%20still%20have%20the%20bad%20habit%20of%20using%20the%20old%20terms.%26nbsp%3B%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2646550%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2646550%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20in%20case%3C%2FP%3E%0A%3CP%3EInsiders%20Slow%20%3D%3D%20Current%20(Preview)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2651045%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2651045%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20plan%20to%20remove%20the%20above%20note%3CSPAN%3E%3A%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%22refresh%20and%20interactivity%20of%20Power%20BI%20datasets%20with%20a%20live%20connection%20to%20Azure%20Analysis%20Services%20in%20Excel%20for%20the%20web%20is%20not%20supported.%22%20once%20the%20feature%20landed%20in%20Excel%20Online%3F%20Or%20will%20this%20capability%20not%20been%20addressed%20any%20time%20soon%3F%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2697975%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2697975%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EAny%20ETA%20for%20the%20rolling%20out%20of%26nbsp%3B%3CSPAN%3Ethe%20Windows%20capabilities%20mentioned%20(i.e.%20drag%20and%20drop%20aggregations%2C%20date%20support%2C%20and%20visual%20polish)%20to%20the%20general%20audience%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2810222%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20BI%20connected%20PivotTables%20in%20Excel%20for%20the%20web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2810222%22%20slang%3D%22en-US%22%3E%3CP%3EOnce%20you%20have%20data%20connected%20to%20your%20source%20with%20Power%20BI%20in%20Desktop%20Excel%2C%20then%2C%20you%20can%20use%20one%20of%20my%20analytics%20templates%20to%20detect%2C%20visualize%20and%20explore%20unusual%20data%20points%20in%20a%20dataset%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcool-number-crunching-template.sellfy.store%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ECool%20Number%20Crunching%20Templates%20(sellfy.store)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎May 04 2021 11:36 AM
Updated by: