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 VotesDAX not performing short-circuit evaluations for the IF function
0). In this case the 1 should be returned and the else expression should not be evaluated. The else expression when executed on its own takes about 20 seconds. The query below is ...Answered | 5 Replies | 3039 Views | Created by rthar - Thursday, September 5, 2013 11:15 PM | Last reply by JJ78 - Wednesday, July 1, 2020 10:45 AM
-
1 Votes
Power Pivot doesn't regonize sources any longer
Hi I have set up a data model that collects data from several flat files (.csv files). It has been working for several months - latest at the beginning of June. ...Unanswered | 9 Replies | 431 Views | Created by JørgenLauridsen - Monday, June 29, 2020 1:15 PM | Last reply by JørgenLauridsen - Wednesday, July 1, 2020 6:31 AM -
3 Votes
Customizing a PowerPivot slices - PowerPivot v2
Hi, in a my workbook I'm trying to customize a slicer. I select the pivot table created and then I select the slicer to show the related properties. So I try to change the size of ...Answered | 15 Replies | 7004 Views | Created by pscorca - Tuesday, June 26, 2012 8:59 PM | Last reply by greta2020 - Monday, June 22, 2020 12:53 AM -
1 Votes
Conditional SUM ISBLANK
Hi, I am getting the data model using a mssql query, if an invoice is canceled the "Estatus" column has the word "Canceled" if not, the column is empty. I am ...Answered | 6 Replies | 775 Views | Created by jparada - Friday, June 19, 2020 5:50 PM | Last reply by jparada - Sunday, June 21, 2020 4:58 AM -
0 Votes
Error Code : 0Xc004f012 again
I was using my computer its reset after I'm assuming an update and its asking me to "Activate Windows" which I attempt to only to be met with the above error ...Unanswered | 1 Replies | 421 Views | Created by متجر نايف - Saturday, June 20, 2020 12:32 PM | Last reply by AV111 - Saturday, June 20, 2020 12:50 PM -
0 Votes
Consecutive loss
I’m trying to calculate the quantity of consecutive loss per hour group, per day, and the max consecutive loss per hour group. I have tried to adapt some formulas for ...Unanswered | 3 Replies | 759 Views | Created by MarceloPenner - Friday, June 5, 2020 3:51 PM | Last reply by Herbert Seidenberg - Wednesday, June 17, 2020 2:50 AM -
0 Votes
Power Apps and MS Teams Assignments
Quick question-- Please I'm a teacher trying to sell my department on moving to MS Teams and using the assignments app. Currently the app offers a minimal CSV export which has to be ... -
0 Votes
Excel PowerPivot Table Import Wizard suddenly not recognizing delimiters
I have been using Power Pivot Table Import Wizard to import a pipe delineated file of almost 2 million rows successfully for weeks. Now when I load the same file, all ...Unanswered | 2 Replies | 756 Views | Created by JGPHFL - Saturday, May 23, 2020 12:31 PM | Last reply by JGPHFL - Wednesday, June 3, 2020 11:57 PM -
0 Votes
Grouping Dates
I am attempting to group by date in Power Pivot. I did not add my data range to the Data Model, but the group function is not available. I'm not getting an error message, I just can't select the Group ... -
0 Votes
Like for Like Same Store Sales
Hi, Can anyone could help me? I want to calculate total Revenue for Same Stores. Requirement is that if it is filtered date from 05/01/2020 to 05/19/20 then it must ...Unanswered | 1 Replies | 840 Views | Created by Eldaniz Bayramov - Tuesday, May 19, 2020 4:54 PM | Last reply by Herbert Seidenberg - Wednesday, May 20, 2020 12:50 AM -
0 Votes
Powerpivot Problem
Hello, I prepared an SSAS cube, the indicators are attributes in a column "Element Short Desc" of the dimension table "Capacity Plan Measure" which contains ... -
0 Votes
Sorry, PowerPivot can't open the Data Model because there was a COM exception while opening. You might be opening a workbook on a corrupt installation of Excel. Click Detail for more information.
I've recently upgraded from Excel 2010 to Excel 2016. I can no longer properly use PowerPivot. I've even had my organization's IT uninstall and reinstall Excel and didn't work. They then gave me a ...Answered | 1 Replies | 1263 Views | Created by Javeeee - Monday, February 10, 2020 8:13 PM | Last reply by D. Wieck - Wednesday, May 13, 2020 12:48 PM -
0 Votes
Power BI for Mac user
Just would like to know if we use Mac PC , how can we use Power BI ? is any solution for Mac user ? ThanksUnanswered | 7 Replies | 951 Views | Created by Derek Chan 456 - Tuesday, May 12, 2020 3:02 AM | Last reply by Akshay M - Wednesday, May 13, 2020 10:46 AM -
0 Votes
PowerPivot is unable to load the Data Model
Manage on the Ribbon. Please let me know if additional information is needed to help resolve my issue. Thank you.Unanswered | 1 Replies | 776 Views | Created by LadyJez - Thursday, May 7, 2020 5:06 PM | Last reply by Olaf Helper - Friday, May 8, 2020 7:11 AM -
0 Votes
How to connect to 2 different data sources from Power BI
HI ALL, is it possible to connect to 2 different data sources from Power BI Desktop at the same time to design one report? I have 2 different data sources ( SQL ...Answered | 1 Replies | 816 Views | Created by ScriptSoft - Monday, May 4, 2020 1:08 PM | Last reply by Olaf Helper - Monday, May 4, 2020 1:17 PM -
0 Votes
connect PowerPivot Excel 365 to SQL2008 (non R2) database
Hi there , With one customer we ran into issues with Excel 365 connecting to MS Cubes on a SQL2008 instance. We noticed that this instance is the first version ...Unanswered | 4 Replies | 1106 Views | Created by tiesblom - Wednesday, April 29, 2020 3:29 PM | Last reply by tiesblom - Thursday, April 30, 2020 1:46 PM -
0 Votes
PowerBI connection to RDS PostgreSQL
Our enterprise reporting tool is PowerBI, we are in the process of moving much of our on prem SQL DB's to Aurora PostGreSQL. We have a need to connect to these DB's through PowerBI but there is ...Unanswered | 1 Replies | 860 Views | Created by CampCricket - Tuesday, April 28, 2020 6:00 PM | Last reply by Tom Phillips - Tuesday, April 28, 2020 6:06 PM -
0 Votes
Drag and drop feature on Power BI dashboard
Wonder, what can I do for a requirement for an end user to have a facility to drag and drop on a dashboard. Any suggestions are appreciated.Unanswered | 1 Replies | 930 Views | Created by Anu9123 - Sunday, April 26, 2020 11:28 AM | Last reply by Darren Gosbell - Sunday, April 26, 2020 10:41 PM -
0 Votes
dax table expression addcolumns - row - summarize - calculate with filter in ??
I'm having trouble with the follow dax expressions that is part of a dax created table . When I run it as is it says there is a row expects column in position 5. I've tried a number of ...Unanswered | 1 Replies | 1166 Views | Created by Bill St123 - Tuesday, April 21, 2020 7:13 PM | Last reply by Herbert Seidenberg - Friday, April 24, 2020 1:29 AM -
0 Votes
dates won't sort in my PivotTable because excel believes they are text
I can't get my dates to sort in my PivotTable because excel believes they are text. When I try to use the "text to columns" button I get an error message that the changes can't be made ...Answered | 2 Replies | 1069 Views | Created by WillLog - Thursday, April 23, 2020 3:07 AM | Last reply by Herbert Seidenberg - Thursday, April 23, 2020 2:57 PM - Items 1 to 20 of 5669 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.
