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 VotesA way to let users create report, but don't see or edit other's
Hi People! Is there a way in Power BI in a specific WorkSpace to let users create reports, but not to see or edit other's people reports?Unanswered | 1 Replies | 46 Views | Created by ThomasYaris30 - 20 hours 25 minutes ago | Last reply by Darren Gosbell - 12 hours 32 minutes ago
-
0 Votes
PowerPivot IF Statements
Hi, I'm new to PowerPivot. I understand the syntax is different than a regular excel formula. Was hoping I could get some help with an IF statement. Here is my formula in excel, which works just ...Unanswered | 1 Replies | 116 Views | Created by aj0702 - Sunday, February 23, 2020 10:32 PM | Last reply by RB Robert Brooks - 17 hours 20 minutes ago -
0 Votes
Data Model Calendar has Fiscal Month field, but display Month name
I was using a shortcut involving TOTALYTD to sort my pivot table by Fiscal Month, but I noticed this caused some issues when trying to drill down. I added a column to the Calendar date table in ... -
0 Votes
Measures not selecting correct data, then Pivot Table displaying Sub Totals that ignore filter
I'm going to try to be descriptive and describe this issue in order, but I know I'm going to leave something out no matter. This is the input file. There is an Out Date ...Answered | 1 Replies | 124 Views | Created by RB Robert Brooks - Wednesday, February 19, 2020 3:35 PM | Last reply by RB Robert Brooks - Wednesday, February 19, 2020 4:24 PM -
0 Votes
related table not working
I have the following relationships: dimdata - factsubset - dimsite and dimdata - allfact - dimsite dim data has key data in a 1-N relationship active with both factsubset and ... -
1 Votes
DAX Formula filter propagation elementary question
This should be a simple question because I am new to DAX and PowerPivot. I was using the AdventureWorks 2017 sample database and wanted to show my current employer some of the analytical ...Answered | 2 Replies | 332 Views | Created by RB Robert Brooks - Wednesday, February 12, 2020 3:27 PM | Last reply by RB Robert Brooks - Thursday, February 13, 2020 1:22 PM -
0 Votes
DAX Formula filter propagation elementary question
I'm relatively new to this and thought I understood how filter propagation works, but when I tried to do a simple count of number of employees on this sample AdventureWorks2017 HR database after ...Unanswered | 2 Replies | 187 Views | Created by RB Robert Brooks - Tuesday, February 11, 2020 1:38 PM | Last reply by RB Robert Brooks - Tuesday, February 11, 2020 6:49 PM -
0 Votes
Slow Power BI Report
We are trying to run basic ssrs paginated reports on power bi on-prem report server but experiencing inconsistent performance issues when executing the reports with concurrent users. The report has ... -
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 ... -
0 Votes
VBA code to paste data from a Pivot Table built from a Data Model
Hi, I have a Pivot Table built from a Data Model. This Pivot Table has a Year and a Month Name field in the row labels and a host of others as well. My requirement is to ... -
0 Votes
Power BI Embedded Control
Using Power BI Embedded, is it possible to make the report interact with the rest of the page it is embedded into? For example: is it possible to change the ... -
0 Votes
Change source for a table contained in the main file without recreating DAX formulas
HI, I have a table included in the main file where all power pivots are built. Id like to take it out and start soucing the data from an external source in excel. This table can get ... -
0 Votes
Combine files attributes with file content
I need to combine the files attributes loaded from a folder with the its content. How can I do it?Unanswered | 1 Replies | 335 Views | Created by Anderson Szreider - Thursday, January 30, 2020 8:03 PM | Last reply by Olaf Helper - Friday, January 31, 2020 7:07 AM -
0 Votes
Duration 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) ...Answered | 9 Replies | 765 Views | Created by CalloudB - Wednesday, January 22, 2020 2:16 PM | Last reply by CalloudB - Thursday, January 30, 2020 3:20 PM -
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 | 357 Views | Created by Nigs_2019 - Tuesday, January 28, 2020 1:07 AM | Last reply by Vaibhav.Chaudhari - Tuesday, January 28, 2020 5:44 AM -
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 | 404 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 | 848 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 | 346 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 | 443 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 ... - Items 1 to 20 of 5636 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.
