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
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 -
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.
-
1 VotesWho will be announced the next Microsoft TechNet Guru? Read more about September 2017 competition
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that ...Sticky | 1 Replies | 135 Views | Created by [Kamlesh Kumar] - Friday, September 01, 2017 9:52 AM | Last reply by [Kamlesh Kumar] - 23 hours 34 minutes ago
-
7 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 | 3910 Views | Created by Avichal Singh (Avi) - Thursday, October 30, 2014 7:47 PM | Last reply by Ed Price - MSFT - Wednesday, February 04, 2015 7:50 PM
-
0 Votes
calculating weighted revenue forecast accuracy with hierarchies in Powerpivot
Hi, I am struggling with the following problem: I want to calculate the revenue weighted forecast error in powerpivot but I ...Unanswered | 6 Replies | 82 Views | Created by BusinessAnlyst - Tuesday, September 19, 2017 2:54 PM | Last reply by Ashish Mathur - 7 hours 57 minutes ago -
0 Votes
DAX - SUM of MAX with a Twist
Hi Experts! I have a problem where I need to calculate the correct odometer reading value for vehicles. I need to take the highest reading of each vehicle and sum these numbers up ... -
2 Votes
PowerPivot - Sharepoint query on certain information
Hi guys, So my company will soon have Sharepoint with PowerPivot services enabled and I have a PowerPivot model I would like to apply. I am quite an avid user of PowerPivot but as ...Answered | 3 Replies | 93 Views | Created by JoeyStyles - Monday, September 18, 2017 9:11 AM | Last reply by willson yuan - 13 hours 19 minutes ago -
1 Votes
Who will be announced the next Microsoft TechNet Guru? Read more about September 2017 competition
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that ...Discussion | 1 Replies | 135 Views | Created by [Kamlesh Kumar] - Friday, September 01, 2017 9:52 AM | Last reply by [Kamlesh Kumar] - 23 hours 34 minutes ago -
0 Votes
geo localization unacurancy
After reading longitude and latitude from and XLS file, mapping representation in Power BI is not accurate. If entering same coordinates in Bing Maps app, results in the appropriate visualization, not ...Unanswered | 1 Replies | 53 Views | Created by JoSabate - Tuesday, September 19, 2017 1:55 AM | Last reply by willson yuan - Tuesday, September 19, 2017 4:00 AM -
0 Votes
Matrix Column Header Values Not Showing Up
Dear Team, I have created the same model 4 times. In each instance that I created the model I have a Matrix with Row and Column Criteria for the DAX Measure. The ...Answered | 2 Replies | 84 Views | Created by Mike Girvin - Saturday, September 16, 2017 5:17 PM | Last reply by Mike Girvin - Monday, September 18, 2017 1:48 PM -
0 Votes
'RELATIONSHIP MAY BE NEEDED' based on location of measure
Hi all - quick question about the yellow 'RELATIONSHIP MAY BE NEEDED' in Excel 2016 PowerPivot. I want to organize all my Measures in a dummy table per Rob Collie's guide in this ...Answered | 1 Replies | 70 Views | Created by mc9526 - Friday, September 15, 2017 3:28 PM | Last reply by willson yuan - Monday, September 18, 2017 8:19 AM -
0 Votes
Why Two "Count Rentals" Measures Yield Different Answers?
Dear Team, I have two Measures that I expect to yield the same answer and I am wondering if anyone can see why they are not yielding the same ...Unanswered | 6 Replies | 125 Views | Created by Mike Girvin - Saturday, September 16, 2017 5:18 PM | Last reply by willson yuan - Monday, September 18, 2017 7:41 AM -
0 Votes
Is Inactive Relationship automatic in Power BI Desktop?
Dear Team, I am trying to use SAMEPERIODLASTYEAR in CALCULATE. My formula did not work because I cannot have a relationship between the Data Table and the Fact Table. So I was ...Unanswered | 1 Replies | 94 Views | Created by Mike Girvin - Saturday, September 16, 2017 8:09 PM | Last reply by willson yuan - Monday, September 18, 2017 1:23 AM -
0 Votes
Forecast and Actuals
Hello, I am trying to create measures to display several version of forecasts. In the following presentation you shoud had a slicer do allows the data selection ...Unanswered | 9 Replies | 312 Views | Created by Jerome Charbonnier - Thursday, August 10, 2017 2:32 PM | Last reply by Jerome Charbonnier - Friday, September 15, 2017 1:27 PM -
0 Votes
Filtering across multiple related tables
seems to work with RELATEDTABLE(Attendance))Filter these records: Attendance[AttendanceStatus] = "attended" ...Answered | 5 Replies | 176 Views | Created by QOSIT_SAS - Monday, September 11, 2017 11:31 AM | Last reply by willson yuan - Friday, September 15, 2017 7:12 AM -
0 Votes
European Date Sorting Issue
I have a PowerPivot with a data model with data pulled form an OLAP cube. The workbook was created in the US and data fields sort and appear correctly (MM/DD/YYY ). We have users ...Unanswered | 1 Replies | 82 Views | Created by Randy Cona - Thursday, September 14, 2017 5:31 PM | Last reply by willson yuan - Friday, September 15, 2017 5:07 AM -
0 Votes
Beginner's Question
I am trying to generate a simple list in Power Pivot. I have imported tables and established relationships. I am trying to generate a simple report. Each claim has ...Unanswered | 1 Replies | 95 Views | Created by Pilott28 - Thursday, September 14, 2017 8:18 PM | Last reply by willson yuan - Friday, September 15, 2017 3:10 AM -
0 Votes
Error while running Refresh Now or Sceduled Refresh in Power BI having data in SharePoint Online Lists
I get error while running Refresh Now or Scheduled Refresh in Power BI having data in SharePoint Online Lists. I made authentication as OAuth2 but still it gets failed. It was running ...Unanswered | 1 Replies | 83 Views | Created by Satyendra Kumar Mishra - Thursday, September 14, 2017 4:14 PM | Last reply by willson yuan - Friday, September 15, 2017 2:55 AM -
0 Votes
Can't able to add/delete column from sql statement- Edit table properties
I connected the data source using Microsoft Analysis services(SSAS cube) and successfully created a new query by drag and drop the column in designer window. After that I want to add/delete column ...Unanswered | 1 Replies | 133 Views | Created by Sathishkumar Chakravarthi - Wednesday, September 13, 2017 11:41 AM | Last reply by willson yuan - Thursday, September 14, 2017 3:18 AM -
0 Votes
DAX formula for Number Properties Rented
Dear Team, My goal is to find a DAX Measure that will count the number of properties rented each month. My Data Model consists of three tables. The tables ...Unanswered | 6 Replies | 195 Views | Created by Mike Girvin - Saturday, September 09, 2017 7:37 PM | Last reply by Herbert Seidenberg - Wednesday, September 13, 2017 8:20 PM -
0 Votes
can't see "online search" in ribbon
Hi experts, I was following an example from the book ‘applied MS BI’, and the example is “online search” with power ...Unanswered | 1 Replies | 92 Views | Created by maca128 - Tuesday, September 12, 2017 3:57 PM | Last reply by willson yuan - Wednesday, September 13, 2017 2:44 AM -
0 Votes
Power Pivot not import all columns from Excel
I have an Excel spreadsheet with 300 columns and when I try to import them into Power Pivot, it loads only 80 columns? How can I solve de problem by importing ...Unanswered | 1 Replies | 108 Views | Created by WilliamArd - Tuesday, September 12, 2017 1:50 AM | Last reply by willson yuan - Tuesday, September 12, 2017 3:19 AM -
0 Votes
IF DAX statement between two values
0,[VOLUMES]<199),[VOLUMES],0) Column name:PT = ...Answered | 7 Replies | 13677 Views | Created by AntoMtl - Wednesday, July 25, 2012 12:26 PM | Last reply by SailingKitty - Monday, September 11, 2017 9:20 AM -
0 Votes
LOOKUP ON MULTIPLE CRITERIA IN DAX
Dear Expert! First of all thanks for your contribution in making things possible for learners. I structured a set of tables and made relationships in power ...Unanswered | 1 Replies | 150 Views | Created by Dilawer Hussain - Saturday, September 09, 2017 11:32 AM | Last reply by willson yuan - Monday, September 11, 2017 6:27 AM - Items 1 to 20 of 4982 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
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 -
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.
