Report Portal

Working with Data Models Created Using SQL Server 2008 R2 Power Pivot for Office Excel 2010 in Power BI

Power BI supports Power Pivot data models of any version. Users can choose between SQL Server 2008 R2 and SQL Server 2012 Power Pivot for Excel 2010 or simply use the latest Power Pivot version directly integrated with Excel 2013. It goes without saying that the newest version includes more features than its predecessors, offers significant improvements to the user interface, and provides the best and most seamless user experience in Power BI. For these reasons, it is strongly recommended that Power BI user take advantage of the capabilities provided through Excel 2013 and upgrade their existing data models. Upgrading a data model is as easy as opening an existing workbook in Excel, then clicking Manage on the Power Pivot ribbon, and approving the upgrade notification. For step-by-step instructions, see Upgrade Power Pivot Data Models to Excel 2013 at


Tags: excel, tabular, refresh, powerbi


2007-2015 VidasSoft Systems Inc.