InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 12:56:28 GMT20http://www.sqlservercentral.com/Forums/Topic1306050-3053-1.aspxI'm still trying to wrap my brain around some Power Pivot issues. If I have a Power Pivot set up against a SHARED odc connection (in the shared data sources folder in Sharepoint & configured properly, as far as I can tell) that points to a multi-dimensional SSAS cube, what is the expected behavior when I refresh (or even re-build) that cube? My understanding is the ODC is merely a pointer. Provided the changes to the cube don't affect security, it shouldn't need to be re-built, should it? What should happen if I'm re-building the cube at the moment someone runs/refreshes a Power Pivot workbook using that cube as a back-end? I'm trying to troubleshoot some nasty errors.Thu, 24 May 2012 12:20:39 GMTlduvallhttp://www.sqlservercentral.com/Forums/Topic1295737-3053-1.aspxScenario:I have a working sql query based excel report AND I have new data that I need to bring into the query which resides exclusively on an excel spreadsheet. I cannot (due to permission restrictions) create a new table in SQL Server and I can't store the excel datasource on the same server as the SQL Server instance (therefore, linked server option isn't viable) and I do not have bulkload permissions on SQL server so can't bulkload date from .csv file and I do not have permissions to reconfigure the instance for ad hoc queries (therefore Select * from OPENDATASOURCE is also not viable).Does anyone know if it is possible for a query based excel report to join on a table defined exclusively in PowerPivot Excel workspace?Sun, 06 May 2012 16:14:38 GMTpolkadothttp://www.sqlservercentral.com/Forums/Topic1249529-3053-1.aspxHi I'm wondering what I'm missing.I'm working through a text book example of RELATED function usage. The tables across which I am implementing have a relationship, yet within the table where I've created the related column, no data is coming over.Sorry to be so general, but it there doesn't seem like there should be anything to this problem, yet the data won't populate the column. What should I be checking for besides an existing relationship between the two tables that pertain to the function?Thu, 09 Feb 2012 01:40:06 GMTxenophiliahttp://www.sqlservercentral.com/Forums/Topic1208528-3053-1.aspxHow do I get rid of the automaticly showing measure in the excel/powerpivot pivottable fieldlist?"Values"___Count of ModelsMy customer doesn't want it there.Edit: Oh, forgot to mention, it's 2012/Denali CTP3.Fri, 18 Nov 2011 10:27:01 GMTJonas Bergströmhttp://www.sqlservercentral.com/Forums/Topic1206171-3053-1.aspxI was looking forward to play with this (new) toy but can't get anything working...I have installed - Office 2010 with Excel 32 bits- Sql Server 2008 R2- PowerPivot 10.50.2500.0 (the one coming with 2008R2 I think)- Sql Denali ctp3When I try to open the "PowerPivot Window" on a brand new spreadsheet, I get various error messages:- Embedded Analysis Services Engine: Could not open embedded PowerPivot data. (twice)- Then an option to "Do Nothing" or "remove the PowerPivot data"Finally, I get an error message "Unable to load the Vertipaq Engine".Any idea what I could do to fix this?Should I install PowerPivot from Denali CTP3 instead of 2008R2?I have already tried - uninstal PowerPivot- reboot- re-install PowerPivotBut no joy so far...Any idea welcome! :-)Tue, 15 Nov 2011 10:25:56 GMTEric Mamethttp://www.sqlservercentral.com/Forums/Topic1206520-3053-1.aspxNormal excel pivot tables allow the user to double-click a datum to extract the underlying data into a new worksheet. Is this available in Powerpivot at all?Wed, 16 Nov 2011 03:46:53 GMTUlysses_Infinity