Browse by Tags

Tagged Content List

Wiki Page: Troubleshoot PowerPivot for SharePoint: Installation and Configuration

Craig Guyer - MSFT

This article consists of troubleshooting tips and techniques for working through installation and configuration problems for SQL Server 2008 R2 version of PowerPivot for SharePoint. Please update this page to include any new information or links that you think will be helpful to others. Click Sign...

on24 May 2013
Wiki Page: PowerPivot Licensing and Pricing

Fernando Lugão Veltem

This is a community article to provide up-to-date information about PowerPivot licenses and pricing. The common questions that this article addresses are the following: What is the PowerPivot price? What is the PowerPivot pricing? How much does PowerPivot cost? Where can I find information about...

on1 May 2013
Wiki Page: PowerPivot: DAX: Text Functions

Ed Price - MSFT

Data Analysis Expressions (DAX) includes a set of text functions that is based on the library of string functions in Excel, but it has been modified to work with tables and columns. Read more about the following text functions: BLANK CONCATENATE EXACT FIND FIXED FORMAT LEFT...

on20 Apr 2013
Wiki Page: PowerPivot Help

Ed Price - MSFT

Looking for PowerPivot Help? Click below to find answers about PowerPivot: PowerPivot for Excel 2013 on Office Support: What's New Start It About PowerPivot Tutorial PowerPivot for Excel Help on TechNet Library: SQL Server 2012 SQL Server 2008 R2 PowerPivot...

on20 Apr 2013
Wiki Page: Hosting a WCF Data Service, with Basic Authentication for PowerPivot Clients

Richard Mueller

Introduction This walkthrough demonstrates how to host a WCF Data Service in an ASP.NET web site in a way which allows PowerPivot to connect to the service using basic authentication. Some relevant areas have already been covered in a lot of detail elsewhere on MSDN or in blogs. When this is the...

on19 Apr 2013
Wiki Page: SharePoint 2010: PowerPivot Gallery Thumbnails/Snapshots Not Rendering (Red "X", Hourglass, and Lock)

Ed Price - MSFT

Here are some quick steps to hopefully resolve the below error: Snapshot will not work if you have chosen to open the workbooks in the Client application. Please refer to the below document on how to turn these features off: Configure the default open behavior for browser-enabled...

on16 Apr 2013
Wiki Page: Tutorial: Optimize a Sample PowerPivot Model for Power View Reports (SQL Server 2012 Release Candidate 0)

Ed Price - MSFT

Important: This version of this tutorial was last updated for SQL Server 2012 Release Candidate 0. For the most up-to-date version of this tutorial, see: Tutorial: Optimize a Sample PowerPivot Model for Power View Reports See Also Power View (SSRS) Tutorial: Create...

on2 Mar 2013
Wiki Page: PowerPivot: DAX: Operator Reference

Richard Mueller

The Data Analysis Expressions (DAX) language uses operators to create expressions that compare values, perform arithmetic calculations, or work with strings. Original article (before wiki edits) was written by Jeannine Takaki , Microsoft SQL Server Analysis Services Technical Writer. ...

on28 Feb 2013
Wiki Page: How to Connect Excel PowerPivot to Hive on Azure via HiveODBC

Richard Mueller

The Hive ODBC Driver enables client applications such as Excel PowerPivot to access a Hive data warehouse running on Windows Azure. This driver requires the ODBC Server Port to be opened on the Hadoop Services on Azure ( http://www.hadooponazure.com ) portal. This walkthrough provides the following...

on22 Feb 2013
Wiki Page: PowerPivot: DAX: Filter Functions

Ed Price - MSFT

The filter and value functions in Data Analysis Expressions (DAX) are some of the most complex and powerful, and differ greatly from Excel functions. The lookup functions work by using tables and relationships, like a database. The filtering functions let you manipulate data context to create dynamic...

on20 Feb 2013
Wiki Page: PowerPivot: DAX: Logical Functions

Gavin Campbell

Logical Data Analysis Expressions (DAX) functions act upon an expression to return information about the values or sets in the expression. For example, you can use the IF function to check the result of an expression and create conditional results. Read more about the following logical functions...

on20 Feb 2013
Wiki Page: Microsoft PowerPivot for SQL Server 2012 Release Notes

Ed Price - MSFT

Click here to change the language. The Microsoft PowerPivot for SQL Server 2012 Release Notes have moved to MSDN . © 2012 Microsoft Corporation. All rights reserved.

on15 Feb 2013
Wiki Page: SQL Server Code-Named "Denali" CTP1 Release Notes

Ed Price - MSFT

This page is carefully and closely monitored. Any changes you make will be evaluated and then quickly accepted, refined, or reverted. Because this is a wiki, additions or refinements to these release notes might have been made by community members. To read the original release notes document, click here...

on15 Feb 2013
Wiki Page: Notas de la versión de Microsoft PowerPivot para SQL Server 2012 (es-ES)

Ed Price - MSFT

Esta página se supervisa muy estrechamente. Los cambios que realice se evaluarán y se aceptarán, refinarán o revertirán rápidamente. Dado que se trata de un sitio wiki, las adiciones o mejoras de estas notas de la versión podrían haber sido efectuadas...

on15 Feb 2013
Wiki Page: QuickStart: Learn DAX Basics in 30 Minutes

Ed Price - MSFT

By: Owen Duncan, MSFT This QuickStart is for users new to PowerPivot or tabular model projects authored in SQL Server Data Tools. It is meant to give you a quick and easy introduction on how you can use Data Analysis Expressions (DAX) to solve a number of basic data modeling and analytical problems...

on10 Jan 2013
Wiki Page: SSRS 2008 R2 Atom Data Feeds for PowerPivot

TK MAHATO

This article focuses on a new feature of SQL Server Reporting Services 2008 R2: enabling data feeds to be exported from a report and consumed in the new SQL 2008 R2 PowerPivot client. With the release of SSRS 2008 R2, we now have a new rendering extension to render Atom data feeds from SSRS reports...

on24 Dec 2012
Wiki Page: Install PowerPivot for SharePoint on a Domain Controller

TK MAHATO

This is a 4-part PowerPivot video series: How to install a system and get it up and running in a standalone demo system environment. All four videos are on this page. Table of Contents Part 1: Installing a Domain Controller and PowerPivot Part 2: Creating User Accounts Part 3: Installing the SharePoint...

on24 Dec 2012
Wiki Page: PowerPivot Survival Guide

Bjoern H Rapp

This is a list of external (non-wiki) resources for PowerPivot . To add to or rearrange the list, just click the Edit tab on the top of this page. In this article, you can find links in the following categories: Overviews Adding and Maintaining Data -- includes importing data and refreshing...

on25 Nov 2012
Wiki Page: PowerPivot data model error - "This PivotTable was created in a later version of Excel and can't be updated in this version."

Heidi Steen - SQLUE

If you're a data analyst using PowerPivot to create data models in Excel, you might run into the following error if you share workbooks with colleagues who are using earlier versions of Excel. In its entirety, the error reads as: "This PivotTable was created in a later version of Excel...

on6 Nov 2012
Wiki Page: PowerPivot Version Compatibility

Nathaniel Scharer [MSFT]

If you use (or want to start using) PowerPivot to analyze data and present it to others, this topic will help you understand the compatibility between different releases of these products and the differences in capabilities. I’ll walk you through the most common upgrade/compatibility scenarios and...

on29 Oct 2012
Wiki Page: Business Intelligence

Ed Price - MSFT

Microsoft business intelligence (BI) expands the reach of your investments in the Microsoft productivity platform, data infrastructure, and collaboration tools you already own. Our solution delivers business intelligence by integrating the strengths of these products on a single platform to empower informed...

on8 Oct 2012
Wiki Page: Overview of Tools to Use with Windows Azure SQL Database

air ambulance flight coordinator

This article provides an overview of the current tools produced by Microsoft that support Windows Azure SQL Database. For more information, see Tools and Utilities Support (Windows Azure SQL Database) . Note If you wish to contribute to this page, use the Edit tab at the top ...

on3 Oct 2012
Wiki Page: PowerPivot for SharePoint Architecture

Ed Price - MSFT

This article is a video tour of the architecture you'll work with when using PowerPivot for SharePoint. There are four videos in this series, and you can watch them all on this page. This series is presented by Lee Graber , Senior Software Developer, Microsoft SQL Server Analysis Services. The...

on20 Sep 2012
Wiki Page: Calendar Analytics for Office 15

dplotnikov - mvp

This Wiki article is intended to document new features for Calendar Analytics 2.0 This version is intended to fix bugs and add support for Office 15. Please add comments with any suggestions you may have. As a reminder, you can download Calendar Analytics 1.0 here .

on3 Sep 2012
Wiki Page: PowerPivot Error: "You are attempting to access PowerPivot data that was added using a newer version of PowerPivot"

Ed Price - MSFT

The Report which you are using is built on new power pivot version, for this reason reports are not working on old power pivot version and showing below error message. The Report which you are using is built on new PowerPivot version; for this reason reports are not working on old power pivot...

on15 Aug 2012