Applies ToExcel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

Removal of Power View from Excel in Microsoft 365 and Excel 2021

As previously announced, new feature development for Power View concluded in 2016 and shifted to Power BI Desktop, a free standalone download. Power BI Desktop offers a dedicated environment for visual data exploration and reporting, complementing the deep analytics users perform in Excel. 

While Power View remained in Excel for Windows, the Silverlight framework it requires is reaching end of support on October 12th, 2021.  As a result, we will remove Power View from Excel starting on October 12th, 2021. Note that as a Microsoft 365 update this will roll out gradually. For more information, see When do I get the newest features. In addition, Power View will not be included in the Excel 2021 perpetual release.

You can migrate your existing Power View solutions to Power BI Desktop. To do this, within Power BI Desktop, select File > Import >Power Query, Power Pivot, Power View, choose an Excel workbook from the dialog box, and then import the Power View components of your workbook into Power BI Desktop. For more information, see Import Excel workbooks into Power BI Desktop.

Note that other related features (i.e., Power Query, Power Pivot, 3D Maps) are not affected by this change and will continue to be supported. In addition, we will continue to invest and innovate in the charting space which provides powerful visualization directly in Excel. 

After this change, Excel will no longer render sheets containing Power View reports. Workbooks containing the reports will still open on Excel for Windows and other parts of the workbook will be accessible, including the underlying data in the Data Model Power View was using.  

How to Create New Reports

Many reporting needs can be fulfilled using Excel’s native charting experience. If you are looking for more options and interactivity, it is recommended that you use Excel + Power BI Desktop. These tools are deliberately designed to work together. Resources for leveraging the combined power of these tools are available here.  

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See More

Power BI Desktop support for importing Power View

Data Visualization with Excel and Power BI

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.