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 VotesText Field Truncation for Some Columns in Power Pivot for Excel
I am importing an Excel file (.xlsx) straight into Power Pivot for Excel. The file is largely text. Some columns are being cut off at 255 characters but other columns are being brought ...
-
0 Votes
Getting details from Excel
Sorry, guys, you have been very helpful before, and I need help again! I have a series of worksheets in an Excel workbook, let us all them SheetA, SheetB, SheetC ...Unanswered | 2 Replies | 876 Views | Created by MaBacc - Wednesday, December 5, 2018 11:09 AM | Last reply by geraldartman - Thursday, May 16, 2019 5:25 PM -
0 Votes
"syntax for '(' is incorrect" trying to use CALCULATE function in Excel 2010
I am using PowerPivot 2012 for Excel version 11.1.3129.0 within Excel 2010 within my new job and am used to using it in newer versions of Excel. I am getting an error ...Unanswered | 1 Replies | 113 Views | Created by BBRedStang - Wednesday, May 15, 2019 4:01 PM | Last reply by Olaf Helper - Thursday, May 16, 2019 6:53 AM -
0 Votes
Quick (simple for you likely) Q on DAX table data - greyed out
For some of the tabs some of the data columns are greyed out (even though they do have data in them). Is this perhaps b/e there is no current live data source link (I just ...Answered | 1 Replies | 156 Views | Created by HubbaBuba2 - Tuesday, May 14, 2019 10:42 PM | Last reply by HubbaBuba2 - Tuesday, May 14, 2019 11:51 PM -
0 Votes
COmparing two year in a chart from one table
I have a table with dates from 2013 throughout 2014. I would like to make a chart displaying the sales per month for the different years. So two lines for each year, following the months on the x-axis ...Unanswered | 1 Replies | 247 Views | Created by MiriamMal - Saturday, May 11, 2019 3:23 PM | Last reply by Aleksei Zhigulin - Tuesday, May 14, 2019 4:49 PM -
0 Votes
Error upgrading PP from 2010 to 2013
Hi all, I try to update my PP model from 2010 to Excel 2013 but I have the following error. I don't know what to do. Please ...Unanswered | 1 Replies | 768 Views | Created by Clemsdean - Tuesday, April 9, 2019 5:09 PM | Last reply by Clemsdean - Tuesday, May 14, 2019 4:39 PM -
0 Votes
Power BI - DrillThrough not visible on chart as option to select
Hi I am using Power BI April 2019 Desktop and would like to use drillthrough option which seemingly not visible on a chart to select. It is ...Unanswered | 1 Replies | 313 Views | Created by VilenVmo - Thursday, April 25, 2019 7:41 AM | Last reply by Samuel Lester - MSFT - Tuesday, May 14, 2019 4:23 PM -
0 Votes
Measure that will keep column values in table and ignore any filters in that table.
I'm just trying create a measure that will keep showing all values even when a filters is applied on my 'Hierarchy Table'. What am I doing wrong ...Unanswered | 1 Replies | 241 Views | Created by anthonjhnon1 - Wednesday, May 8, 2019 11:15 PM | Last reply by Darren Gosbell - Thursday, May 9, 2019 1:49 AM -
0 Votes
Unexpected Error in xmvsquery.cpp, XMVSXJoin::BuildRelationships
Problem 1: Anything seems to be wrong when refreshing the data after adding the calculated column... Next Problem: I add another CalculatedColum in Table ...Answered | 7 Replies | 1086 Views | Created by Holger Gu - Wednesday, March 29, 2017 7:31 AM | Last reply by Holger Gu - Wednesday, May 8, 2019 8:04 AM -
0 Votes
PowerBI - SQL Queries for Dates
Hi guys, First time poster! We've just connected ServiceNow to PowerBI via an ODBC. As the database in SNOW is quite immense, I was ...Unanswered | 4 Replies | 243 Views | Created by MSham - Tuesday, May 7, 2019 4:45 AM | Last reply by MSham - Wednesday, May 8, 2019 2:15 AM -
0 Votes
How to change Date formats in Power Query/ Power BI?
Hi, I have three date columns in my Power BI data model. All are in dd-mm-yyyy or dd-mmm-yyyy formats, but I want to change them in to any format I want (i.e. ...Unanswered | 3 Replies | 261 Views | Created by Arjun M Shetty - Monday, May 6, 2019 1:36 PM | Last reply by Aleksei Zhigulin - Tuesday, May 7, 2019 8:28 AM -
0 Votes
Created Calculated Column based on a string of relationships
Hi, I want to create a calculated column called Division Name in my Booking table. I need the Division Name to appear in this table for reasons that would take a while to ...Unanswered | 1 Replies | 209 Views | Created by ChuWil2 - Monday, May 6, 2019 3:08 PM | Last reply by Darren Gosbell - Tuesday, May 7, 2019 12:07 AM -
0 Votes
DAX: Strange error indicator
In this line... VAR ColumnOfMonths = DISTINCT(SELECTCOLUMNS(TableOfDays,"Months",Dates[Calendar Date for Months])) ...the DAX Measure editor displays ... -
0 Votes
Power Pivot Measure not calculating correctly, please help
Hello and thank you in advance if you can help, I am using Excel 2019 on a PC desktop. I have created measures that divides one previously calculated measure by another ... -
2 Votes
Who will be announced as the next SQL Server Power Pivot Guru? Read more about May 2019 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. This is ... -
0 Votes
measure in power bi dax
i am trying this but this shows an error kindly check attached pbix file fileUnanswered | 0 Replies | 243 Views | Created by rebmaamberrebmaamber - Tuesday, April 30, 2019 12:05 PM -
0 Votes
Dates and using COUNTAX with two filters
30),[LastUpdateDays]) However, when I attempt to add another filter (ACTIVE) I am not getting the results I should OverTimeCountx = CALCULATE(COUNT('PROJECT ...Unanswered | 1 Replies | 296 Views | Created by JamesLNeal - Friday, April 26, 2019 12:29 PM | Last reply by Herbert Seidenberg - Tuesday, April 30, 2019 3:40 AM -
0 Votes
RFM Ranking of customers or how to create equally sized quintiles, sorted by second variable?
I have a database of customers. Customer id, frequency and recency. Table looks like this. Frequency and Recency are calculated ... -
0 Votes
Need help converting index match formula into powerbi calculated field
Hi Power Users, I have a excel formula that does what i need , but now to translate that to work in Power Bi has been a nightmare. I ...Unanswered | 1 Replies | 363 Views | Created by MemOez - Wednesday, April 24, 2019 8:13 AM | Last reply by Herbert Seidenberg - Sunday, April 28, 2019 4:01 AM -
0 Votes
Slicer font resizes when printing
Hello, My company had a power pivot document that was being used in excel 2010. However, the company upgraded to 2016 and that means that the document needed to as well. ... - Items 1 to 20 of 5490 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.
