Simplifying enterprise data discovery and analysis in Microsoft Excel

Published May 06 2020 08:00 AM 40.7K Views

We know that Excel is one of the most widely used tools in the world for understanding data and making decisions based on that data. It's used by hundreds of millions of users each month in almost every type of company imaginable. To better meet the needs of our users, Excel has evolved and transformed to understand you and your data in a way that has not been available until now. We are excited to share new capabilities that will ease access to trusted datasets and new ways to analyze and manipulate that data.

 

Over the years you have told us that you wanted Excel to have better integration with Power BI, more flexibility to get data in the grid, and better management for sensitive data, and today we are announcing this exciting step towards that goal! By simplifying access to Power BI data, we have streamlined the ability for users to consume, manipulate, and analyze reliable data all within Excel. In short, Excel now better understands you and your data.

 

Connect to Power BI Datasets Without Leaving Excel

 

Today, we are introducing two new ways to access Power BI data from within Excel — Excel data types and through PivotTables connected to Power BI. With the click of a button users can now discover Power BI datasets all without having to leave Excel! By using Power BI certified and promoted dataset capabilities, organizations enable more users to find and use relevant and refreshable data to make better decisions.

 

Using Data Types, you can quickly find details from featured tables in Power BI datasets within Excel’s data types gallery. Data Types give users the flexibility to organize information in any way they want within the Excel grid. This allows you to use formulas, build reports and analyze your data in a familiar and simpler way.

 

PBI Data Types GIF v4.gif

 Power BI data type in Excel

 

PBI Image 1.png

Analyzing Power BI datasets in Excel using PivotTable

 

We have also added the ability for PivotTables connected to datasets stored in Power BI to be created in Excel, allowing you to continue to use of the tools you know and love. This new capability creates a live connection to the underlying dataset in Power BI, meaning updates within the source are published to the reports connected to it. Excel PivotTables also respect the Microsoft Information Protection sensitivity labels applied to the file when the PivotTable was created. This evolution of Excel promotes the adoption of certified datasets within your organization, helping to ensure authoritative data sources are used when making critical decisions in your business.

 

These new capabilities will start rolling out to Office Insiders later this year. Please refer to the Release Notes for Office Insiders for the latest update.

 

Microsoft Information Protection (MIP)

 

Sensitivity labels from the Microsoft Information Protection framework, available in both Power BI and Office apps, lets you classify and protect your organization's data while making sure that user productivity and their ability to collaborate is not hindered. Sensitivity labels are currently available and will persist when applied from Power BI content and exported to Excel, PowerPoint, and PDF files. However, with this release we are taking Sensitivity labels one step further. When you connect to a Power BI dataset from Excel, that dataset's Sensitivity label will be inherited and applied to the Excel file and all associated outcomes like headers/footers and encryption.

 

MIP.png

Power BI dataset's sensitivity label shown in Excel 

 

With the new, more robust integrations between Excel and Power BI we have given your organization more potential, more visibility and more information protection in Excel’s familiar and easy to use interface, all with fewer clicks. We welcome you to try this out for yourself and sign up to be an insider to get all the hottest tips and promotions!

 

Excel’s new capabilities will start rolling out to Office Insiders later this year. Refer to these Release Notes for Office Insiders for the latest update.

 

To learn more,

 

 

 

60 Comments
%3CLINGO-SUB%20id%3D%22lingo-sub-1354160%22%20slang%3D%22en-US%22%3ESimplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1354160%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20know%20that%20Excel%20is%20one%20of%20the%20most%20widely%20used%20tools%20in%20the%20world%20for%20understanding%20data%20and%20making%20decisions%20based%20on%20that%20data.%20It's%20used%20by%20hundreds%20of%20millions%20of%20users%20each%20month%20in%20almost%20every%20type%20of%20company%20imaginable.%20To%20better%20meet%20the%20needs%20of%20our%20users%2C%20Excel%20has%20evolved%20and%20transformed%20to%20understand%20you%20and%20your%20data%20in%20a%20way%20that%20has%20not%20been%20available%20until%20now.%20We%20are%20excited%20to%20share%20new%20capabilities%20that%20will%20ease%20access%20to%20trusted%20datasets%20and%20new%20ways%20to%20analyze%20and%20manipulate%20that%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOver%20the%20years%20you%20have%20told%20us%20that%20you%20wanted%20Excel%20to%20have%20better%20integration%20with%20%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EPower%20BI%3C%2FA%3E%2C%20more%20flexibility%20to%20get%20data%20in%20the%20grid%2C%20and%20better%20management%20for%20sensitive%20data%2C%20and%20today%20we%20are%20announcing%20this%20exciting%20step%20towards%20that%20goal!%20By%20simplifying%20access%20to%20Power%20BI%20data%2C%20we%20have%20streamlined%20the%20ability%20for%20users%20to%20consume%2C%20manipulate%2C%20and%20analyze%20reliable%20data%20all%20within%20Excel.%20In%20short%2C%20Excel%20now%20better%20understands%20you%20and%20your%20data.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%20id%3D%22toc-hId--1354470162%22%3EConnect%20to%20Power%20BI%20Datasets%20Without%20Leaving%20Excel%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EToday%2C%20we%20are%20introducing%20two%20new%20ways%20to%20access%20Power%20BI%20data%20from%20within%20Excel%20%E2%80%94%20Excel%20data%20types%20and%20through%20PivotTables%20connected%20to%20Power%20BI.%20With%20the%20click%20of%20a%20button%20users%20can%20now%20discover%20Power%20BI%20datasets%20all%20without%20having%20to%20leave%20Excel!%20By%20using%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DAZoeT4akV5M%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EPower%20BI%20certified%20and%20promoted%20dataset%20capabilities%3C%2FA%3E%2C%20organizations%20enable%20more%20users%20to%20find%20and%20use%20relevant%20and%20refreshable%20data%20to%20make%20better%20decisions.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUsing%20Data%20Types%2C%20you%20can%20quickly%20find%20details%20from%20featured%20tables%20in%20Power%20BI%20datasets%20within%20Excel%E2%80%99s%20data%20types%20gallery.%20Data%20Types%20give%20users%20the%20flexibility%20to%20organize%20information%20%3CEM%3Ein%20any%20way%20they%20want%3C%2FEM%3E%20within%20the%20Excel%20grid.%20This%20allows%20you%20to%20use%20formulas%2C%20build%20reports%20and%20analyze%20your%20data%20in%20a%20familiar%20and%20simpler%20way.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-center%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22PBI%20Data%20Types%20GIF%20v4.gif%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188815i650954B104CC4592%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22PBI%20Data%20Types%20GIF%20v4.gif%22%20alt%3D%22PBI%20Data%20Types%20GIF%20v4.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-left%22%3E%26nbsp%3B%3CEM%20style%3D%22font-family%3A%20inherit%3B%22%3EPower%20BI%20data%20type%20in%20Excel%3C%2FEM%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-left%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-left%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22PBI%20Image%201.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188780i2D71DAB0CA154AF8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22PBI%20Image%201.png%22%20alt%3D%22PBI%20Image%201.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-left%22%3E%3CEM%3EAnalyzing%20Power%20BI%20datasets%20in%20Excel%20using%20PivotTable%3C%2FEM%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-left%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20have%20also%20added%20the%20ability%20for%20PivotTables%20connected%20to%20datasets%20stored%20in%20Power%20BI%20to%20be%20created%20in%20Excel%2C%20allowing%20you%20to%20continue%20to%20use%20of%20the%20tools%20you%20know%20and%20love.%20This%20new%20capability%20creates%20a%20live%20connection%20to%20the%20underlying%20dataset%20in%20Power%20BI%2C%20meaning%20updates%20within%20the%20source%20are%20published%20to%20the%20reports%20connected%20to%20it.%20Excel%20PivotTables%20also%20respect%20the%20Microsoft%20Information%20Protection%20sensitivity%20labels%20applied%20to%20the%20file%20when%20the%20PivotTable%20was%20created.%20This%20evolution%20of%20Excel%20promotes%20the%20adoption%20of%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2Fservice-datasets-certify%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ecertified%20datasets%3C%2FA%3E%20within%20your%20organization%2C%20helping%20to%20ensure%20authoritative%20data%20sources%20are%20used%20when%20making%20critical%20decisions%20in%20your%20business.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThese%20new%20capabilities%20will%20start%20rolling%20out%20to%20Office%20Insiders%20later%20this%20year.%20Please%20refer%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Frelease-notes-office-insider%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERelease%20Notes%20for%20Office%20Insiders%3C%2FA%3E%20for%20the%20latest%20update.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%20id%3D%22toc-hId-1133042671%22%3EMicrosoft%20Information%20Protection%20(MIP)%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESensitivity%20labels%20from%20the%20Microsoft%20Information%20Protection%20framework%2C%20available%20in%20both%20Power%20BI%20and%20Office%20apps%2C%20lets%20you%20classify%20and%20protect%20your%20organization's%20data%20while%20making%20sure%20that%20user%20productivity%20and%20their%20ability%20to%20collaborate%20is%20not%20hindered.%20Sensitivity%20labels%20are%20currently%20available%20and%20will%20persist%20when%20applied%20from%20Power%20BI%20content%20and%20exported%20to%20Excel%2C%20PowerPoint%2C%20and%20PDF%20files.%20However%2C%20with%20this%20release%20we%20are%20taking%20Sensitivity%20labels%20one%20step%20further.%20When%20you%20connect%20to%20a%20Power%20BI%20dataset%20from%20Excel%2C%20that%20dataset's%20Sensitivity%20label%20will%20be%20inherited%20and%20applied%20to%20the%20Excel%20file%20and%20all%20associated%20outcomes%20like%20headers%2Ffooters%20and%20encryption.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-center%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22MIP.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188783i07BB62867E412802%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22MIP.png%22%20alt%3D%22MIP.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-left%22%3E%3CEM%3EPower%20BI%20dataset's%20sensitivity%20label%20shown%20in%20Excel%3C%2FEM%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-left%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWith%20the%20new%2C%20more%20robust%20integrations%20between%20Excel%20and%20Power%20BI%20we%20have%20given%20your%20organization%20more%20potential%2C%20more%20visibility%20and%20more%20information%20protection%20in%20Excel%E2%80%99s%20familiar%20and%20easy%20to%20use%20interface%2C%20all%20with%20fewer%20clicks.%20The%20team%20here%20at%20Microsoft%20is%20proud%20to%20offer%20Excel%2C%20MIP%2C%20and%20Power%20BI%20within%20the%20Microsoft%20E5%20license!%20We%20welcome%20you%20to%20try%20this%20out%20for%20yourself%20and%20sign%20up%20to%20be%20an%20insider%20to%20get%20all%20the%20hottest%20tips%20and%20promotions!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%E2%80%99s%20new%20capabilities%20will%20start%20rolling%20out%20to%20Office%20Insiders%20later%20this%20year.%20Refer%20to%20these%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Frelease-notes-office-insider%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERelease%20Notes%20for%20Office%20Insiders%3C%2FA%3E%20for%20the%20latest%20update.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20learn%20more%2C%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESubscribe%20to%20the%20%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%20for%20the%20latest%20product%20announcements%20and%20updates%3C%2FLI%3E%0A%3CLI%3EJoin%20the%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fxlcommunity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EExcel%20Community%3C%2FA%3E%20to%20connect%20with%20others%2C%20ask%20questions%20and%20get%20answers%3C%2FLI%3E%0A%3CLI%3EFollow%20us%20on%20social%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fmsexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%40msexcel%3C%2FA%3E%26nbsp%3Band%20%3CA%20href%3D%22https%3A%2F%2Fwww.facebook.com%2Fmicrosoftexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%2Fmicrosoftexcel%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1354160%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22PBI%20Data%20Types%20GIF%20v4.gif%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188815i650954B104CC4592%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22PBI%20Data%20Types%20GIF%20v4.gif%22%20alt%3D%22PBI%20Data%20Types%20GIF%20v4.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EConsume%2C%20manipulate%2C%20and%20analyze%20Power%20BI%20data%20all%20within%20Excel%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1354160%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnnouncements%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1364329%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1364329%22%20slang%3D%22en-US%22%3E%3CP%3EThat's%20cool!%20The%20only%20question%20how%20late%20this%20year%20will%20start%20the%20rolling%20out...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1364692%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1364692%22%20slang%3D%22en-US%22%3E%3CP%3EVery%20interesting%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1366216%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1366216%22%20slang%3D%22en-US%22%3E%3CP%3EAmazing...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1369568%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1369568%22%20slang%3D%22en-US%22%3E%3CP%3EBrian%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPower%20BI%20as%20a%20DataType%20is%20brilliant%20!!.%20While%26nbsp%3Blive%20connect%20to%20a%20PBI%20Dataset%20has%20been%20around%20for%202%20years%20with%20Connect%20to%20PBI%20-%20making%20it%20native%20inside%20a%20Pivot%20Button%20is%20fantastic.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20that%20is%20remaining%20is%20to%20bring%20all%20the%20distributed%20components%20together%20on%20a%20unified%20Power%20BI%20Tab%20-%20Remember%20%22We%20are%20better%20together%22%20....and%20all%20those%20nice%20sounding%20conference%20only%20taglines%26nbsp%3B%20%26nbsp%3B-%20you%20also%20need%20to%20Include%20Custom%20Visuals%20instead%20of%20prematurely%20deprecated%20Power%20View%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFeel%20free%20to%20suggest%20this%20to%20the%20Office%20UX%20team%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excelpbi_1-1588856753106.png%22%20style%3D%22width%3A%201042px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189747i7A963C8294A84D62%2Fimage-dimensions%2F1042x120%3Fv%3D1.0%22%20width%3D%221042%22%20height%3D%22120%22%20title%3D%22excelpbi_1-1588856753106.png%22%20alt%3D%22excelpbi_1-1588856753106.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3ESam%3C%2FP%3E%3CP%3EPS%3A%20A%20intelligently%20designed%20Home%20Tab%20would%20not%20hurt%20either%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excelpbi_3-1588857345465.png%22%20style%3D%22width%3A%201067px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189756i116ED6DC7E66A765%2Fimage-dimensions%2F1067x120%3Fv%3D1.0%22%20width%3D%221067%22%20height%3D%22120%22%20title%3D%22excelpbi_3-1588857345465.png%22%20alt%3D%22excelpbi_3-1588857345465.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1369713%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1369713%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20forgot%20to%20mention%20Power%20Query%20Data%20Types%20which%20is%20also%20amazing%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3ESam%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1370083%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1370083%22%20slang%3D%22en-US%22%3E%3CP%3ECool%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1371418%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1371418%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20assuming%20that%20%22within%20the%20Microsoft%20E5%20license%22%20should%20say%20%22within%20the%20Microsoft%20365%20E5%20license%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt'd%20be%20ideal%20if%20posts%20like%20this%20that%20cross%20technology%20elaborated%20a%20bit%20more%20on%20exactly%20what%20the%20licensing%20requirements%20were%2C%20particularly%20since%20Microsoft%20365%20E5%20(the%20most%20expensive%20variant%20of%20Microsoft%20365%20suites)%20isn't%20licensed%20by%20all%20organizations%2C%20and%20it's%20not%20necessarily%20clear%20which%20feature%20requires%20which%20license.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1371993%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1371993%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F545693%22%20target%3D%22_blank%22%3E%40excelpbi%3C%2FA%3E%26nbsp%3B-%20what%20Power%20Query%20data%20types%20are%20you%20referring%20to%3F%3CBR%20%2F%3E%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-%20the%20Access%20Power%20BI%20DataSets%20is%20already%20in%20my%20Insider%20build.%20Showed%20up%20yesterday.%20Seems%20the%20same%20as%20the%20Analyze%20in%20Excel%20tools%2C%20but%20integrated%20and%20much%20more%20stable.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1372270%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1372270%22%20slang%3D%22en-US%22%3E%3CP%3E%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%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F19700%22%20target%3D%22_blank%22%3E%40Ed%20Hansberry%3C%2FA%3E%26nbsp%3Bis%20correct...%20the%20access%20to%20PBI%20data%20sets%20and%20%22insert%20Pivot%20table%20from%20PBI%22%20are%20already%20available%20to%20Insiders.%20PBI%20data%20types%20will%20be%20available%20to%20Insiders%20later%20this%20month.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F19700%22%20target%3D%22_blank%22%3E%40Ed%20Hansberry%3C%2FA%3E%26nbsp%3Banother%20piece%20of%20this%20release%20that%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F545693%22%20target%3D%22_blank%22%3E%40excelpbi%3C%2FA%3E%26nbsp%3Bwas%20referring%20to%20is%20that%20you%20will%20be%20able%20to%20use%20Power%20Query%20to%20generate%20your%20own%20data%20types%20from%20any%20data%20source%20you%20connect%20to.%20We%20didn't%20cover%20it%20in%20the%20blog%20post%2C%20but%20we%20covered%20it%20in%20the%20video%20session%20yesterday%20afternoon.%20That%20functionality%20is%20probably%20a%20month%20or%20so%20out%2C%20so%20we%20didn't%20talk%20about%20it%20as%20much%20and%20will%20cover%20in%20more%20depth%20once%20it's%20closer%20to%20release.%20I%20agree%20with%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F545693%22%20target%3D%22_blank%22%3E%40excelpbi%3C%2FA%3E%26nbsp%3Bthough%2C%20it's%20very%20powerful.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F68941%22%20target%3D%22_blank%22%3E%40Wes%20Miller%3C%2FA%3E%26nbsp%3B%2C%20sorry%20about%20any%20confusion%20there.%20Are%20you%20saying%20the%20confusion%20was%20that%20we%20weren't%20clear%20between%20M365%20and%20O365%2C%20or%20that%20we%20just%20said%20Microsoft%20E5%20rather%20than%20Microsoft%20365%20E5%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1372864%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1372864%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9480%22%20target%3D%22_blank%22%3E%40Brian%20Jones%20(OFFICE)%3C%2FA%3E%26nbsp%3B%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F236847%22%20target%3D%22_blank%22%3E%40Ed%20Hansberry%3C%2FA%3E%26nbsp%3B%20-%20yes%2C%20it%20appeared%20in%20half%20an%20hour%20after%20I%20posted%20the%20comment%2C%20both%20on%20Insider%20Fast%20and%20Monthly%20(Targeted).%20What%20is%20not%20clear%20is%20E5%20licensing%2C%20doesn't%20matter%20how%20we%20call%20this%20plan.%20In%20particular%2C%20it's%20not%20clear%20why%20practically%20exactly%20the%20same%20functionality%20of%20Analyse%20in%20Excel%20requires%20mainly%20Power%20BI%20Pro%20license%20and%20doesn't%20care%20if%20user%20on%20E5%20or%20not.%20IMHO%2C%20differentiation%20in%20production%20on%20E5%20and%20the%20rest%20will%20kill%20new%20functionality%20or%20people%20will%20find%20the%20other%20way%20to%20use%20it%2C%20e.g.%20with%20Pro%20license%20Analyse%20in%20Excel%20for%20Pivot%20Tables%20and%20Power%20BI%20Desktop%20for%20creating%20new%20data%20types.%20I%20don't%20know%20how%20it%20will%20be%2C%20but%20many%20chances%20the%20story%20with%20licensing%20of%20Power%20Pivot%20will%20be%20repeated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1374384%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374384%22%20slang%3D%22en-US%22%3E%3CP%3EVery%20cool%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-%20didn't%20even%20think%20to%20test%20the%20Monthly%20Targeted%20build.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20I%20understand%20your%20issue%20on%20the%20licensing.%20This%20seems%20to%20require%20a%20Power%20BI%20Pro%20license%20which%20is%26nbsp%3B%3CEM%3Eincluded%26nbsp%3B%3C%2FEM%3Ein%20E5.%20I%20have%20an%20E3%20license%20with%20a%20Power%20BI%20Pro%20license%20and%20it%20works%20fine.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1374506%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374506%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20anyone%20able%20to%20insert%20a%20TimeLine%20slicer%20from%20a%20workbook%20connected%20to%20a%20Power%20BI%20Dataset%3F%20My%20Excel%20(Insider%202006)%20just%20changes%20the%20cursor%20to%20the%20spinning%20circle%20and%20never%20recovers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegular%20slicers%20seem%20to%20work%20ok%2C%20but%20not%20timelines.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1374440%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374440%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20see%20%22Organization%22%20in%20Excel%20Data%20Types%20available%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2323244%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2323244%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20account%20with%20a%20Microsoft%20365%20E3%20and%20Power%20BI%20Pro%20license%2C%20as%20well%20as%20Excel%20Semi-Annual%20Enterprise%20Channel%20on%20the%20latest%20build%2C%20Version%202008%20(Build%2013127.21506).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccording%20to%20the%20release%20notes%20the%20Pivot%20tables%20from%20Power%20BI%20dataset%20was%20released%20in%20January%202021%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fsemi-annual-enterprise-channel%23version-2008-january-12%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERelease%20notes%20for%20Semi-Annual%20Enterprise%20Channel%20releases%20-%20Office%20release%20notes%20%7C%20Microsoft%20Docs%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20I%20still%20can't%20see%20the%20Get%20Data%20-%26gt%3B%20From%20Power%20BI%20or%20Insert%20Pivot%20Table%20-%26gt%3B%20From%20Power%20BI%20option.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20have%20spotted%20is%20this%2C%20from%20the%20Power%20BI%20Docs%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2Fcollaborate-share%2Fservice-analyze-in-excel%23other-ways-to-access-power-bi-datasets-from-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAnalyze%20in%20Excel%20for%20Power%20BI%20-%20Power%20BI%20%7C%20Microsoft%20Docs%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22%3CSPAN%3EUsers%20with%20specific%20Office%20SKUs%20can%20also%20connect%20to%20Power%20BI%20datasets%20from%20within%20Excel%20by%20using%20the%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EGet%20Data%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bfeature%20in%20Excel.%20If%20your%20SKU%20does%20not%20support%20this%20feature%2C%20the%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EGet%20Data%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bmenu%20option%20does%20not%20appear.%3C%2FSPAN%3E%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20anyone%20aware%20of%20which%20SKUs%20are%20valid%3F%20According%20to%20earlier%20blog%20posts%20here%20Microsoft%20365%20E5%20was%20no%20longer%20a%20requirement%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3562%22%20target%3D%22_blank%22%3E%40Carlos%20Otero%3C%2FA%3E%26nbsp%3B%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1374516%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374516%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F661002%22%20target%3D%22_blank%22%3E%40ricafonyat%3C%2FA%3E%26nbsp%3B%2C%20it's%20not%20available%20and%20will%20not%20be%20available%20from%20the%20box.%20That%20will%20be%20custom%20data%20type%20which%20you%20create%20yourself%20in%20Power%20Query%20joining%20few%20columns%20(aka%20fields)%20into%20one%20type%20list%20(or%20set%3F%20-%20don't%20know%20how%20to%20name).%20You%20may%20create%20as%20many%20such%20data%20types%20as%20needed%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1374634%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374634%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9480%22%20target%3D%22_blank%22%3E%40Brian%20Jones%20(OFFICE)%3C%2FA%3E%26nbsp%3BFinally%2C%20been%20waiting%20for%20this%20for%20a%20while!%20But%20does%20the%20power%20bi%20data%20model%20(i.e.%20relationships)%20get%20transferred%20to%20excel%3F%20Because%20this%20is%20what%20has%20been%20missing%20in%20the%20%22Analyze%20in%20Excel%22%20feature%2C%20the%20tables%20from%20the%20power%20bi%20dataset%20get%20exported%20to%20excel%20but%20not%20the%20relationships%20between%20the%20tables.%20Also%2C%20how%20do%20I%20preview%20this%20feature%3F%20(i.e.%20how%20do%20I%20become%20an%20insider%3F)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1374683%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374683%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F236847%22%20target%3D%22_blank%22%3E%40Ed%20Hansberry%3C%2FA%3E%26nbsp%3B%2C%20it's%20the%20same%20with%20me%2C%20I%20tried%20to%20add%20time%20line%20and%20Excel%20hangs%20in%20never%20ended%20loop%20(I%20waited%20about%2020%20min).%20Will%20send%20a%20frown.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1374723%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374723%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F661081%22%20target%3D%22_blank%22%3E%40chauggaard%3C%2FA%3E%26nbsp%3B%2C%20to%20become%20an%20insider%20that's%20a%20bit%20different%20procedure%20for%20business%20users%20and%20consumers.%20Please%20check%20this%20site%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fen-gb%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EBecome%20an%20Office%20Insider%3C%2FA%3E%26nbsp%3B%2C%20all%20information%20is%20here.%3C%2FP%3E%0A%3CP%3EFunctionality%20of%20the%20new%20connector%20to%20Power%20BI%20dataset%20is%20exactly%20the%20same%20as%20for%20Analyse%20in%20Excel%2C%20some%20cosmetic%20is%20different.%20You%20are%20connected%20to%20data%20model%20published%20on%20Power%20BI%20services%20and%20could%20build%20Pivot%20Tables%20based%20on%20it.%20The%20only%20you%20can%20do%20all%20above%20within%20the%20Excel.%20You%20can't%20add%20additional%20tables%20to%20data%20model%20and%20add%20additional%20relationships%2C%20only%20use%20already%20existing%20ones.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1374744%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374744%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20confirm%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%3C%2FP%3E%3CP%3EI%20too%20sent%20a%20frown.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9480%22%20target%3D%22_blank%22%3E%40Brian%20Jones%20(OFFICE)%3C%2FA%3E%26nbsp%3Bseems%20a%20bug%20with%20the%20timeline%20slicer%20that%20will%20hang%20excel%20and%20cause%20you%20to%20lose%20all%20changes%20since%20last%20save.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1374751%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374751%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F236847%22%20target%3D%22_blank%22%3E%40Ed%20Hansberry%3C%2FA%3E%26nbsp%3B%2C%20timeline%20works!%20Just%20add%20it%20not%20from%20the%20ribbon%2C%20but%20right%20click%20Calendar%20or%20whatever%20you%20have%2C%20Add%20as%20Timeline%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20321px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190195iDC961EB4BC08099A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20it's%20here%3C%2FP%3E%0A%3CDIV%20id%3D%22tinyMceEditorSergei%20Baklan_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20id%3D%22tinyMceEditorSergei%20Baklan_0%22%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3EI%20checked%20both%20on%20Insiders%20Fast%20and%20Monthly%20(Targeted)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1375078%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1375078%22%20slang%3D%22en-US%22%3E%3CP%3E%22Are%20you%20saying%20the%20confusion%20was%20that%20we%20weren't%20clear%20between%20M365%20and%20O365%2C%20or%20that%20we%20just%20said%20Microsoft%20E5%20rather%20than%20Microsoft%20365%20E5%3F%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes.%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%408341BD79091AF36AA2A09063B554B5CD%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1%3A%20There%20are%20a%20lot%20of%20services%20and%20suites%20-%20it's%20ideal%20to%20always%20be%20explicit%20if%20you%20mean%20%22Microsoft%20365%20E5%22%2C%20particularly%20now%20with%20the%20(confusing%2C%20IMHO)%20rebranding%20of%20many%20Office%20365%20services%2Ffeatures%20as%20%22Microsoft%20365%22%20-%20especially%20since%20there's%20no%20%22Microsoft%20E5%22%20suite.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2%3A%20A%20lot%20of%20customers%20-%20whether%20it%20works%20out%20ideally%20or%20not%20in%20the%20end%2C%20license%20things%20on%20an%26nbsp%3B%C3%A0%20la%20carte%20basis%20rather%20than%20as%20whole%20suites.%20So%20for%20things%20like%20this%2C%20which%20would%20appear%20to%20require%20subscriptions%20to%20Microsoft%20365%20Apps%20for%20enterprise%20(the%20artist%20formerly%20known%20as%20Office%20365%20ProPlus)%2C%20Power%20BI%20Pro%2C%20and%3CBR%20%2F%3EAzure%20Information%20Protection%20Premium%20(P2%3F%20P1%3F)%2C%20it%20is%20really%20useful%20for%20customers%20if%20you%20can%20define%20what%20licensing%20is%20necessary%20in%20order%20for%20a%20feature%20to%20be%20available%20(or%20even%20just%20licensed%20correctly%2C%20as%20so%20many%20things%20don't%20do%20comprehensive%20license%20enforcement%20anymore).%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1377479%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377479%22%20slang%3D%22en-US%22%3E%3CP%3EBrian%20-%20on%20a%20lighter%20note%20is%20there%20a%20%22ReName%22%20Vertical%20in%20Microsoft%20whose%20job%20is%20to%20Rename%20products%20and%20make%20them%20sound%20new%3C%2FP%3E%3CP%3ESo%20Data%20Explorer%20becomes%20Power%20Query%20(which%20the%20Rename%20vertical%20thinks%20is%20too%20intimidating%20because%20of%20the%20use%20of%20the%20word%20power)%20which%20becomes%3C%2FP%3E%3CP%3EGet%20and%20Transform%20(and%20loses%20it%20decicated%20tab%20in%20Excel)%20which%20becomes%20Get%20Data%20in%20PBI%20Desktop%20and%20Data%20Flows%20in%20the%20Service%3C%2FP%3E%3CP%3ELikewise%20Gemini%20becomes%20Power%20Pivot%20and%20fortunately%20does%20not%20become%20the%20less%20intimidating%20Crunch%20and%20Punch%20and%20becomes%20Data%20model%20in%20PBI%20Desktop%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20too%20with%20Office%20365%20Pro%20Plus%20becoming%20Microsoft%20365%20Apps%20for%20enterprise%20-%20Has%20anyone%20evaluated%20the%20cost%20of%20Renaming%20-%20The%20hundreds%20of%20places%20where%20some%20poor%20bloke%20has%20to%20go%20and%20update%20the%20names%20(docs%2C%20webpages%2C%20application%20flash%20screens%20)%3C%2FP%3E%3CP%3EOr%20is%20there%20a%20Parameter%20set%20where%20you%20can%20change%20the%20name%20once%20-%20and%20its%20reflected%20everywhere%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3ESam%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397870%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397870%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20i%20use%20analyse%20in%20excel%20.odc%20connection%20to%20create%20a%20pivot%20table%20and%20a%20chart%20with%20a%20simple%20excel%20slicer.%20Would%20i%20be%20able%20to%20then%20upload%20that%20excel%20to%20power%20bi%20service%20and%20interact%20in%20excel%20online%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20external%20connections%20are%20not%20supported%20in%20excel%20online%20so%20if%20i%20click%20on%20slicer%20within%20workbook%20published%20onto%20power%20bi%20service%2C%20it%20errors%20out.%20Even%20though%20its%20like%20a%20live%20connection%20to%20power%20bi%20dataset.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20dataset%20is%20promoted%20within%20org%2C%20does%20this%20error%20go%20away%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1617614%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1617614%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20news%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3562%22%20target%3D%22_blank%22%3E%40Carlos%20Otero%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1402158%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1402158%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20chance%20we%20will%20ever%20get%20the%20ability%20to%20connect%20to%20Dataflows%20using%20PowerQuery%2FGetData%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMost%20of%20our%20key%20users%20want%20to%20create%20their%20own%20Excel-based%20analysis%20(Not%20PowerBI)%2C%20we%20need%20a%20way%20to%20give%20them%20access%20to%20a%20consistent%2C%20up%20to%20date%20version%20of%20the%20data.%20Analyse%20in%20Excel%20is%20not%20a%20good%20solution%20(even%20with%20a%20new%20makeover)%2C%20users%20want%20to%20be%20able%20to%20easily%20manipulate%20data%20structures%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20believe%20this%20functionality%20is%20currently%20missing%20unless%20its%20a%20deliberate%20strategy%20from%20MS%20for%20reasons%20I%20don't%20understand.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1402618%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1402618%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20hoping%20Power%20Query%20to%20data%20flows%20was%20coming.%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fehansalytics%2Fstatus%2F1184889696368746496%3Fs%3D20%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EFor%20many%20months%20there%20was%20a%20Power%20Platform%3C%2FA%3E%20menu%20in%20Power%20Query%20that%20was%20greyed%20out.%20Now%20it%20is%20gone.%20Disappeared%20the%20same%20build%20the%20Power%20BI%20Dataset%20showed%20up.%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%409839A717402516D64549B98324F4F0C1%2Fimages%2Femoticons%2Fsad_40x40_1.gif%22%20alt%3D%22%3Asad%3A%22%20title%3D%22%3Asad%3A%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1402775%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1402775%22%20slang%3D%22en-US%22%3E%3CP%3EAll%20super%20cool%2C%20but%20%26nbsp%3B%3CSPAN%3EMSOLAP%20to%20PBI%20Azure%20datasets%20still%20missing%20from%20Excel%20Mac.%20%26nbsp%3B%20ODC%20connections%20are%20useful%20only%20for%20windows%20users%2C%20Mac%20users%20have%20to%20fall%20back%20to%20ODBC%20on%20premise%20datasets.%20IT%20departments%20have%20to%20maintain%20legacy%20connections%20instead%20of%20all%20cloud%20PBI.%26nbsp%3B%20How%20long%20until%20we%20see%20this%20in%20excel%20for%20mac%20Brian%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1403307%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1403307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F19113%22%20target%3D%22_blank%22%3E%40Brian%3C%2FA%3E%3C%2FP%3E%3CP%3EThe%20From%20Power%20BI%20Option%20in%20the%20Pivot%20button%20Disappeared%20in%20Ver%202005%2C%20Build%2012827.20160%20Monthly%20Channel%20(Targeted)%20Office%20365%20Pro%20Plus%20-%20Is%20this%20a%20temporary%20glitch%20or%20are%20we%20moving%20towards%20E%24(5)%20only%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%26nbsp%3B%3C%2FP%3E%3CP%3ESam%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1403576%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1403576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F545693%22%20target%3D%22_blank%22%3E%40excelpbi%3C%2FA%3E%26nbsp%3B%20Sam%2C%20it's%20here%2C%20exactly%20the%20same%20build%20and%20channel.%20The%20only%20it%20is%20updated%20-%20menu%20is%20named%20not%20as%20%3CSTRONG%3EFrom%20Power%20BI%20dataset%3C%2FSTRONG%3E%20but%20as%20%3CSTRONG%3EFrom%20Power%20BI%20(tenant%20name)%3C%2FSTRONG%3E.%20Perhaps%20some%20other%20changes%20as%20well%2C%20didn't%20find%20so%20far.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1404178%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1404178%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20have%20the%20Power%20BI%20Data%20Types%3F%20I%20have%20an%20Insider%20build%2C%20updated%20today%2C%20and%20many%20Monthly%20Targeted%20builds%20updated%20recently%20(last%20week%20or%20so)%20and%20still%20no%20Power%20BI%20Data%20Types%2C%20and%20this%20is%20even%20more%20critical%20given%20the%20new%20Featured%20Tables%20feature%20released%20in%20Power%20BI%20today%20for%20the%20March%202020%20build.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1407430%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1407430%22%20slang%3D%22en-US%22%3E%3CP%3E%40Sergei%3C%2FP%3E%3CP%3EI%20checked%20-%20its%20not%20there%20-%20The%20Pivot%20Table%20button%20is%20no%20longer%20a%20split%20button%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excelpbi_0-1590034437853.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193472i441014141A679EAC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22excelpbi_0-1590034437853.png%22%20alt%3D%22excelpbi_0-1590034437853.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20searched%20in%20the%20Command%20Well%20as%20well%20under%20From%20--%20not%20there%20either%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excelpbi_1-1590034561419.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193473i0B627F776E293644%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22excelpbi_1-1590034561419.png%22%20alt%3D%22excelpbi_1-1590034561419.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3ESam%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620843%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620843%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3562%22%20target%3D%22_blank%22%3E%40Carlos%20Otero%3C%2FA%3E%26nbsp%3B%2C%20first%20thanks%20for%20such%20decision.%20I've%20seen%20your%20note%20about%20deployment%20time%2C%20however%20Microsoft%20365%20Roadmap%20mentions%20Q2%20CY%202020%20as%20the%20target%20release%20date%20for%20this%20functionality.%20may%20we%20expect%20at%20least%20Q3%20(calendar%2C%20not%20Microsoft%20year)%20for%20E3%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1408075%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1408075%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F545693%22%20target%3D%22_blank%22%3E%40excelpbi%3C%2FA%3E%26nbsp%3Bwhen%20most%20probably%20that's%20on%20Microsoft%20site%2C%20they%20switched%20off%20the%20functionality%20for%20your%20tenant.%20Send%20a%20frown.%20What%20I%20see%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193515i6903743574B4DB1A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eon%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20409px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193516iD93EEFF1035FAADE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1408080%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1408080%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F236847%22%20target%3D%22_blank%22%3E%40Ed%20Hansberry%3C%2FA%3E%26nbsp%3B%2C%20so%20far%20nothing.%20I%20created%20couple%20of%20datasets%20with%20featured%20tables%20in%20them%2C%20checked%20that%20all%20settings%20in%20Power%20BI%20Admin%20center%20are%20correct%2C%20but%20nothing%20appeared%20in%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1409290%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1409290%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%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9480%22%20target%3D%22_blank%22%3E%40Brian%20Jones%20(OFFICE)%3C%2FA%3E%26nbsp%3B-%20any%20ideas%20when%20this%20will%20roll%20out%20to%20insiders%20at%20least%3F%20Very%20frustrating%20that%20there%20are%20new%20features%20in%20the%20Power%20BI%20service%20but%20we've%20got%20nothing%20to%20actually%20mess%20with.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2962888%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2962888%22%20slang%3D%22en-US%22%3E%3CP%3ETerima%20kasih%20banyak%2C%20dengan%20cara%20ini%20saya%20bisa%20membuat%20%3CA%20href%3D%22https%3A%2F%2Fwww.mapel.id%2Fcontoh-surat-lamaran-kerja%2Fumum%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Econtoh%20surat%20lamaran%20kerja%3C%2FA%3E%20dengan%20mudah%20sehingga%20saya%20abadikan%20pada%20artikel%20di%20blog%20saya%20%3CA%20title%3D%22mapel.id%22%20href%3D%22https%3A%2F%2Fwww.mapel.id%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Emapel.id%3C%2FA%3E%20yang%20sering%20membahas%20microsoft.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1414108%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1414108%22%20slang%3D%22en-US%22%3E%3CP%3EWhy%20make%20this%20dependant%20on%20having%20the%20E5%20SKU%2C%20which%20is%20mostly%20about%20security%20and%20telecoms%3F%20This%20feature%20of%20Excel%20should%20be%20available%20if%20you%20have%20a%20Power%20BI%20Pro%20license!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1414111%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1414111%22%20slang%3D%22en-US%22%3E%3CP%3EAbsolutely%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F244740%22%20target%3D%22_blank%22%3E%40Calum_L1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1627195%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1627195%22%20slang%3D%22en-US%22%3E%3CP%3E%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-%20The%20roadmap%20is%20referring%20to%20the%20timeframe%20for%20the%20original%20licensing%20plan%20as%20the%20feature%20is%20already%20in%20production%20for%20E5%20customers.%20We%20anticipate%20the%20update%20for%20E3%20should%20land%20in%20production%20within%20the%20calendar%20year.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1670942%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1670942%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20news%20about%20the%20licensing%20not%20being%20bolted%20to%20E5.%26nbsp%3B%20The%20requirement%20of%20a%20Power%20BI%20Pro%20license%20makes%20sense.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EQUESTION%3A%20Will%20this%20also%20work%20for%20users%20without%20a%20Pro%20license%20if%20the%20Power%20content%20is%20on%20Premium%20Capacity%3F%26nbsp%3B%20That%20would%20be%20consistent%20with%20the%20way%20the%20whole%20Power%20BI%20ecosystem%20works%2C%20so%20I%20hope%20the%20answer%20is%20%22yes%22.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2996596%22%20slang%3D%22en-US%22%3ERe%3A%20Simplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2996596%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20documentation%20available%20about%20how%20to%20set%20up%20proxy%20settings%20in%20order%20to%20see%20the%20datasets%20in%20Excel%3F%20Currently%20we%20get%20errors%20that%20tell%20us%20that%20we%20need%20to%20configure%20a%20proxy.%20Thanks%20for%20any%20hints!%20(We%20already%20set%20up%20.config%20files%20for%20Excel.exe%2C%20NetFX45%20an%20NETFX40%2C%20that%20did%20the%20job%20for%20some%20other%20Power%20BI%20related%20functions%20in%20Excel%20but%20not%20for%20the%20listing%20of%20datasets)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Aug 27 2020 10:11 AM
Updated by: