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
1k 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
821 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
180 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
470 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
268 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
41 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
451 views

Calculating Annualized Turnover in a Pivot Table or PowerPivot

I'm trying to calculate employee turnover where the numerator is annualized only for the current incomplete year. The closest I have gotten is TER/HC as a calculated Field in a pivot table. This ...
0
votes
1answer
872 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
705 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 ...
2
votes
0answers
41 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 ...
1
vote
0answers
29 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
306 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
290 views

PowerPivot data feed error “Semicolon expected” during import

When importing data from an atom feed in PowerPivot, I get the following error: XML parsing failed at line 7, column 727: Semicolon expected. The feed currently only returns two entries, and ...
1
vote
0answers
177 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
8 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
0answers
16 views

PowerPivot install cannot activate add-in

I am having problems activating PowerPivot on my colleagues' computer. While I have been able to activate successfully, 3 of my colleagues are having problems even though our hardware and software ...
0
votes
0answers
31 views

Why some columns (fields) dissapear when I import a Power Query connection into PowerPivot on Excel 2010?

I have a Power Query connection set up in Excel 2010 that is NOT loaded into a worksheet (messy) or a data model (only for Excel 2013). Upon entering PowerPivot, I go to 'Existing Connections' and ...
0
votes
0answers
35 views

MS Excel: Send Data from PowerView to PowerPivot

I have an Excel workbook with two sheets: a PowerView sheet and a PowerPivot sheet. They both show the same data; the PowerView sheet shows data at a high level, and the PowerPivot allows users to ...
0
votes
0answers
154 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 ...
0
votes
0answers
268 views

Why is my excel 2013 pivot table not sorting properly on % differnce

I have a pivot with the following: Categories running down the rows Columns with a count in for each category for each quarter last year, say number of jobs in each category for each quarter. When ...
0
votes
0answers
159 views

Calculating Annualized Turnover in Excel PowerPivot

Can someone please help me formulate this as a Dax expression? This is an extension of the problem here: calculating-annualized-turnover-in-a-pivot-table-or-powerpivot In this version I need to ...