Skip to main content
|

PowerPivotPro's FAQ Site

Go Search
  
PowerPivotPro's FAQ Site > The Great PowerPivot FAQ  

The Great PowerPivot FAQ

Modify settings and columns
The Great PowerPivot FAQ
  
View: 
Expand/Collapse Topic : A - Getting Started ‎(10)
Where do I get PowerPivot Beta?Use SHIFT+ENTER to open the menu (new window).
BothA - Getting StartedInformationYesRob Collie
What is the planned release date for PowerPivot?Use SHIFT+ENTER to open the menu (new window).
BothA - Getting StartedInformationYesRob Collie
Do I need SharePoint 2010 to use the PowerPivot?Use SHIFT+ENTER to open the menu (new window).
ClientA - Getting StartedInformationYesThiago Zavaschi
Is PowerPivot a replacement for Analysis Services (SSAS)?Use SHIFT+ENTER to open the menu (new window).
ServerA - Getting StartedInformationYesMarco Russo
What are the top 5 Reasons Why Your Company Should Embrace PowerPivot Over Competing SSBI ProductsUse SHIFT+ENTER to open the menu (new window).
BothA - Getting StartedInformationYesDerek Comingore
Do I need SQL Server 2008 R2 to use PowerPivot for Excel?Use SHIFT+ENTER to open the menu (new window).
ClientA - Getting StartedInformationYesThiago Zavaschi
Where can I get the PowerPivot for Excel Help file?Use SHIFT+ENTER to open the menu (new window).
ClientA - Getting StartedInformationYesMichele Hart
10 things you should know when you use PowerPivotUse SHIFT+ENTER to open the menu (new window).
ClientA - Getting StartedInformationYesKasper de Jonge
PowerPivot CTP3 is expiredUse SHIFT+ENTER to open the menu (new window).
ClientA - Getting StartedInformationYesKasper de Jonge
Are there any good PowerPivot books?Use SHIFT+ENTER to open the menu (new window).
ClientA - Getting StartedInformationYesRob Collie
Expand/Collapse Topic : B - Setup ‎(10)
What version of Office is required to run PowerPivot?Use SHIFT+ENTER to open the menu (new window).
BothB - SetupInformationYesRob Collie
Do I have to install 64-bit addin if I am running 64-bit Office, and vice versa?Use SHIFT+ENTER to open the menu (new window).
ClientB - SetupInformationYesRob Collie
My PowerPivot ribbon does not show up after a successful add-in install. How can I fix that?Use SHIFT+ENTER to open the menu (new window).
ClientB - SetupTroubleshootingYesMichele Hart
Server deployment models - departmental vs. enterprise?Use SHIFT+ENTER to open the menu (new window).
ServerB - SetupInformationYesDenny Lee
Is there going to be a version compatible with prior versions of Excel?Use SHIFT+ENTER to open the menu (new window).
ClientB - SetupInformationYesRob Collie
Can Office 2010 be installed side-by side with older versions of Office?Use SHIFT+ENTER to open the menu (new window).
ClientB - SetupInformationYesRob Collie
How can I use PowerPivot with my Mac?Use SHIFT+ENTER to open the menu (new window).
ClientB - SetupInformationYesRussell Christopher
Can I Disable and Enable the SQL Server PowerPivot for Excel Add-In?Use SHIFT+ENTER to open the menu (new window).
ClientB - SetupInformationYesDerek Comingore
I am one of the lucky people already testing Office 2010 RC. Can I use PowerPivot CTP3?Use SHIFT+ENTER to open the menu (new window).
ClientB - SetupInformationYesWesley Backelant
What is the OLEDB provider for PowerPivot and where is it installed?Use SHIFT+ENTER to open the menu (new window).
BothB - SetupInformationYesRob Collie
Expand/Collapse Topic : C - Open/Save ‎(8)
The PowerPivot embedded db has become corrupted after save, re-open. Is there a workaround?Use SHIFT+ENTER to open the menu (new window).
ClientC - Open/SaveTroubleshootingYesRob Collie
What is the limit on PowerPivot file size?Use SHIFT+ENTER to open the menu (new window).
ClientC - Open/SaveInformationYesRob Collie
How much file compression does PowerPivot get?Use SHIFT+ENTER to open the menu (new window).
ClientC - Open/SaveInformationYesRob Collie
Where is the data stored that PowerPivot for Excel collects and uses?Use SHIFT+ENTER to open the menu (new window).
ClientC - Open/SaveInformationYesDerek Comingore
Troubleshoot error "The data connection uses windows authentication and user credentials could not be delegated"Use SHIFT+ENTER to open the menu (new window).
ServerC - Open/SaveTroubleshootingYesVandana Ponnuru
Save your workbooks at cell A1Use SHIFT+ENTER to open the menu (new window).
ClientC - Open/SaveBothYesDave Wickert
Why doesn't my PowerPivot workbook open anymore? There is no error, but the Excel Splash screen says "Opening In Protected View"Use SHIFT+ENTER to open the menu (new window).
ClientC - Open/SaveInformationYesRussell Christopher
Where does PowerPivot store its temp files?Use SHIFT+ENTER to open the menu (new window).
ClientC - Open/SaveInformationYesRob Collie
Expand/Collapse Topic : D - General UX ‎(15)
Does my filter in the PowerPivot window apply thru to my pivots?Use SHIFT+ENTER to open the menu (new window).
ClientD - General UXInformationYesRob Collie
Why I see a PivotTable Field List instead of a PowerPivot Task PaneUse SHIFT+ENTER to open the menu (new window).
ClientD - General UXTroubleshootingYesMarco Russo
Can I rearrange the PowerPivot Field List?Use SHIFT+ENTER to open the menu (new window).
ClientD - General UXInformationYesBill Jelen
Is there a shortcut key to jump to the PowerPivot window?Use SHIFT+ENTER to open the menu (new window).
ClientD - General UXInformationYesBill Jelen
After accessing the Field Settings dialog, I can not use the arrow keys to move around the worksheet?Use SHIFT+ENTER to open the menu (new window).
ClientD - General UXTroubleshootingYesBill Jelen
Can I print from the PowerPivot window?Use SHIFT+ENTER to open the menu (new window).
ClientD - General UXInformationYesBill Jelen
Why does Increase Decimal icon do the opposite?Use SHIFT+ENTER to open the menu (new window).
ClientD - General UXTroubleshootingYesBill Jelen
Is there a "clear all" button/command in the PowerPivot Window?Use SHIFT+ENTER to open the menu (new window).
ClientD - General UXInformationYesDerek Comingore
Are there multiple PowerPivot windows (workspaces) in a single Excel 2010 file?Use SHIFT+ENTER to open the menu (new window).
ClientD - General UXInformationYesDerek Comingore
I'd like to use PowerPivot as a "poor-man's" cube substitute. Is there a way to restrict measures exposed to users so that only company approved (and single version of the truth) measures are available?Use SHIFT+ENTER to open the menu (new window).
ClientD - General UXInformationYesColin Banfield
How to hide the columns you don't use from the pivottableUse SHIFT+ENTER to open the menu (new window).
ClientD - General UXInformationYesKasper de Jonge
The measures I have imported from an Analysis Services cube are not being treated as a number?Use SHIFT+ENTER to open the menu (new window).
ClientD - General UXTroubleshootingYesWesley Backelant
Can I add a chart to my existing Pivottable?Use SHIFT+ENTER to open the menu (new window).
ClientD - General UXInformationYesKasper de Jonge
Can i do datamining with PowerPivot data?Use SHIFT+ENTER to open the menu (new window).
ClientD - General UXInformationYesKasper de Jonge
How to use sparklines and PowerPivot dataUse SHIFT+ENTER to open the menu (new window).
ClientD - General UXInformationYesKasper de Jonge
Expand/Collapse Topic : E - Importing Data ‎(19)
Can I import data from other BI tools into PowerPivot?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesMarco Russo
Can I use SharePoint lists as a data source?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesRob Collie
Can I use Sql Server Reporting Services reports as data sources?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesRob Collie
Can I use the SSRS data model itself as a data source directly?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesRob Collie
Why can't I import data from Analysis Services 2000?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesDave Wickert
Reusing a dataconnection with multiple imports in PowerPivotUse SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesKasper de Jonge
Can I import data from the same Excel Spreadsheet that I build a PowerPivot model within?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesDerek Comingore
Where can I find sample data for testing/demonstrating PowerPivot?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesVidas Matelis
How can I import data from Madison or an ERP system? Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesDenny Lee
What's with the 2GB Limit for PowerPivot?Use SHIFT+ENTER to open the menu (new window).
BothE - Importing DataInformationYesDenny Lee
How can I import public data made available via the Internet?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesDerek Comingore
How can I optimize resulting Excel file size and memory used for data import?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesMarco Russo
I get "The size specified for a binding was too small" error on import.Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataTroubleshootingYesRob Collie
What's the best way to import SAP BW Data?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesDenny Lee
Im getting an error: "Customized cultures cannot be passed by LCID, only by name."Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataTroubleshootingNoFelipe Ferreira
PowerPivot doesn't include a comprehensive visual query tool for importing data. Is there one you can recommend?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesColin Banfield
What is an ATOM feed?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesWesley Backelant
My filename is too long to import in PowerPivotUse SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesKasper de Jonge
How many rows can PowerPivot handle?Use SHIFT+ENTER to open the menu (new window).
ClientE - Importing DataInformationYesRob Collie
Expand/Collapse Topic : F - Calculations (DAX) ‎(38)
What is DAX?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesRob Collie
Is the table name required in DAX if I am writing a formula in that same table?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)BothYesRob Collie
The Time intelligence functions does not return resultsUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)TroubleshootingYesKasper de Jonge
How can I calculate a DISTINCT COUNT measure?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesMarco Russo
How to calculate Standard Deviation in PowerPivot?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesRob Collie
How to handle parent-child hierarchies with DAX?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)BothYesKaren Aleksanyan
How to slice data with many-to-many relationship?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)BothYesKaren Aleksanyan
Introduction to DAX time intelligent functions in PowerPivotUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesKasper de Jonge
Does DAX support the Excel TEXT function?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesBill Jelen
Converting dates to day of weekUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesBill Jelen
Can I calculate a field in Table1 times a field in Table2?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesBill Jelen
DAX Measure to Calculate % of Total Sales?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesBill Jelen
DAX Measure to calculate % of today's sales?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesBill Jelen
DAX Measure to calculate MTD Sales For This RegionUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesBill Jelen
Get the sum of values of the last month having data using LASTNONBLANKUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesKasper de Jonge
How can I do ABC Analysis (Pareto) with PowerPivot?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesMarco Russo
How do I create a running total that spans over multiple years and months?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesColin Banfield
How do I group numbers in a PowerPivot PivotTable like I can in an Excel PivotTable?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesColin Banfield
I have a date field in my sales table. How can I use the field to group by fiscal year and quarter in my PivotTable? Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesColin Banfield
How can I create a moving average calculated measure?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesColin Banfield
How do I deal with semi-additive measures using DAX?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesRussell Christopher
I have sequential data in my table but no date or partial date field. Is there an equivalent to some of the Time Intelligence functions to allow me to create appropriate measures?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesColin Banfield
In my DAX measure, aggregations over some related tables are acting upon the ENTIRE table, unfiltered by Pivot context. Why?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesRob Collie
I have a measure called SalesAmount. Can I use "Sum of SalesAmount" in a calculated measure? Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesColin Banfield
Is there a way to create a new calculated measure without having to switch bewteen the PivotTable Tools tabs and the PowerPivot tab?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesColin Banfield
How can I create an arbitrary time period for use with the Time Intelligence functions?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesColin Banfield
How do I create a Rank calculated measure?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesColin Banfield
Time intelligent PowerPivot functions and fiscal yearUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesKasper de Jonge
How can I calculate difference in days, hours, minutes and seconds between two datesUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesVidas Matelis
My time intelligent function doesn't filter, show data on rows or always show the total sumUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesKasper de Jonge
Is there a recommended text editor for creating and editing formulas? I create complex measures that are difficult to read and troubleshoot.Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)BothYesColin Banfield
How to add a related time table with Excel for time intel. functionsUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesKasper de Jonge
Using the NOW() Function gives a old datetime valueUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesKasper de Jonge
So i added a measure in my Pivottable,is this is a client side calculation?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesKasper de Jonge
What does the "Formula is invalid" error mean when adding a PowerPivot measure?Use SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)TroubleshootingYesRob Collie
Get the YTD of same period last year using DAXUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesKasper de Jonge
Simple use of the "Earlier" DAX FunctionUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)InformationYesRob Collie
Shopping Basket AnalysisUse SHIFT+ENTER to open the menu (new window).
ClientF - Calculations (DAX)TroubleshootingNoDave Boylan
Expand/Collapse Topic : G - Relationships ‎(5)
Can I have multiple relationships between two tables?Use SHIFT+ENTER to open the menu (new window).
ClientG - RelationshipsInformationYesRob Collie
Are multi-column relationships supported?Use SHIFT+ENTER to open the menu (new window).
ClientG - RelationshipsInformationYesRob Collie
Are many-to-many relationships supported?Use SHIFT+ENTER to open the menu (new window).
ClientG - RelationshipsInformationYesMarco Russo
Does renaming a table in the PowerPivot window break existing relationships?Use SHIFT+ENTER to open the menu (new window).
ClientG - RelationshipsInformationYesDerek Comingore
How to disable automatic relationship detectionUse SHIFT+ENTER to open the menu (new window).
ClientG - RelationshipsInformationYesKasper de Jonge
Expand/Collapse Topic : H - Pivot Tables ‎(21)
Is drillthru supported?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesRob Collie
When I add a field to the Values area of my pivot, I get a blank pivot. What's going on?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesTroubleshootingYesRob Collie
In my pivots, the Group button is disabled. Why?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesTroubleshootingYesRob Collie
Name 5 things I can do with PowerPivot that I can't do with Excel PivotTables alone.Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesRob Collie
The multi-pivot reports are cool, but can I modify them? Ex: Remove some pivots from slicer filtering? Or use two PivotTables, which is not an offered option?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesRob Collie
How can I arrange two or more measures in the Values area?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesBill Jelen
Will my row/column fields sort into Custom List sequence?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesTroubleshootingYesBill Jelen
My measures always SUM. Why can't I choose Average, Min, Max...Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesBill Jelen
Why is Calculated Field greyed out?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesBill Jelen
I hate the name "Sum of Sales". Can I change it?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesBill Jelen
How can I get rid of "Row Labels" label in the pivot table?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesBill Jelen
I hate the Compact Layout. Can I default to something else?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesBill Jelen
Why is Show Report Filter Pages greyed out?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesBill Jelen
How do I permanently change the numeric format in my pivot table?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesBill Jelen
Are PivotTables and PivotCharts the only type of report I can build? What are "Cube Formulas?"Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesRob Collie
How can I change my summarization from the default Sum to Average, Count etc.? The Summarize Value By option on the Ribbon is disabled.Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesColin Banfield
How can I automatically sort my Month or YearMonth field chronologically in a PowerPivot PivotTable? Excel always sorts fields placed in the Row and Column areas alphabetically.Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesColin Banfield
How can I create a field hierarchy that I can drag to the PivotTable?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesColin Banfield
Can I have more than 1 filter per field in a pivot?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesInformationYesRob Collie
What does the "Element not found" error mean in a PowerPivot pivottable?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesTroubleshootingYesRob Collie
What does the "Command was canceled" error mean in a PowerPivot pivottable?Use SHIFT+ENTER to open the menu (new window).
ClientH - Pivot TablesTroubleshootingYesRob Collie
Expand/Collapse Topic : I - Publishing on SharePoint ‎(9)
I can't upload PowerPivot files from Excel to SharePoint. I am getting an error.Use SHIFT+ENTER to open the menu (new window).
ClientI - Publishing on SharePointTroubleshootingYesDenny Lee
How to upload a PowerPivot App to SharePoint in CTPUse SHIFT+ENTER to open the menu (new window).
ClientI - Publishing on SharePointInformationYesDave Wickert
Why does Excel Services tell me there were unsupported features in my workbook?Use SHIFT+ENTER to open the menu (new window).
ServerI - Publishing on SharePointBothYesLee Graber
How to make your PowerPivot sheet look greatUse SHIFT+ENTER to open the menu (new window).
ClientI - Publishing on SharePointInformationYesKasper de Jonge
When I look at the PowerPivot Management Dashboard Query Response Times chart, what does Trivial, Quick, ..., Exceeded mean?Use SHIFT+ENTER to open the menu (new window).
ServerI - Publishing on SharePointInformationYesDenny Lee
How do I keep a workbook ‘pinned’ in memoryUse SHIFT+ENTER to open the menu (new window).
ServerI - Publishing on SharePointInformationYesDave Wickert
Can i protect my PowerPivot sheet to "view only"Use SHIFT+ENTER to open the menu (new window).
ServerI - Publishing on SharePointInformationYesKasper de Jonge
Configure SharePoint 2010 to work with large PowerPivot filesUse SHIFT+ENTER to open the menu (new window).
ServerI - Publishing on SharePointInformationYesDave Wickert
How much does PowerPivot for SharePoint cost?Use SHIFT+ENTER to open the menu (new window).
ServerI - Publishing on SharePointInformationYesRob Collie
Expand/Collapse Topic : J - Report Gallery ‎(6)
Manage the sort order of your PowerPivot sheets in the SharePoint GalleryUse SHIFT+ENTER to open the menu (new window).
BothJ - Report GalleryInformationYesKasper de Jonge
PowerPivot workbook not showing up in SharePoint PowerPivot GalleryUse SHIFT+ENTER to open the menu (new window).
ServerJ - Report GalleryTroubleshootingYesKasper de Jonge
So i requested a PowerPivot workbook from SharePoint, what happens?Use SHIFT+ENTER to open the menu (new window).
ServerJ - Report GalleryInformationYesKasper de Jonge
Can I force the snapshot (thumbnails) for my PowerPivot workbook to refresh?Use SHIFT+ENTER to open the menu (new window).
ServerJ - Report GalleryInformationYesRussell Christopher
Why document snapshot is not visible in Report Gallery?Use SHIFT+ENTER to open the menu (new window).
ServerJ - Report GalleryTroubleshootingYesMarco Russo
Use a PowerPivot workbook in a Excel Web Access WebpartUse SHIFT+ENTER to open the menu (new window).
ServerJ - Report GalleryInformationYesKasper de Jonge
Expand/Collapse Topic : K - Data Refresh ‎(5)
Can I run the ACE provider on the server?Use SHIFT+ENTER to open the menu (new window).
ServerK - Data RefreshInformationYesDave Wickert
When I do a "Refresh All" in Excel, my PowerPivot data is still old. What am I doing wrong?Use SHIFT+ENTER to open the menu (new window).
ClientK - Data RefreshTroubleshootingYesRob Collie
Does PowerPivot support incremental refresh from its sources or is it always a full refresh?Use SHIFT+ENTER to open the menu (new window).
BothK - Data RefreshInformationYesRob Collie
Where in SharePoint can I define "Business Hours" for PowerPivot data refresh? Use SHIFT+ENTER to open the menu (new window).
ServerK - Data RefreshInformationYesVidas Matelis
Can i configure an schedule for automatic Data refresh more than once a day?Use SHIFT+ENTER to open the menu (new window).
ServerK - Data RefreshInformationYesJochen Juelke
Expand/Collapse Topic : L - Security ‎(1)
What is the security model for PowerPivot?Use SHIFT+ENTER to open the menu (new window).
ServerL - SecurityInformationYesRob Collie
Expand/Collapse Topic : M - Traditional OLAP ‎(6)
Are "many to many" relationships supported in PowerPivot?Use SHIFT+ENTER to open the menu (new window).
ClientM - Traditional OLAPInformationYesMarco Russo
Are "parent child dimensions" supported in PowerPivot?Use SHIFT+ENTER to open the menu (new window).
ClientM - Traditional OLAPInformationYesRob Collie
Can I run the PowerPivot version of Analysis Services and the traditional MOLAP version of Analysis Services on the same server?Use SHIFT+ENTER to open the menu (new window).
ServerM - Traditional OLAPInformationYesRob Collie
1 - 150 Next