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 | 5384 Views | Created by Avi Singh - PowerBIPro - Thursday, October 30, 2014 7:47 PM | Last reply by Ed Price - MSFT - Wednesday, February 4, 2015 7:50 PM
-
0 Votes
POWER BI using SOAP SERVICE
How to get data from Soap web service using POWER BI ? Please share any document or linkUnanswered | 2 Replies | 74 Views | Created by Haider Zia - Wednesday, October 17, 2018 7:52 AM | Last reply by Haider Zia - Friday, October 19, 2018 7:23 AM -
0 Votes
Adding new lines to the same table
I have been adding weekly sales data to a master sheet and created a pivot table from that. Recently I have hit the maximum allowed amount of rows. I was told that PowerPivot has a much higher ...Unanswered | 1 Replies | 105 Views | Created by Xzyleth - Thursday, October 18, 2018 8:10 PM | Last reply by Darren Gosbell - Friday, October 19, 2018 1:24 AM -
1 Votes
Power Query - Create a list of Months
Hi All, I need to create a date dimension where the lowest level is month. I've seen examples which use the list function such as Source = ...Answered | 3 Replies | 1876 Views | Created by Shiangoli - Tuesday, July 21, 2015 10:11 PM | Last reply by Peter Giesselink - Tuesday, October 16, 2018 4:03 PM -
0 Votes
Slicers from multiple dimension tables - How to dynamically propagate selection to other slicer?
I am completely stuck with the following problem and found nothing about this special issue on the web so far. (Nevertheless I found and read a lot about contexts, relationships, ... -
0 Votes
How to deploy Power BI Report Server without Service account/Active Directory?
I need to deploy PowerBI report server (Oct 2018) in a production environment using 2 servers, the first server is for power BI report server (Web server) and the second server will host ... -
0 Votes
Why do my Excel PivotTable Fields GUI show in Row format in some workbooks and are not "Stacked" as normal Format?
The normal layout in the PivotTable Fields GUI looks like this: Ever so often, my PivotTable Fields get "unstacked" and show up in a ...Unanswered | 1 Replies | 176 Views | Created by jbt_PwrPvt - Thursday, September 27, 2018 2:06 PM | Last reply by jbt_PwrPvt - Thursday, October 11, 2018 4:12 PM -
3 Votes
PowerPivot Relationship Not Working
I have one table that is called policy, in my relationship PolicyLink is my primary key my second table is called Car. As you can see PolicyLink is used twice ...Answered | 15 Replies | 23688 Views | Created by amotto11 - Friday, August 19, 2011 3:05 PM | Last reply by DavoPaulo - Wednesday, October 10, 2018 9:03 PM -
1 Votes
How do i multiply a column of numbers by a constant??
This seems so simple yet I am struggling to figure it out. I have a parameter entered to worksheet and uploaded as 'drilled' table with a number eg ".1" called ...Answered | 2 Replies | 128 Views | Created by R0BW - Wednesday, October 10, 2018 2:34 AM | Last reply by R0BW - Wednesday, October 10, 2018 5:56 AM -
0 Votes
Measure to calculate proportion of group total
I have the following workbook structure - - power queries to data cube from ERP for both look up tables and time records, filtered for current ... -
0 Votes
MAX with FILTER
=[QCStart]),filter('AD Visit','AD Visit'[Completed on]Unanswered | 1 Replies | 125 Views | Created by RousAssoc - Monday, October 8, 2018 9:15 AM | Last reply by Herbert Seidenberg - Monday, October 8, 2018 6:36 PM -
0 Votes
Export table data to excel with format intact
Hi PowerBi Users, We have a necessity for venture we are right now taking a shot at. There are reports in PowerBI which ... -
0 Votes
POWER PIVOT - DAX - COUNT DUPLICATE VALUES WHICH APPEAR IN CONSECUTIVE MONTHS
I. QUESTION I am looking for a DAX formula that return me the number of ID which appear in 2,3,4......consecutive months ID 1st ...Unanswered | 5 Replies | 362 Views | Created by Nguyen Dai Thang - Tuesday, September 11, 2018 5:11 PM | Last reply by Nick Chobotar - Sunday, October 7, 2018 7:17 AM -
0 Votes
Who will be announced as the next Power Pivot Guru? Read more about October 2018 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. ... -
0 Votes
Use relatedtable funtion in an IF statement
I have created two linked tables (table 1) and (table 2) in power pivot and created a relationship between the columns "Account Name" found in table 1 and table 2. I need ... -
0 Votes
Power pivot using power queries not refreshing properly for linked tables - possibly due to linking or data type format
OK, so I read the "how to ask a question"; hopefully there's sufficient info here. On a company maintained version of Excel 2016, I have the following ...Answered | 1 Replies | 150 Views | Created by R0BW - Wednesday, October 3, 2018 5:29 AM | Last reply by R0BW - Thursday, October 4, 2018 12:27 AM -
0 Votes
Calculating Sales by Customer by Range of Values
Hello, I have a revenue grouping in my data model that classifies sales into different buckets, for example: $100 - $200 $201 - ... -
0 Votes
Power Query Error in Excel - Object reference not set to an instance of an object??
I am getting an error when I go to Power Query in Excel and try to connect to a new SQL data source. I have already tried to repair and uninstall/reinstall excel but still getting an error. ...Unanswered | 0 Replies | 114 Views | Created by tbuckingham2018 - Wednesday, October 3, 2018 4:10 PM -
1 Votes
Sumifs equivalent for power pivot table
We have a project financial report using power pivot table with data model, and power query to a GL cube. The report is a income and expenses statement showing YTD actual, ...Answered | 2 Replies | 218 Views | Created by R0BW - Friday, September 28, 2018 2:07 AM | Last reply by R0BW - Tuesday, October 2, 2018 3:52 AM -
0 Votes
DAX formula (Calculated Column) for same Value Sequential Numbering
= Query[RID]) The expression is based on expression found in this forum, but not working at all for my data. They were trying to achieve the same sequence numbering but ...Unanswered | 4 Replies | 262 Views | Created by roncruiser - Friday, September 28, 2018 6:07 PM | Last reply by roncruiser - Monday, October 1, 2018 9:41 PM -
0 Votes
DAX filter a column value in a table based on date (current day and previous day)
Hi, I have a table,TestScores, that contains 2 columns (1) DateID (2) TestID there is another table,Calendar, which contains (1) DateID and other date related columns. The two ...Unanswered | 1 Replies | 227 Views | Created by vidsaf - Friday, September 21, 2018 10:59 PM | Last reply by Herbert Seidenberg - Thursday, September 27, 2018 1:45 AM - Items 1 to 20 of 5343 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.
