Using Excel Services, SharePoint users have been able to share workbooks that are connected to back end data since SharePoint 2007. Typically, the connection is made to SQL Server, or… Continue reading Schedule Data Refresh for SSAS Connected Excel Workbooks with PowerPivot for SharePoint
Results for "excel"
Power Pivot Updates to Excel 2013 – November 2013
Did you notice the update to Power Pivot in Excel 2013? Did you know that one was available? Neither did I until I heard about it 2 weeks ago. It… Continue reading Power Pivot Updates to Excel 2013 – November 2013
How To Load Data Directly Into the Excel (Power Pivot) Data Model
In a recent post, I discussed that while Power BI sites allow for data models up to 250 MB, the size of the worksheets portion of any workbook cannot exceed… Continue reading How To Load Data Directly Into the Excel (Power Pivot) Data Model
Using the new Excel 2013 Data Model with SharePoint
One of the biggest new features in Excel 2013 is the ability to import and analyze massive amounts of multi tabular data. However, it’s not really all that new –… Continue reading Using the new Excel 2013 Data Model with SharePoint
Connecting to Cubes and External Data with Excel in SharePoint
While many people are still unaware of it, Excel 2010 (and even previous versions) is a very powerful business intelligence client. That’s right, I said Excel. And I don’t mean… Continue reading Connecting to Cubes and External Data with Excel in SharePoint