PowerPivot is a data mashup and data exploration tool based on xVelocity in-memory technologies providing analytical performance to process billions of rows at the speed of thought.

learn more… | top users | synonyms

0
votes
2answers
5k views

Excel 2013 PowerPivot add-in crashes Windows 7

Running into a serious problem with little help on solving the issue. Any time I try doing anything with DAX or sometimes just opening Excel application, Excel crashes and gives me the following ...
0
votes
2answers
2k views

PowerPivot for Excel 2010 not installing on Office 2010 Home And Business

I'm trying to install Microsoft PowerPivot on a machine with a full Office 2010 Home and Student installation, and I'm not able to get the installation to work properly. The COM library will not ...
-1
votes
2answers
606 views

Power Pivot - Average time per item

I'm trying to calculate on average, how long it takes to make each item. Here is the data table: Date Item Quantity Operator 01/01/2014 Item1 3 John 01/01/2014 Item2 5 ...
2
votes
1answer
169 views

How can I publish excel workbook with data populated using PowerQuery to SharePoint or website and have the data refresh on the site?

I have an Excel Workbook that gets data from an API using PowerQuery, to populate the tables. There are also filters and slicers in the workbook. Is it possible to publish this workbook to ...
2
votes
1answer
3k views

How should I share workbooks that use PowerPivot?

I've used powerpivot to make a super-awesome report. But now I need to share it with my co-workers, who do not use powerpivot. When I send someone a powerpivot report to users without powerpivot ...
1
vote
1answer
126 views

Changing the Workbook Connection String in PowerPivot

I recently had to move a PowerPivot report from one terminal server to another. I was able to get the PowerPivot Data Connections up and running without much trouble. When I click Test Connection, it ...
1
vote
1answer
124 views

Powerpivot install fails

My machine runs windows 7 professional (64bit) and I use MS office 2010 professional 32 bit. I'm attempting to (re)install the powerpivot plugin but i get an error stating "installation of ...
1
vote
1answer
368 views

How can you improve an Excel workbook that leverages PowerPivot

I have an Excel workbook that has 30 plus pivot tables and 10 plus slicers connected to PowerPivot. When we filter data based on these slicers the performance is sub par, 30 sec to 2 minutes. Is ...
0
votes
1answer
16 views

why powerpivot completly brokes if there is no values?

Can't understand simple thing about PowerPivot. Why this works: When this doesn't: I have just removed attribute "Earned" from "Values" group and PowerPivot completely brokes (in my opinion): ...
0
votes
1answer
61 views

Excel function/Date Table - Defining week and period

Forgive me if this is a rookie question, however I'm kind of at a loss. I've been evaluating the PowerPivot tool for Excel, and one of the guides I came across with how to most effectively leverage it ...
0
votes
1answer
53 views

Loading data to power pivot via power query vs. directly to power pivot

If I'm fine with doing everything in PowerPivot, aside of future proofing in case I may want to edit queries in the future, are there any reasons to put Power Query buffer in between my data source (...
0
votes
1answer
107 views

Is there a way to hide the Field List in an Excel PowerPivot table so that no users can see it?

I've got a dashboard created via PowerPivot that, when the charts are selected, allows users to open the PowerPivot Field List, so they can see things like, for example, the email address of the ...
0
votes
1answer
63 views

Variables from Multiple columns lookup to insert new column in Power Query or Power Pivot

Apologies for the layout from below but it is a sample with 4 columns. I need to insert the target from Table below in a new column, based on the Product (Quite a long list) together with the ...
0
votes
1answer
318 views

Two-way data update with Excel PowerPivot tables (Office 2013)

Background: We have two excel workbooks: Data and Visual which we are using to track and visualize activities in our project. The Data file is organized like a database: each sheet is a table (which ...
0
votes
1answer
2k views

Create a box and whisker plot in Excel 2016

I asked this question on StackOverflow as well, but I realized that this site may be more likely to produce an answer. My question is: how to create a Box and Whisker plot in Excel 2016? I know that ...
0
votes
1answer
462 views

How can I make a time by date chart in powerview

I am trying to produce a report of when an event first occurs every day. I'd like to produce a line chart using PowerPivot and Power View that shows the earliest time the event occurs as a line, with ...
0
votes
1answer
125 views

Powerpivot; Get a datadump from SQL vs creating a data model in excel

I have a SQL table that includes sales and lead data along with detailed account information, and I have another table that just includes detailed account information. My question is whether it is ...
0
votes
1answer
1k views

How to group count by week date in PowerPivot

I have a table of data in PowerPivot connected to a sharepoint list. Each row has a date that I need to group by week and count the rows in that week. Is there a DAX formula or other approach to ...
-2
votes
1answer
1k views

Merging data tables to form one master table

I have multiple sheets containing a table each which I want to merge to form a master table sheet. I also need this master sheet to be updated automatically incase we make any changes to the tables ...
1
vote
0answers
15 views

How to overwrite measures at a line level in PowerPivot

I have two tables, each of the same dimension and same level of granularity; Date, Site, Campaign, Ad Group, Keyword are the columns, with spend as the single measure. What I am wanting to do is ...
1
vote
0answers
414 views

How to create a 100% stacked column chart if I have total

I'm trying to create a 100% stacked column chart using Excel 2013 Pivot Table to show what % of Column A is of a Total Column B. However the 100% stack column chart doesn't seem to work if I have a ...
1
vote
0answers
278 views

Excel 2013 Workbook Size Optimizer not working

I have a large PowerPivot/PowerView workbook that needs to be cleaned up. Microsoft offers a free tool called the Workbook Size Optimizer for situations like this, but I have not been successful in ...
1
vote
0answers
39 views

Powerpivot will not install

I am trying to install 64 bit Powerpivot on a 64 bit Excel 2010 platform on a Windows 7 64 bit machine. I get an error message saying Excel 2010 must be present first, even though it already is. ...
1
vote
0answers
517 views

How to display non-hierarchical attributes on same row using Excel Powerpivot?

Using an Excel 2013 ProPlus PowerPivot pivot table, I have the following: (+ indicating a drill-down point) +Attribute-1 +Attribute-2 Attribute-3 Attribute-4 Below is what I would like to ...
1
vote
0answers
187 views

PowerPivot - Your beta software has expired

I'm running the 32-bit version of Excel 2010 on Windows 7 64. I've downloaded the 32-bit version of PowerPivot from here however I get the following error: Now I can see what the error message is ...
0
votes
0answers
22 views

Converting traditional pivot table to data model based

When creating a pivot table, there is an option to add data to the data model. If a pivot table was originally created without this option enabled, is it possible to convert it to a data model backed ...
0
votes
0answers
36 views

Excel Conditional Formatting disappears unless smaller dataset in filter

Conditional Formatting on a Power Pivot (Excel 2016 32-bit) using a Color bar is working nicely when results are page filtered to a smaller subset. But when nothing is filtered, the CF disappears, so ...
0
votes
0answers
49 views

How can I turn table column headers which hold dates into pivot table and be able to consolidate by fiscal year or quarter

I have a table that we use to standardize client company financial information. How can I manipulate this table so that I can easily use pivot tables and group the dates by Year or by Quarter? ...
0
votes
0answers
31 views

Excel PowerPivot m2m with time series

I have a dataset which I have simplified a bit for this post. From the image you can see that I have two data tables. They essentially list the estimated output from two 'facilities', and the actual (...
0
votes
0answers
32 views

Power Pivot for Excel - version 11 not Installing on Office Professional Plus 2010

I'm trying to upgrade the Power Pivot for Excel add-on from version 10 to version 11, but I keep getting the error that Microsoft Excel 2010 must be installed first. The laptop is running on Windows ...
0
votes
0answers
36 views

How to merge Excel PivotTable results with another sheet?

I have an Excel spreadsheet, where I have a PivotTable where the X is Location & Commodity. The Y is Fiscal Year. The cell data is a sum of Commodity cost. The PivotTable is being generated from ...
0
votes
0answers
83 views

Powerpivot, Calculate(SUM()) with OR Statement?

I've trying to sum a column with multiple or condition, and I haven't been able to figure out how I could simply have multiple formulas like calculate(sum(), filter1)+calculate(sum(), filter2)+...
0
votes
0answers
420 views

Does MSOLAP.5 automatically ship when the Power Pivot addin is installed

We have been getting the following error on some user's PCs when they are trying to connect to Analysis Services OLAP cubes: XML for Analysis parser: The restriction value provided by the ...