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.
-
7 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 | 3492 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
SAMEPERIODLAST doesn't works for me !!
helllo, I compare % evolution between 2014 and 2017 from 2014 to 2016 all (%) evolution is corrrent but between 2016 and 2017 i get an issue, ...Unanswered | 9 Replies | 136 Views | Created by ghilasdz - Tuesday, June 20, 2017 7:45 AM | Last reply by ghilasdz - 13 minutes ago -
0 Votes
How to reference column in a calculate table stored in a variable
Hi team, I got a sales table which has 2 columns, date and sales amount. In the date column of the sales table there are duplicates date value ...Proposed | 5 Replies | 60 Views | Created by Tom J Sun - Thursday, June 22, 2017 11:15 AM | Last reply by willson yuan - Friday, June 23, 2017 8:07 AM -
0 Votes
Grand Total Column Not Averaging Right
I want to average the numbers in the pivot table by year liek you see below, but the Grand total column should say the average of all the years and it does not. It says it is summarizing by average. ...Unanswered | 1 Replies | 70 Views | Created by Hannah Hammeren - Wednesday, June 21, 2017 7:28 PM | Last reply by willson yuan - Thursday, June 22, 2017 7:49 AM -
0 Votes
A circular dependency was detected
Hi Guys, I get the error A circular dependency was detected: ...Unanswered | 2 Replies | 73 Views | Created by J.Stoffels - Wednesday, June 21, 2017 7:46 AM | Last reply by willson yuan - Thursday, June 22, 2017 4:41 AM -
0 Votes
Power BI USERNAME() property not working in SharePoint online
Hi, I have developed a power BI report and published in SharePoint online publishing page. but power BI USERNAME() property is not returning office 365 logged in user ...Unanswered | 1 Replies | 118 Views | Created by SimhaVL - Saturday, June 17, 2017 11:50 AM | Last reply by willson yuan - Monday, June 19, 2017 4:19 AM -
0 Votes
how to take visuals for month wise cost
hi all, i have data from excel sheet as below: Server Name Financial ...Answered | 2 Replies | 115 Views | Created by LuckyLucky12 - Friday, June 16, 2017 8:17 AM | Last reply by willson yuan - Monday, June 19, 2017 1:58 AM -
1 Votes
Measure not summing in Pivot Table
I created a measure and when I went to drag it over to my Pivot table in the VALUES field all the numbers transferred over correctly but there was no grand sum. I'm looking for the sum of 310 + 929 to ...Answered | 13 Replies | 206 Views | Created by Hannah Hammeren - Tuesday, June 13, 2017 12:11 PM | Last reply by Darren Gosbell - Saturday, June 17, 2017 12:43 AM -
0 Votes
Values not showing for calculated fields in Power Pivot Manage window
After I have spent a few minutes (or sometimes as little as a few seconds) in the Power Pivot manage window, the values for my calculated fields disappear. The field names are still there, but I ...Unanswered | 4 Replies | 230 Views | Created by rtrenz2007 - Thursday, May 18, 2017 7:27 PM | Last reply by rtrenz2007 - Friday, June 16, 2017 2:08 PM -
0 Votes
DAX Formula for returning values between 2 date fields COUNT, COUNTIF, COUNTX?
30 days) or for those employees who have not started yet. So really I need to filter between two date values in the same table, and there are 2 important ...Proposed | 2 Replies | 131 Views | Created by tanheluk - Wednesday, June 14, 2017 1:19 PM | Last reply by willson yuan - Thursday, June 15, 2017 2:06 AM -
0 Votes
When looking for some specific registries I get "Object reference not set to an instance of an object"
Hi experts! I don't know why but there are some registries (from around 912k) that are present in the source but when I look for them inside the data model through power pivot I get ...Unanswered | 1 Replies | 124 Views | Created by gerotutu - Wednesday, June 14, 2017 4:39 AM | Last reply by willson yuan - Wednesday, June 14, 2017 7:26 AM -
0 Votes
DATESYTD Different behavior
HI, I have SALES table and a Calendar . they have a relationship. this formula works file: Total Sales YTD:=CALCULATE([Total Sales], ...Proposed | 4 Replies | 138 Views | Created by farshid mi - Tuesday, June 13, 2017 4:13 PM | Last reply by willson yuan - Wednesday, June 14, 2017 1:01 AM -
0 Votes
Return LAST DATE from table
Hi! I'm trying calculate the percentual change of a value by the value of the last date. In my table, there is a columns with the update date. I used LASTDATE, LASTNONBLANK and other, but i return ...Answered | 7 Replies | 242 Views | Created by Pietro Farias - Analista X - Thursday, June 08, 2017 1:07 PM | Last reply by Pietro Farias - Analista X - Tuesday, June 13, 2017 6:01 PM -
0 Votes
Reshaping the columns to rows using DAX in Power BI
Hi, I have imported a CSV dataset into Power BI with the following columns. KeyCol Col1 ...Answered | 2 Replies | 126 Views | Created by Parthiban Malan - Tuesday, June 13, 2017 7:00 AM | Last reply by Parthiban Malan - Tuesday, June 13, 2017 4:50 PM -
4 Votes
DAX for tabular Model
I need to do a distinct count based on 2 flags for example count(distinct customerID) where gender = M and age = 30Answered | 5 Replies | 837 Views | Created by Moyz Khan - Thursday, July 24, 2014 5:50 PM | Last reply by ABHISHEK PARIHAR - Tuesday, June 13, 2017 12:14 PM -
1 Votes
Write DAX expression for Creating measure in Tabular Model Power BI
Please help me how to write DAX code for creating measures for the below code also attaching expected result set . Select ...Answered | 3 Replies | 176 Views | Created by ABHISHEK PARIHAR - Thursday, June 08, 2017 2:47 PM | Last reply by Darren Gosbell - Tuesday, June 13, 2017 2:12 AM -
1 Votes
Teradata Query - Error 3932
I am new to Teradata, so I am trying to learn all its quirks. What I am trying to accomplish is write a temp table and then query off of it all in one statement. When I run the query below ...Proposed | 9 Replies | 656 Views | Created by Nunz2 - Monday, January 09, 2017 2:04 PM | Last reply by Darren Gosbell - Monday, June 12, 2017 11:30 PM -
0 Votes
How to numerate (index) successful transaction rows by AccountID and sorted by date
I have a table of transactions in each row. I want basically to numerate each * successtul transaction ([status]=approved) by * ...Answered | 7 Replies | 196 Views | Created by gerotutu - Sunday, June 11, 2017 10:49 PM | Last reply by gerotutu - Monday, June 12, 2017 10:42 PM -
1 Votes
Automatic Trimming in Import Procees (Linked Table)
Hello all! I just have a very simple question regarding data import. The problem is when I import a table from an Excel workbook which ...Answered | 2 Replies | 188 Views | Created by flavourabbit - Thursday, June 08, 2017 10:12 AM | Last reply by flavourabbit - Sunday, June 11, 2017 1:46 PM -
0 Votes
ExecuteReader requires an open and available Connection. The connection's current state is closed
With PowerPivot, we can import data from Physical SQL Tables in SANDBOX database. With PowerPivot, we can import data from Physical SQL Tables in SNAPSHOT ...Answered | 2 Replies | 3960 Views | Created by roel2000 - Tuesday, February 19, 2013 12:18 PM | Last reply by display name90210 - Sunday, June 11, 2017 3:58 AM -
0 Votes
I suddenly had problems with Powerpivot yesterday. Reinstalled Excel 2013 And now i cannot open my old models and the query editor has serious row limits. Queries that I was able to make models from yesterday are now tripping the row limit
II suddenly had problems with Powerpivot yesterday. Reinstalled Excel 2013 And now i cannot open my old models and the query editor has serious row limits. Queries that I was able to make ...Unanswered | 5 Replies | 260 Views | Created by Vinodh Raghunathan - Wednesday, May 17, 2017 4:18 PM | Last reply by Francisco X. Cruz - Thursday, June 08, 2017 3:35 PM - Items 1 to 20 of 4900 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.
