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
-
6 VotesWiki 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 | 733 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 | 4420 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
-
3 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 | 9 Replies | 222 Views | Created by cau_cofin - Monday, February 23, 2015 12:26 PM | Last reply by Charlie Liao - 5 hours 41 minutes ago -
0 Votes
Sorting single char month name column
When displaying complete time hierarchies in pivot charts (year, quarter, months), having month labels displayed even over only 3 characters takes too much space and Excel automatically hides some of ...Unanswered | 1 Replies | 26 Views | Created by Bda75 - 6 hours 33 minutes ago | Last reply by Bda75 - 6 hours 5 minutes ago -
0 Votes
PowerPivot and Analysis Services tabular instance in SharePoint
Hello, If I connect to the SQL Server 2012 SP1 Analysis Services tabular instance in SharePoint 2010 that houses all of the PowerPivot files that have been uploaded to our ...Proposed | 4 Replies | 146 Views | Created by Haras999999 - Saturday, February 28, 2015 4:26 AM | Last reply by Charlie Liao - 6 hours 20 minutes ago -
1 Votes
Converting Multiple Excel formulas to Single DAX formula
Hi, I am trying to find a way in powerpivot of combining three 4 validation test columns into one column. The idea is that if the result in test 3 comes up with ...Proposed | 1 Replies | 128 Views | Created by Grinch356 - Tuesday, February 17, 2015 1:25 PM | Last reply by Avichal Singh - 9 hours 54 minutes ago -
0 Votes
PREVIOUSQUARTER generating an error
0 ...Unanswered | 1 Replies | 61 Views | Created by Globalwarmimg - Tuesday, March 03, 2015 9:19 AM | Last reply by Avichal Singh - 10 hours 16 minutes ago -
0 Votes
How can i force the source link to look in current folder? Using dropbox as source location
My data source is an Excel file located on a dropbox folder which is shared between team members. The report file is also located in the same dropbox ...Discussion | 2 Replies | 628 Views | Created by Fenixxen - Sunday, March 02, 2014 9:39 PM | Last reply by gsodevilas31 - 12 hours 6 minutes ago -
0 Votes
Connecting Power Pivot with SAP HANA Database
Hi guys, I am trying to connect Power Pivot with SAP HANA Database using "Microsoft OLE DB Provider for ODBC Drivers" ... -
1 Votes
RANKX
Hi All How to correct the measure below to: 1) exclude Brands where SALES is equal ...Unanswered | 2 Replies | 88 Views | Created by Gordonik - Monday, March 02, 2015 11:03 AM | Last reply by Gordonik - Tuesday, March 03, 2015 9:44 AM -
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 ...Proposed | 3 Replies | 125 Views | Created by B.Ross - Thursday, February 26, 2015 7:57 PM | Last reply by Bda75 - Tuesday, March 03, 2015 8:52 AM -
0 Votes
Scorecard - Nested IFs
=0,[Score]<0.949), "Red", IF(AND([Score]>=.95,[Score]<0.979),"Yellow",IF(AND([Score]>=0.98,[Score]<=1.05),"Green", ...Unanswered | 2 Replies | 91 Views | Created by JCremo - Monday, March 02, 2015 2:20 AM | Last reply by JCremo - Tuesday, March 03, 2015 3:51 AM -
1 Votes
Calculated Field Doesn't FIlter Correctly For Drill Through to Details
COUNTROWS(FILTER(CAEXAMMERGED,[current_rate_cd] = 1)) gives correct value for the pivot table but when I drill through to details, I see all the rows for all values of current_rate_cdProposed | 1 Replies | 93 Views | Created by sasadmin - Friday, February 27, 2015 10:32 PM | Last reply by Gerhard Brueckl - Monday, March 02, 2015 9:51 PM -
1 Votes
Dynamic TOPN sort order ?
I am trying to use the disconnected slicer technique to provide a dynamic parameter to a TOPN statement in a calculated measure. The disconnected table contains a single Idx ...Answered | 1 Replies | 61 Views | Created by Bda75 - Monday, March 02, 2015 5:42 PM | Last reply by Gerhard Brueckl - Monday, March 02, 2015 9:37 PM -
2 Votes
Archive (turn off refresh of data)
I have users who want to be able to refresh some Power Pivot data (sourced out of a SQL Server view), and then "set the data aside" so they can have the set of data as a reference point to ...Proposed | 3 Replies | 136 Views | Created by captkirk35 - Saturday, February 28, 2015 1:01 AM | Last reply by Imke Feldmann - Monday, March 02, 2015 6:34 PM -
1 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 ...Answered | 4 Replies | 192 Views | Created by isa7667 - Thursday, February 26, 2015 2:06 AM | Last reply by Vini875 - Monday, March 02, 2015 6:20 PM -
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 | 3 Replies | 127 Views | Created by jakubk - Wednesday, February 25, 2015 3:37 AM | Last reply by Gerhard Brueckl - Monday, March 02, 2015 3:41 PM -
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 | 3 Replies | 132 Views | Created by Alex Barbeau - Tuesday, February 24, 2015 11:11 PM | Last reply by Gerhard Brueckl - Monday, March 02, 2015 3:35 PM -
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 | 3 Replies | 155 Views | Created by Charbonnier Jerome - Monday, February 23, 2015 9:05 AM | Last reply by Charbonnier Jerome - Monday, March 02, 2015 9:38 AM -
0 Votes
PostgreSQL Data Source Connection for PowerQuery
Hi, Im trying to use the PostgreSQL Data Connection in PowerQuery however once im connected i get the following error message: DataSource.Error: PostgreSQL: ...Unanswered | 1 Replies | 116 Views | Created by Dave Kerby - Wednesday, February 18, 2015 6:46 PM | Last reply by Gil Raviv - Friday, February 27, 2015 1:42 PM -
2 Votes
It'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 ...Discussion | 2 Replies | 187 Views | Created by XAML guy - Monday, February 09, 2015 9:16 PM | Last reply by Ed Price - MSFT - Friday, February 27, 2015 7:09 AM -
4 Votes
DAX funtion with equivalent to GROUP BY in T-sql
Hi all, I have data as follow in power pivot window date hour meter value ...Answered | 8 Replies | 5668 Views | Created by gandla chinnikrishna - Friday, February 22, 2013 9:07 AM | Last reply by Piyush0308 - Friday, February 27, 2015 6:38 AM - Items 1 to 20 of 3138 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
