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.
-
0 VotesDuration problem (gap)
(True/False or 1/0) - Site ==> There are many sites. Here I show you only one for a better and simple visualization The duration (Durée) ...Unanswered | 5 Replies | 218 Views | Created by CalloudB - Wednesday, January 22, 2020 2:16 PM | Last reply by CalloudB - 47 minutes ago
-
0 Votes
Creating Azure pipelines(source control using GIT hub) for Power BI.
Hi, I am trying to set up a new Azure devops pipeline and integrate it with git hub for allowing source/version control for power bi files. Please could you ...Unanswered | 1 Replies | 43 Views | Created by Nigs_2019 - 7 hours 36 minutes ago | Last reply by Vaibhav.Chaudhari - 2 hours 59 minutes ago -
0 Votes
SAMEPERIODLASTYEAR - How to disallow filters on several YEARS
Hi, I have report showing sales numbers and Im using formula SAMEPERIODLASTYEAR. In the date slicer in Excel the users can choose dates with overlapping years, and then the ...Unanswered | 1 Replies | 121 Views | Created by Kjetil Sandvik - Wednesday, January 22, 2020 10:58 AM | Last reply by Herbert Seidenberg - Monday, January 27, 2020 12:32 AM -
0 Votes
DAX Formula for Percent Of Total that will work on Employee's AND the grand total.
Hi all, I am working on a DAX problem that someone may be able to help me with. I have a Total Hours measure: Total ...Unanswered | 4 Replies | 540 Views | Created by jbt_PwrPvt - Tuesday, January 14, 2020 8:39 PM | Last reply by jbt_PwrPvt - Sunday, January 26, 2020 10:06 PM -
0 Votes
Core and thin workbooks in PowerPivot
I have a PowerPivot model and need to create some core and thin workbooks to distribute to approximately 100 report users, with sensitive information that each other cannot see. My ...Unanswered | 0 Replies | 116 Views | Created by burning_tanzanite - Saturday, January 25, 2020 2:30 AM -
0 Votes
DAX measure to count distinct dates between date ranges over multiple rows
Hi everyone, I need to create a DAX measure that counts distinct dates between start and end date ranges across multiple ...Unanswered | 2 Replies | 120 Views | Created by ryan25r9 - Thursday, January 23, 2020 4:49 PM | Last reply by Herbert Seidenberg - Friday, January 24, 2020 5:24 AM -
0 Votes
Question about value (measure) filters on a pivot table from power pivot data model
<article class="message-body js-selectToQuote" style="box-sizing:border-box;margin:10px 0px 0px;"> I'm looking for advice on how to do what I'm trying to ... -
0 Votes
powerbi change the color of measure
1 - RED Thanks in advance Hi ...Answered | 1 Replies | 207 Views | Created by help.me.please - Thursday, January 16, 2020 11:39 AM | Last reply by Vaibhav.Chaudhari - Thursday, January 16, 2020 11:53 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 | 4 Replies | 4538 Views | Created by Shiangoli - Tuesday, July 21, 2015 10:11 PM | Last reply by Vaclav SeaBass Muchna - Tuesday, January 14, 2020 10:14 AM -
0 Votes
Pivot Table not showing data fields on data fields list
Good morning Everyone I have the following issue. I am creating a pivot table as I usually do but this time there is no fields to drag on the fields list box. ... -
0 Votes
Cannot add to Data Model anymore!
Hi, I am sure I am not the only one coz I see this problem (issue) in many forum. If I load a table to PowerQuery then massage the data a bit (I tested it with a 5 rows table.) then ... -
0 Votes
sameperiodlast year not working
I have the measure: prior = CALCULATE(sum('fact'[01valuefield]),SAMEPERIODLASTYEAR('Date'[Solar_Date]), ALLEXCEPT('Date','Date'[Solar_Date]) ...Answered | 1 Replies | 287 Views | Created by berli - Monday, January 6, 2020 8:34 AM | Last reply by berli - Thursday, January 9, 2020 3:43 PM -
0 Votes
percentages
i have a matrix whose rows are site and some demographic (age, sex, country,...) columns are a set of year (2017,018,2019...) the ...Answered | 1 Replies | 356 Views | Created by berli - Sunday, January 5, 2020 1:37 PM | Last reply by berli - Wednesday, January 8, 2020 2:03 PM -
0 Votes
Unichar - Green Light - PowerBI
Hi Please advise , how to I get the "GreenLight" Unicar in Power BI 2017 I tried to using the below unichar code, unfortuneltay not giving me ...Answered | 1 Replies | 263 Views | Created by help.me.please - Tuesday, January 7, 2020 11:23 AM | Last reply by Darren Gosbell - Tuesday, January 7, 2020 9:27 PM -
0 Votes
Column in Power bi - dax not working -Column = IF(test[Variance]>=0.00 , "No-deviation" ,"Deviation")
=0.00 , "No-deviation" ,"Deviation") -
0 Votes
Data Model does not refresh data
Hello all, I have been looking for a solution quite some time now and was not able to find a solution unfortunately. Following issue: I created ... -
0 Votes
DISTINCT COUNT THEN MULTIPLY WITH RELATED VALUE
Hi All, how can i do this in dax? "=COUNTIFS(M37_LABOR.xlsb!M_37[CONCATENATED],C5)*INDEX(M61DASH.xlsb!M_61[Estimated Working ... -
0 Votes
Do you want to be acknowledged as Microsoft SQL Server? Submit your work to January 2020 competition!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles ... -
0 Votes
Do you want to be acknowledged as Microsoft Power Pivot Guru? Submit your work to January 2020 competition!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles ... -
3 Votes
Concatenating multiple rows in one row with a delimiter
Hi, I am fairly new to DAX. Unable to figure out an approach to achieve the concatenation of row value with a delimiter For ...Answered | 10 Replies | 4007 Views | Created by Abhi1318 - Tuesday, February 27, 2018 2:03 PM | Last reply by Lpetty - Tuesday, December 31, 2019 1:03 AM - Items 1 to 20 of 5623 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.
