Power Pivot announcement
-
Link
The PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been released. We know many of you have been eagerly awaiting this fix since last week when the PowerPivot for Excel add-in expired. We do sincerely apologize for the inconvenience this may have caused you.
We have released a new version of the November CTP for the PowerPivot for Excel add-in. This new version is functionally identical to the old one except that it extends the expiration date to end of the year. You can download it from the same locations as in the past:
- http://powerpivot.com/download.aspx
- http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca
Please note that the new version will take some time to replicate across all servers in the Microsoft download center. If you download it from the above links and still get the expiration error message, then try again periodically. It might also help to clear any browser/download caches on your computer.
-
Link
Summary
=============================
If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.
More Information
=============================
The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.
The solution is to upgrade the beta components to their released versions when they become available.
-
Link
If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.
The SQL Server team will re-release the November 2009 CTP version of the PowerPivot for Excel 2010 add-in with an extended expiration date very soon. We will post an availability announcement with the download location and installation instructions on the PowerPivot blogs and forums as soon as possible.
Kathy MacDonald
SQL Server Analysis Services
-
2 VotesIt's time for the TechNet Wiki Power Pivot "Great Guru Love-in"! You too can get some loving!
February at TechNet Wiki usually involves a lot of love... We love to read. We love to learn. We ...Sticky | 1 Replies | 133 Views | Created by XAML guy - Monday, February 09, 2015 9:16 PM | Last reply by Ed Price - MSFT - Sunday, February 15, 2015 7:34 AM
-
6 Votes
Wiki Article: Guidelines for asking Power Pivot Question (e.g. link to file, current+desired results, DAX code, Diagram view...)
Folks, Check out the TechNet Wiki Article: How to ask a Power Pivot Question to get a prompt, accurate and helpful response I noticed that ...Sticky | 4 Replies | 718 Views | Created by Avichal Singh - Thursday, October 30, 2014 7:47 PM | Last reply by Ed Price - MSFT - Wednesday, February 04, 2015 7:50 PM -
10 Votes
NEEDED: More Power Pivot Answerers
UPDATE: This is still an ongoing problem. So we will keep this thread going to try to find enough experts to help maintain this forum by proposing and marking answers. Thank you for your ...Sticky | 26 Replies | 4373 Views | Created by Ed Price - MSFT - Wednesday, August 21, 2013 6:46 PM | Last reply by Ed Price - MSFT - Thursday, February 05, 2015 9:22 PM
-
0 Votes
Getting counts by the second for a records duration
Ok, so most of know what a ghant chart is and how it can visually show us multiple records spanning a single time period and where and how long those records overlap each other. I have a request ... -
1 Votes
No negative numerics allowed as alternative result for DIVIDE()?
Hello, Has anyone been able to pass a negative value to DIVIDE() as the alternative result? I was experimenting with results and performance for DIVIDE(), and set the ...Discussion | 2 Replies | 67 Views | Created by Alex Barbeau - Tuesday, February 24, 2015 11:11 PM | Last reply by Alex Barbeau - 5 hours 32 minutes ago -
3 Votes
Understanding Microsoft's BI Products
Can someone please help me understand Microsoft's overall analytics product offerings? I see a lot of terms mentioned such as Power BI Designer, Power Query, Power Pivot, and Power Pivot Pro. In ...Discussion | 4 Replies | 166 Views | Created by KeepingPace - Thursday, February 19, 2015 8:36 PM | Last reply by Charlie Liao - 7 hours 42 minutes ago -
4 Votes
Data Model won't open
I have created a PowerPivot data model using Excel 2013. It runs fine on my computer (the one where I built it), but will not open in other computers. All computers have the same 64 bit ...Unanswered | 7 Replies | 246 Views | Created by user00568 - Friday, January 23, 2015 3:49 PM | Last reply by Gordonik - 9 hours 23 minutes ago -
0 Votes
Fact Vs Forecast
Hi folks, I wonder if someone did a project where he/she needed to construct a model that checks how the company performed Vs the ...Unanswered | 1 Replies | 86 Views | Created by עמיתת - Tuesday, February 17, 2015 11:23 AM | Last reply by Gordonik - 9 hours 39 minutes ago -
0 Votes
Cannot slice values with quotes sign
Hi all, for some unknown reason, I cannot slice values with quotes sign on a slicer. It does not work on any of the computers in my ...Unanswered | 1 Replies | 60 Views | Created by maring28 - Wednesday, February 25, 2015 7:23 AM | Last reply by Gordonik - 10 hours 21 minutes ago -
0 Votes
cross join in all power pivot relation
Hi, I am working on Office 365 Excel 2013. From last tuesday of this month (the 2015/02/19), all my new reports are false. Even with two simple ...Unanswered | 2 Replies | 98 Views | Created by Charbonnier Jerome - Monday, February 23, 2015 9:05 AM | Last reply by ameyjoe - 11 hours 26 minutes ago -
2 Votes
How to connect more than one cube in power view and pivot to see the data?
Hi, Greetings of the day! Can any suggest me how to connect more than one cube in power view and pivot having same source. steps ...Proposed | 3 Replies | 90 Views | Created by Rasulchowdary - Tuesday, February 24, 2015 5:24 AM | Last reply by Charlie Liao - 20 hours 21 minutes ago -
0 Votes
Power Pivot Fluent User Interface Control Identifiers
I would like to grammatically launch the built-in Power Pivot menu "Manage calculated fields...". I looked at the list of Office Fluent User Interface Control ...Unanswered | 1 Replies | 70 Views | Created by Bda75 - Wednesday, February 25, 2015 12:57 PM | Last reply by Starain chen - 20 hours 24 minutes ago -
0 Votes
SQL Data Warehouse Security
Hi there! I'm in the process of building a data warehouse in SQL 2014. The data warehouse is protected based on roles with username and password. My question is how to prevent ... -
0 Votes
measure based on dynamic effective date (sum as at) help
cross post from the SSAS forum because i figure the dax gurus probably spend more time here ...Unanswered | 2 Replies | 69 Views | Created by jakubk - Wednesday, February 25, 2015 3:37 AM | Last reply by jakubk - 22 hours 29 minutes ago -
1 Votes
SUMX result it shows in all rows who apply the filter in formula.
I need to letf a Unique SUMX value per row who apply filter by 2 Column(In this Eixample: DATAAREA and ...Proposed | 4 Replies | 115 Views | Created by cau_cofin - Monday, February 23, 2015 12:26 PM | Last reply by cau_cofin - Wednesday, February 25, 2015 10:18 PM -
2 Votes
Is there a pivot table in powerview ?
hi to all , i didn't find any option to work or define pivot table object in powerview, is there any option to do it ? or its just missing ...Answered | 3 Replies | 82 Views | Created by yaniv012 - Tuesday, February 24, 2015 9:55 AM | Last reply by yaniv012 - Wednesday, February 25, 2015 8:37 AM -
2 Votes
Merging 2 queries to create a Quantity * LAST KNOWN price calculation
Hi, I have an interesting problem, which I thought of overcoming it in Power Pivot, and realized it is a bit trickier than I ...Proposed | 2 Replies | 93 Views | Created by עמיתת - Friday, February 20, 2015 6:26 PM | Last reply by Gerhard Brueckl - Wednesday, February 25, 2015 7:47 AM -
9 Votes
Find out duplicate records in power pivot
Hi, I am using below DAX function to find out duplicates: =IF([Received Date] = CALCULATE(SUM([Received Date]), TOPN(1, FILTER('Table1', 'Table1'[ID] = ...Answered | 24 Replies | 1765 Views | Created by SS_2011 - Friday, July 04, 2014 5:16 AM | Last reply by PoePoe - Wednesday, February 25, 2015 6:32 AM -
1 Votes
DAX for creating sum of the percentages
I have a table where I have to create percentages by looping on the same table. Here is the sample ...Proposed | 1 Replies | 82 Views | Created by IndusCrest - Monday, February 23, 2015 8:25 PM | Last reply by Gerhard Brueckl - Tuesday, February 24, 2015 6:32 PM -
1 Votes
Hierarchy defined in Tabular is seen in PowerPivot BUT Unseen in PowerView.
Hi to all , i have a case which Hierarchy defined in Tabular is seen in PowerPivot BUT Unseen in PowerView !? does anybody knows what ...Answered | 3 Replies | 95 Views | Created by yaniv012 - Monday, February 23, 2015 6:40 AM | Last reply by Michael Amadi - Tuesday, February 24, 2015 9:41 AM -
2 Votes
Max Sum Per Product within PowerPivot
Hello, I need to sum the max value per product. So for the value the table below it would return 13,134. That or I need to add a calculated column that would get the max value for ...Proposed | 3 Replies | 146 Views | Created by powerpivotquestion - Thursday, February 19, 2015 10:53 PM | Last reply by Michael Amadi - Monday, February 23, 2015 8:35 PM -
0 Votes
Counting rows respect to the last status assumed
Hi, I'm analyzing dossier data in a PowerPivot table. In particular, I've three tables: the Dossier table, the Calendar table (date, week, month, quarter, ...Answered | 12 Replies | 168 Views | Created by pscorca - Friday, February 20, 2015 11:15 PM | Last reply by Imke Feldmann - Monday, February 23, 2015 7:43 AM - Items 1 to 20 of 3129 Next ›
Power Pivot announcement
-
Link
The PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been released. We know many of you have been eagerly awaiting this fix since last week when the PowerPivot for Excel add-in expired. We do sincerely apologize for the inconvenience this may have caused you.
We have released a new version of the November CTP for the PowerPivot for Excel add-in. This new version is functionally identical to the old one except that it extends the expiration date to end of the year. You can download it from the same locations as in the past:
- http://powerpivot.com/download.aspx
- http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=48a5b47b-8c9c-450f-ab6e-178600a733ca
Please note that the new version will take some time to replicate across all servers in the Microsoft download center. If you download it from the above links and still get the expiration error message, then try again periodically. It might also help to clear any browser/download caches on your computer.
-
Link
Summary
=============================
If PowerPivot for Excel 2010, Excel 2010, SharePoint 2010, or the Reporting Services Addin for SharePoint 2010 are beta versions, PowerPivot and its related functionality will not work with the Released versions of these components.
More Information
=============================
The beta versions of the components listed above are not compatible with the released versions of these components. If the beta versions of the components are installed, they will not function with the released versions. For example, if you have a beta version of the PowerPivot download installed and upgrade to the released version of Excel 2010, the PowerPivot addin will not be available in Excel.
The solution is to upgrade the beta components to their released versions when they become available.
-
Link
If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.
The SQL Server team will re-release the November 2009 CTP version of the PowerPivot for Excel 2010 add-in with an extended expiration date very soon. We will post an availability announcement with the download location and installation instructions on the PowerPivot blogs and forums as soon as possible.
Kathy MacDonald
SQL Server Analysis Services
