{"id":4183,"date":"2011-09-28T12:49:00","date_gmt":"2011-09-28T19:49:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/"},"modified":"2024-01-22T22:49:57","modified_gmt":"2024-01-23T06:49:57","slug":"whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/","title":{"rendered":"What\u2019s new in PowerPivot for Excel with SQL Server Code Name &#8220;Denali&#8221; CTP3"},"content":{"rendered":"<p><span style=\"font-family:'Segoe UI';font-size:small;\"> <br \/>In Microsoft SQL Server 2008 R2 we introduced PowerPivot: A self-service Business Intelligence experience that enables information workers to create their own self-service BI solutions and facilitating sharing and collaboration within the familiar environment of Excel and SharePoint. With the release of Microsoft SQL Server code-named \u201cDenali\u201d we bring the simplicity and power of the PowerPivot technologies to corporate BI, greatly expanding the reach of the Microsoft BI semantic model. <\/p>\n<p>As of CTP3 of Denali we are delivering a wealth of new modeling features to the Microsoft BI semantic model, which will surface in both in PowerPivot and the Tabular Project type within the BI Development Studio. <\/p>\n<p>The video below gives you a brief overview of 3 key features that we have introduced with the CTP3: The new Diagram View, user defined hierarchies and perspectives. <br \/><\/span><\/p>\n<ul>\n<li><span style=\"font-size:small;\"><span style=\"font-family:'Segoe UI';\"><b>Diagram View: <\/b>The Diagram View is &#8211; as the name suggests &#8211; a diagrammatic view of the model. IN addition to enabling you to view tables in a visually organized way and to easily add and change relationships and hierarchies it\u2019s important to note that the diagram is a fully-fledged designer, which allows for greater interactivity and navigation across the entire model<\/span><\/span><\/li>\n<li><span style=\"font-size:small;\"><span style=\"font-family:'Segoe UI';\"><b>Hierarchies<\/b>: The ability to create user defined hierarchies will enable the person building the model to design more intuitive navigation patters for the users consuming of the model.<\/span><\/span><\/li>\n<li>\n<span style=\"font-size:small;\"><span style=\"font-size:small;\"><span style=\"font-family:'Segoe UI';\"><b>Perspectives: <\/b>With the introduction of Perspectives, the user creating the model can easily define different subsets of the model providing a more simplified view for the end user. Perspectives are typically defined for particular user groups or business scenario and make it easier to navigate large data sets. <\/p>\n<p><\/span><\/span><\/span>  <\/p>\n<div style=\"margin:0px;display:inline;float:none;padding:0px;\" id=\"scid:5737277B-5D6D-4f48-ABFC-DD9C333F4C5D:8534e9ea-78e2-4115-80be-66b0d89ba836\" class=\"wlWriterEditableSmartContent\">\n<div id=\"22ca98ec-c0bd-40fb-a957-0066a2422dc6\" style=\"margin:0px;padding:0px;display:inline;\">\n<div><object width=\"471\" height=\"264\"><param name=\"movie\" value=\"https:\/\/www.youtube.com\/v\/rgpmcj0GuTY?hl=en&amp;hd=1\"><embed src=\"https:\/\/www.youtube.com\/v\/rgpmcj0GuTY?hl=en&amp;hd=1\" type=\"application\/x-shockwave-flash\" width=\"471\" height=\"264\"><\/embed><\/object><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/li>\n<\/ul>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\">In addition to the 3 features discussed above you will find a significant number of other new features to explore if you go download the CTP3 of PowerPivot for Excel. Other features include: <\/p>\n<p><\/span><\/p>\n<ul>\n<li><span style=\"font-family:'Segoe UI';font-size:small;\"><b>Support for Multiple Relationships<\/b>: In PowerPivot V1 only one relationship would be allowed to exist between a give set of tables. In CTP3 we have added the ability to import &#8211; and later create &#8211; multiple relationships between tables. Only one relationship will be active but inactive relationships can be used when defining measures which will allow for full usage of all relationships.<\/span><\/li>\n<li><span style=\"font-family:'Segoe UI';font-size:small;\"><b>Calculation Area<\/b>: With the introduction of the Calculation Area we are bringing measure authoring into the PowerPivot modeling window. The Calculation Area is a free form data grid located at the bottom of each table enabling the user to easily create view, create, edit, and manage measures and Key Performance Indicators (KPIs) in context of the data within each table. <\/span><\/li>\n<li><span style=\"font-family:'Segoe UI';font-size:small;\"><b>Advanced Tab<\/b>: An advanced tab has been added, making all advanced features available in a separate ribbon tab. The features include the ability to create or edit perspectives, summarize a numeric column by an aggregation function, and set reporting properties. The advanced tab is not enabled by default, but can be enabled on a per user basis from the File button within the PowerPivot window. <\/span><\/li>\n<li><span style=\"font-family:'Segoe UI';font-size:small;\"><b>Reporting Properties<\/b>: In the Reporting Properties area of the advanced tab the modeler can set various properties reporting allowing the modeler to drive an optimized default experience for client tools, such as Project Crescent. <\/span><\/li>\n<li><span style=\"font-family:'Segoe UI';font-size:small;\"><b>New DAX Functions<\/b>: A variety of new DAX functions have been added such as USERELATIONSHIP, DISTINCTCOUNT and TOPN just to mention a few. <\/span><\/li>\n<li><span style=\"font-family:'Segoe UI';font-size:small;\"><b>Sort by Other Column<\/b>: Sort by Other Column will allow for sorting one column by anther column within the same table. As an example the month name column can be sorted by the moth number column, which will essentially assign each month its number in order to sort the column in a natural way when the month field is added to a report or PivotTable.<\/span><\/li>\n<li><span style=\"font-family:'Segoe UI';font-size:small;\"><b>Add Values to Rows and Columns<\/b>: As of CTP3 the user can add values to rows and columns, which was functionality that could previously only be achieved using the Excel Field List.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\">Other features delivered with previous CTPs include: KPI\u2019s, ability to mark a table as a date table, multiple DAX functions, change of data type for calculated columns, persistence of measure formatting, descriptions, alphabetical display of fields in the Field List.<\/span><\/p>\n<p><span style=\"font-family:'Segoe UI';font-size:small;\">Download SQL Server Code Name \u201cDenali\u201d CTP3 from: <a href=\"http:\/\/www.microsoft.com\/denaliDownload\">www.microsoft.com\/denali<\/a><span style=\"font-family:'Segoe UI';font-size:small;\"> <br \/><span style=\"color:#000000;\">Download<\/span><\/span> SQL Server &#8220;Denali&#8221; PowerPivot for Excel at: <\/span><a href=\"http:\/\/www.microsoft.com\/download\/en\/details.aspx?id=26721\"><span style=\"font-family:'Segoe UI';font-size:small;\">http:\/\/www.microsoft.com\/download\/en\/details.aspx?id=26721<\/span><\/a> <br \/><span style=\"font-family:'Segoe UI';font-size:small;\"> <br \/>Enjoy your modeling using CTP3! <\/p>\n<p>Julie Strauss <br \/>Senior Program Manager <br \/>Analysis Services Team <br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Microsoft SQL Server 2008 R2 we introduced PowerPivot: A self-service Business Intelligence experience that enables information workers to create their own self-service BI solutions and facilitating sharing and collaboration within the familiar environment of Excel and SharePoint.<\/p>\n","protected":false},"author":1457,"featured_media":49934,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-4183","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","content-type-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What\u2019s new in PowerPivot for Excel with SQL Server Code Name &quot;Denali&quot; CTP3 - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What\u2019s new in PowerPivot for Excel with SQL Server Code Name &quot;Denali&quot; CTP3 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"In Microsoft SQL Server 2008 R2 we introduced PowerPivot: A self-service Business Intelligence experience that enables information workers to create their own self-service BI solutions and facilitating sharing and collaboration within the familiar environment of Excel and SharePoint.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2011-09-28T19:49:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/whats-new-in-powerpivot-for-exce.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"What\u2019s new in PowerPivot for Excel with SQL Server Code Name &#8220;Denali&#8221; CTP3\",\"datePublished\":\"2011-09-28T19:49:00+00:00\",\"dateModified\":\"2024-01-23T06:49:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/\"},\"wordCount\":743,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/whats-new-in-powerpivot-for-exce.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/\",\"name\":\"What\u2019s new in PowerPivot for Excel with SQL Server Code Name \\\"Denali\\\" CTP3 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/whats-new-in-powerpivot-for-exce.jpg\",\"datePublished\":\"2011-09-28T19:49:00+00:00\",\"dateModified\":\"2024-01-23T06:49:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/whats-new-in-powerpivot-for-exce.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/whats-new-in-powerpivot-for-exce.jpg\",\"width\":1280,\"height\":720,\"caption\":\"What\u2019s new in PowerPivot for Excel with SQL Server Code Name &#8220;Denali&#8221; CTP3\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What\u2019s new in PowerPivot for Excel with SQL Server Code Name &#8220;Denali&#8221; CTP3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What\u2019s new in PowerPivot for Excel with SQL Server Code Name \"Denali\" CTP3 - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/","og_locale":"en_US","og_type":"article","og_title":"What\u2019s new in PowerPivot for Excel with SQL Server Code Name \"Denali\" CTP3 - Microsoft SQL Server Blog","og_description":"In Microsoft SQL Server 2008 R2 we introduced PowerPivot: A self-service Business Intelligence experience that enables information workers to create their own self-service BI solutions and facilitating sharing and collaboration within the familiar environment of Excel and SharePoint.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2011-09-28T19:49:00+00:00","article_modified_time":"2024-01-23T06:49:57+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/whats-new-in-powerpivot-for-exce.jpg","type":"image\/jpeg"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"What\u2019s new in PowerPivot for Excel with SQL Server Code Name &#8220;Denali&#8221; CTP3","datePublished":"2011-09-28T19:49:00+00:00","dateModified":"2024-01-23T06:49:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/"},"wordCount":743,"commentCount":3,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/whats-new-in-powerpivot-for-exce.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/","name":"What\u2019s new in PowerPivot for Excel with SQL Server Code Name \"Denali\" CTP3 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/whats-new-in-powerpivot-for-exce.jpg","datePublished":"2011-09-28T19:49:00+00:00","dateModified":"2024-01-23T06:49:57+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/whats-new-in-powerpivot-for-exce.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/whats-new-in-powerpivot-for-exce.jpg","width":1280,"height":720,"caption":"What\u2019s new in PowerPivot for Excel with SQL Server Code Name &#8220;Denali&#8221; CTP3"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/28\/whats-new-in-powerpivot-for-excel-with-sql-server-code-name-denali-ctp3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"What\u2019s new in PowerPivot for Excel with SQL Server Code Name &#8220;Denali&#8221; CTP3"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=4183"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4183\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/49934"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=4183"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=4183"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=4183"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=4183"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=4183"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=4183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}