PowerPivot Posts
Filter     Display # 
# Article Title Date Author
1 Using PowerPivot’s Copy-Paste Support for Importing Data from Word 2010-03-12 Artemakis Artemiou
2 Q: I have a field in the pivot that shows duration on some event in seconds. How can I create calculated measure using DAX that would convert numeric result (seconds) to string in the format hh:mm:ss? 2010-03-10 Vidas Matelis
3 Writing a RANK measure (and living to tell the tale) 2010-03-10 Rob Collie
4 A Peek Inside: Unloading PowerPivot data 2010-03-06 Dave Wickert
5 Installing the right version of SharePoint 2010-03-06 Dave Wickert
6 Thoughts on how PowerPivot and SSAS could work together 2010-03-06 Chris Webb
7 Make your PowerPivot on SharePoint “view only” 2010-03-04 Kasper de Jonge
8 Keeping a workbook ‘pinned’ in memory 2010-03-04 Dave Wickert
9 Video - Microsoft PowerPivot DataFeed Source 2010-03-02 Nico Verbaenen
10 Video - Microsoft PowerPivot Loading Data 2010-03-02 Nico Verbaenen
11 Video - Microsoft PowerPivot Creating Reports 2010-03-02 Nico Verbaenen
12 Video - Microsoft BI PowerPivot DAX Time calculations : YTD 2010-02-26 Nico Verbaenen
13 Create simple and effective reports for Commerce Server with PowerPivot (aka Gemini) 2010-02-25 Gael Duhamel
14 Revisiting ALL() 2010-02-25 Rob Collie
15 Diagnostic Guide for Usage and the PowerPivot Management Dashboard 2010-02-25 Ankur Goyal
16 Why you may want to use RBS for your #PowerPivot for #SharePoint Farm 2010-02-24 Denny Lee
17 When is null not a null? 2010-02-24 Dave Wickert
18 SUMX() – The 5-point palm, exploding fxn technique 2010-02-24 Rob Collie
19 Screencast: Using datamining with PowerPivot in Excel 2010-02-23 Kasper de Jonge
20 Screencast: Using datamining with PowerPivot in Excel 2010-02-13 Kasper de Jonge
21 Cannot add the specified assembly to the global assembly cache 2010-02-13 Lee Graber
22 Rob Collie PowerPivot video (from Swedish UG meeting) 2010-02-11 Rob Collie
23 Jewelry Mashup for Alpha Geek Challenge 2010-02-11 Bill Jelen
24 Granting Excel Services access rights to your #PowerPivot for SharePoint Farm 2010-02-11 Denny Lee
25 Producing and consuming OData feeds: An end-to-end example 2010-02-10 Jon Udell
26 Using Time intelligent PowerPivot functions with fiscal year 2010-02-09 Kasper de Jonge
27 How to relate tables in DAX without using relationships 2010-02-09 Marco Russo
28 Surprising Example of PowerPivot Compression 2010-02-09 Rob Collie
29 The data connection uses Windows Authentication and user credentials could not be delegated 2010-02-09 Lee Graber
30 Dashboard Bubble Chart Shows a Red X (fails to load) 2010-02-09 Lee Graber
31 PowerPivot Retail Analysis Example 2010-02-09 Rob Kerr
32 A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook 2010-02-09 Lee Graber
33 Troubleshooting PowerPivot Relationships 2010-02-08 Kasper de Jonge
34 Avoiding calculated column in DAX 2010-02-06 Marco Russo
35 PowerPivot Data in Scatter Charts, etc. 2010-02-06 Rob Collie
36 Table Denormalization Study in PowerPivot 2010-02-05 Marco Russo
37 Pivots, Cube Formulas, Named Sets … Oh my! 2010-02-05 Denny Lee
38 Pivots, I have not forgotten ye! 2010-02-05 Rob Collie
39 Hands-on-Labs - PowerPivot in SQL Server 2008 R2 (Part of the SQL Server training kit) 2010-02-04 Microsoft
40 Video - PowerPivot for Excel/SharePoint 2010 - Interview with T.K. Anand 2010-02-04 T.K. Anand
41 Creating a SharePoint 2010 Business Intelligence VM Image (using SQL Server 2008 R2 CTP) 2010-02-03 Steve Mann
42 Introducing CUBESET() and CUBERANKEDMEMBER() 2010-02-03 Rob Collie
43 PowerPivot and BI architecture 2010-02-02 Thomas Ivarsson
44 Hands-on PowerPivot: To the Cloud 2010-02-02 David Ramel
45 Management Features of PowerPivot for SharePoint 2010-02-02 John Hancock
46 Parameterizing the report 2010-02-01 Rob Collie
47 SQLBits Video - Self Service Business Intelligence- Project Gemini 2010-02-01 Bob Duffy
48 Video - SharePoint 2010 BI Overview 2010-01-31 Mike Fitzmaurice
49 Reading your #PowerPivot Profiler trace 2010-01-30 Denny Lee
50 QlikView from a PowerPivot standpoint 2010-01-30 Donald Farmer
51 What database support is needed 2010-01-30 Dave Wickert
52 OData: There’s a feed for that 2010-01-30 Douglas Purdy
53 PowerPivot for SharePoint Video 2010-01-29 Rob Collie
54 Create a #PowerPivot report filtered by the Top X Users by "Logic" 2010-01-28 Denny Lee
55 Rob Collie (PowerPivotPro) videos on YouTube 2010-01-27 Rob Collie
56 Sales Forecasting with Excel 2010 (and PowerPivot) 2010-01-27 Microsoft
57 Memory Considerations about PowerPivot for Excel 2010-01-26 Marco Russo
58 Powerpivot - Installation, first report, dax 2010-01-25 Yaniv Mor
59 PowerPivot Cookery - video that explains what PowerPivot is through cooking example 2010-01-25 Andrew Fryer
60 How to start debugging a PowerPivot for SharePoint installation issue 2010-01-24 Lee Graber
61 Self-Service BI with PowerPivot for Excel 2010 2010-01-23 Thiago Zavaschi
62 PowerPivot, DAX and Semi-additive measures 2010-01-21 Russell Christopher
63 Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’ 2010-01-21 Lee Graber
64 PowerPivot introduction videos - load, analyse and use in SharePoint 2010-01-19 Andrew Fryer
65 #PowerPivot Data Refresh SSRS Report 2010-01-19 Denny Lee
66 How to manually update your PowerPivot Management Dashboard 2010-01-19 Dave Wickert
67 Why you shouldn’t stop / start Analysis Services from SCM when running in SharePoint Integration Mode 2010-01-19 Lee Graber
68 ABC Analysis in PowerPivot 2010-01-19 Marco Russo
69 Not your average PowerPivot report 2010-01-19 Rob Collie
70 Screencast: Import data from reporting services into PowerPivot 2010-01-19 Kasper de Jonge
71 Enable PerformancePoint on SharePoint 2010 2010-01-15 Kasper de Jonge
72 How do I get the menu options for individual reports within the #PowerPivot Gallery? 2010-01-15 Denny Lee
73 How to PowerPivot outlook data (*.ost or *.pst) data in Microsoft Office Excel 2010 2010-01-13 Roel van Lisdonk
74 Solving the 'Events in Progress' Problem in DAX, Part Two: Aggregating Dates and Multiselect 2010-01-13 Chris Webb
75 The MIE Podcasts – Rob Collie 2010-01-13 Rob Collie
76 Screencast: Introduction to time intelligent functions in PowerPivot 2010-01-13 Kasper de Jonge
77 Q: How can I create Fiscal Date/Time table for PowerPivot if I do not have any source for that? 2010-01-12 Vidas Matelis
78 So i requested a PowerPivot workbook from SharePoint, what happens? 2010-01-10 Kasper de Jonge
79 Manage the sort order of your PowerPivot sheets in the SharePoint Gallery 2010-01-10 Kasper de Jonge
80 Q: How can I create Calendar Date/Time table for PowerPivot if I do not have any source for that? 2010-01-09 Vidas Matelis
81 Touchdown Problem Solved, and COUNTROWS 2010-01-09 Rob Collie
82 Excel PowerPivot Review - Video 2010-01-08 Chandoo
83 Solving the 'Events in Progress' Problem in DAX 2010-01-07 Chris Webb
84 Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI 2010-01-06 Denny Lee
85 Q: How do I hide "Grand Total" calculation for PowerPivot columns and/or rows? 2010-01-05 Vidas Matelis
86 The PowerPivot Experiment 2010-01-05 Artemakis Artemiou
87 Q: How can I change maximum PowerPIvot file size that can be uploaded to SharePoint 2010? 2010-01-05 Vidas Matelis
88 Q: Where PowerPivot for SharePoint logs are located and how to read them? 2010-01-05 Vidas Matelis
89 Creating a PerformancePoint 2010 dashboard on a published SharePoint PowerPivot app 2010-01-04 Kasper de Jonge
90 How CALCULATE works in DAX 2010-01-03 Marco Russo
91 Creating a SSRS report on a published SharePoint PowerPivot app 2009-12-31 Kasper de Jonge
92 Solving a business problem with Powerpivot CTP3 using DAX Timefunctions 2009-12-31 Kasper de Jonge
93 Instructions for the installation and configuration of Reporting Services in SharePoint Integration Mode 2009-12-30 Dave Wickert
94 PowerPivot for SharePoint Single Server Install with Dedicated SQL Server 2009-12-30 Dave Wickert
95 Distinct Count Measure in PowerPivot using DAX 2009-12-26 Marco Russo
96 How to add DAX calculations to the PowerPivot workbooks 2009-12-18 Vidas Matelis
97 Recorded webcast - A Preview to PowerPivot Server Best Practices 2009-12-17 Microsoft
98 Monitor your SSIS Package execution with PowerPivot 2009-12-17 Kasper de Jonge
99 DAX CALCULATE, and Rapid Iteration 2009-12-17 Rob Collie
100 Step by Step guide for creating demo PowerPivot workbook from AdventureWorksDW SQL tables 2009-12-17 Vidas Matelis
101 Using PowerPivot with SQL Azure 2009-12-16 Stephen Forte
102 PowerPivot DAX: CALCULATE is a supercharged SUMIF 2009-12-15 Rob Collie
103 Recorded webcast: "Introduction to PowerPivot or How I Learned to Stop Worrying and Love Excel" 2009-12-13 Chris Webb
104 Excel Services delegation 2009-12-12 Dave Wickert
105 PowerPivot 101 – an Introduction 2009-12-11 Andrew Fryer
106 PowerPivot online demos 2009-12-11 Microsoft
107 Refreshing PowerPivot Data 2009-12-10 Robert C. Cain
108 Reported problems installing PowerPivot for SharePoint 2009-12-10 Dave Wickert
109 DAX's CALCULATE() function - Pivots will never be the same 2009-12-09 Rob Collie
110 Putting the "Intelligence" in "Business Intelligence" 2009-12-07 Rob Collie
111 PowerPivot - Data Import In November CTP 2009-12-07 Ashvini Sharma
112 Many-to-Many relationships in PowerPivot 2009-12-07 Marco Russo
113 Lookups in PowerPivot Calculated Columns - Using the RELATED Function 2009-12-07 Robert C. Cain
114 Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months) 2009-12-05 Vidas Matelis
115 Getting difference of two dates in seconds with PowerPivot DAX 2009-12-05 Kasper de Jonge
116 DAX: Running Totals 2009-12-05 Chris Webb
117 Visualizing SQL Indices with PowerPivot 2009-12-05 Rob Collie
118 Calculated Columns in PowerPivot 2009-12-04 Robert C. Cain
119 Why PowerPivot for SharePoint? 2009-12-02 Dave Wickert
120 Create simple and effective reports through PowerPivot (aka Gemini) 2009-12-02 Gaël Duhamel
121 Combining Data from Multiple Data Sources in PowerPivot 2009-12-02 Robert C. Cain
122 Calling your PowerPivot workbook on SharePoint 2010 remotely 2009-12-02 Kasper de Jonge
123 Creating Tables in PowerPivot 2009-12-02 Robert C. Cain
124 Make your PowerPivot sheet look great in SharePoint 2010 2009-12-01 Kasper de Jonge
125 First steps in DAX: Year-To-Date 2009-12-01 Chris Webb
126 Q: Where in SharePoint can I define "Business Hours" for PowerPivot data refresh? 2009-12-01 Vidas Matelis
127 Q: In my source data I have daily balance values. How in PowerPivot for Excel can I create calculation that shows correct closing balance for year, quarter and month? 2009-11-29 Vidas Matelis
128 SQL Server Reporting Services Reports in the PowerPivot Gallery 2009-11-29 Russell Christopher
129 Understanding DAX - Context (Row) 2009-11-28 Shaun Ryan
130 CTP3 Setup Error: Could not load file or assembly "Microsoft.AnalysisServices.SharePoint.Integration" 2009-11-28 Russell Christopher
131 A Peek Inside: Why no cross-farm support (PowerPivot for SharePoint)? 2009-11-28 Dave Wickert
132 Q: How can I see Analysis Services database structure that is stored within PowerPivot ? 2009-11-27 Vidas Matelis
133 Creating useful PowerPivot data models for public consumption via Reporting Services 2009-11-26 Russell Christopher
134 Q: How can I delete PowerPivot report published into SharePoint PowerPivot gallery? 2009-11-26 Vidas Matelis
135 Q: How can I check what version of PowerPivot for Excel is installed on my machine? 2009-11-25 Vidas Matelis
136 Combine data from the cloud with local data using PowerPivot and Dallas 2009-11-25 Kasper de Jonge
137 Using PowerPivot to combine cube (SSAS) data with manual data, the movie 2009-11-24 Kasper de Jonge
138 Import Filters in PowerPivot 2009-11-24 Robert C. Cain
139 Using PowerPivot to combine cube (SSAS) data with manual data 2009-11-23 Kasper de Jonge
140 Video: SharePoint 2010 and PowerPivot 2009-11-22 Michael Gannotti
141 How to install PowerPivot for Excel and list of know issues 2009-11-21 Vidas Matelis
142 When is a refresh not a refresh? 2009-11-21 Dave Wickert
143 Sharing workbooks using PowerPivot Gallery 2009-11-21 John C. Hancock
144 PowerPivot Data Refresh 2009-11-21 Dave Wickert
145 Introducing Microsoft PowerPivot 2009-11-20 Robert C. Cain
146 Video: Custom Theming A SharePoint 2010 Site Using PowerPoint 2010 2009-11-20 Michael Gannotti
147 PowerPivot for SharePoint existing farm installation guide (draft paper by Microsoft) 2009-11-20 Microsoft
148 PowerPivot for SharePoint single server install guide (draft paper by Microsoft) 2009-11-20 Microsoft
149 Step by step guide on installing PowerPivot for SharePoint on a single machine 2009-11-20 Vidas Matelis
150 Data Connection Libraries missing in SharePoint 2010 2009-11-19 Bob Duffy
151 A Peek Inside: Why are domain accounts needed? 2009-11-19 Dave Wickert
152 Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction 2009-11-19 Microsoft
153 Installing PowerPivot for SharePoint on a domain controller 2009-11-18 Dave Wickert
154 Troubleshooting #PowerPivot Excel Services connectivity 2009-11-18 Denny Lee
155 PowerPivot overview and How To videos 2009-11-18 Microsoft
156 Introducing PowerPivot DAX Measures 2009-11-16 Rob Collie
157 Steps taken during a PowerPivot data refresh 2009-11-13 Dave Wickert
158 Temperature Mashup Example 2009-11-13 Rob Collie
159 List of PowerPivot DAX functions (short) 2009-11-13 Vidas Matelis
160 List of PowerPivot DAX functions with description 2009-11-13 Vidas Matelis
161 A Peek Inside: The client architecture 2009-11-12 Dave Wickert
162 List of suggested datasets to test PowerPivot 2009-11-11 Vidas Matelis
163 SharePoint Prerequisite Lab Installation Tip (#PowerPivot CTP3 Install) 2009-11-11 Denny Lee
164 Geminute - short videos that shows what you can do with PowerPivot 2009-11-11 Donald Farmer
165 DAX: The =RELATED() Function 2009-11-10 Rob Collie
166 A 48 hour case study from Bing - Zero to Sixty :) 2009-11-10 Rob Collie
167 What happens when you run a Data Refresh within PowerPivot for SharePoint? 2009-11-09 Denny Lee, Dave Wickert
168 PowerPivot's impact on BI pros? 2009-11-09 Rob Collie
169 My tweets from SQL PASS Summit 2009 - SSAS, PowerPivot, DAX and more 2009-11-09 Vidas Matelis
170 PowerPivot Linked tables 2009-11-08 T.K. Anand
171 PowerPivot Data Feeds 2009-11-08 John C. Hancock
172 Understanding why an Excel PowerPivot workbook is so large 2009-11-07 Denny Lee, Dave Wickert
173 For Excel PowerPivot, the database is IN the workbook 2009-11-07 Denny Lee, Dave Wickert
174 PowerPivot for SharePoint 2010 - The Business User’s Perspective 2009-10-29 Joseph Chirilov
175 Project BI bloggers – Analysis in PowerPivot (ex-Gemini) 2009-10-28 Tomislav Piasevoli
176 What is PowerPivot? 2009-10-28 Rob Collie
177 Gemini (PowerPivot) Does Cloud! 2009-10-28 Andrew Brust
178 Announcing the Great Football Project (PowerPivot) 2009-10-27 Rob Collie
179 Trying to solve a business problem with Powerpivot, Gemini CTP2 2009-10-26 Kasper de Jonge
180 Using PowerPivot with Excel 2010 2009-10-24 Joseph Chirilov
181 Introducing PowerPivot 2009-10-23 Ashvini Sharma
182 Donald Farmer on Gemini (PowerPivot) - audio interview 2009-10-23 Donald Farmer
183 Creating a Custom Gemini/PowerPivot Data Feed - Method 1 - ADO.NET Data Services 2009-10-20 Sacha Tomey
184 Gemini (PowerPivot)- Copy/Paste 2009-10-14 T.K. Anand
185 PowerPivot DAX function list with samples 2009-10-08 Vidas Matelis
186 Introduction to Data Analysis Expressions (DAX) in Gemini (PowerPivot) 2009-10-01 Howie Dickerman
187 Leaf level queries in Gemini (PowerPivot) and SSAS 2008 2009-09-19 Thomas Ivarsson
188 Importing data into Gemini (PowerPivot) 2009-09-09 Edward Melomed
189 Channel 9 - Donald Farmer and Julie Strauss: Inside Project Gemini (PowerPivot) 2009-09-01 Donald Farmer
190 Gemini (PowerPivot) CTP2 Install Experience and Overview 2009-08-29 Dan English
191 Overview of Gemini (PowerPivot) features 2009-08-25 Ashvini Sharma
192 Soccer statistics in Gemini (PowerPivot) and Excel 2010 2009-08-23 Thomas Ivarsson
193 SQL Server 2008R2 Self Service BI - Gemini (PowerPivot) - how it performs with bigger tables 2009-08-19 Vidas Matelis
194 Gemini (PowerPivot) First Thoughts 2009-08-17 Chris Webb
195 Working with Gemini (PowerPivot) and Excel 2010 to make a pivot table 2009-08-17 Kasper de Jonge
196 BI Power Hour demo - Sneak Preview of Gemini (PowerPivot) 2009-05-21 Donald Farmer
197 Microsoft Project Gemini (PowerPivot) links 2009-04-29 Donald Farmer