Browse by Tags

Tagged Content List
  • Wiki Page: Troubleshoot PowerPivot for SharePoint: Installation and Configuration

    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...
  • Wiki Page: PowerPivot Licensing and Pricing

    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...
  • Wiki Page: PowerPivot: DAX: Text Functions

    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...
  • Wiki Page: PowerPivot Help

    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...
  • Wiki Page: Hosting a WCF Data Service, with Basic Authentication for PowerPivot Clients

    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...
  • Wiki Page: SharePoint 2010: PowerPivot Gallery Thumbnails/Snapshots Not Rendering (Red "X", Hourglass, and Lock)

    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...
  • Wiki Page: Tutorial: Optimize a Sample PowerPivot Model for Power View Reports (SQL Server 2012 Release Candidate 0)

    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...
  • Wiki Page: PowerPivot: DAX: Operator Reference

    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. ...
  • Wiki Page: How to Connect Excel PowerPivot to Hive on Azure via HiveODBC

    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...
  • Wiki Page: PowerPivot: DAX: Filter Functions

    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...
  • Wiki Page: PowerPivot: DAX: Logical Functions

    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...
  • Wiki Page: Microsoft PowerPivot for SQL Server 2012 Release Notes

    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.
  • Wiki Page: SQL Server Code-Named "Denali" CTP1 Release Notes

    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...
  • Wiki Page: Notas de la versión de Microsoft PowerPivot para SQL Server 2012 (es-ES)

    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...
  • Wiki Page: QuickStart: Learn DAX Basics in 30 Minutes

    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...
  • Wiki Page: SSRS 2008 R2 Atom Data Feeds for PowerPivot

    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...
  • Wiki Page: Install PowerPivot for SharePoint on a Domain Controller

    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...
  • Wiki Page: PowerPivot Survival Guide

    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...
  • Wiki Page: PowerPivot data model error - "This PivotTable was created in a later version of Excel and can't be updated in this version."

    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...
  • Wiki Page: PowerPivot Version Compatibility

    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...
  • Wiki Page: Business Intelligence

    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...
  • Wiki Page: Overview of Tools to Use with Windows Azure SQL Database

    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 ...
  • Wiki Page: PowerPivot for SharePoint Architecture

    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...
  • Wiki Page: Calendar Analytics for Office 15

    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 .
  • Wiki Page: PowerPivot Error: "You are attempting to access PowerPivot data that was added using a newer version of PowerPivot"

    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...
Page 2 of 4 (91 items) 1234
Can't find it? Write it!