| Data refresh from PowerPivot |
| Written by Christopher R Hopkins |
| Thursday, 25 August 2011 22:32 |
|
In a series of articles I explored the different scenarios around SQL and data refresh. One of the scenarios that I have not covered is how to create a data refreshable diagram from Analysis Services. If you do not already know this, Visio and Visio Services cannot refresh directly from Analysis Services, however we could use PowerPivot as a middle man. Imagine a scenario. where the Visio diagram is data connected to a pivot table in an Excel workbook and the data for that pivot table is refreshed on a schedule by PowerPivot's data refresh feature in SharePoint 2010. Visio Services supports refreshing data from Excel Services so as long as PowerPivot's data refresh schedule is configured our diagrams will stay up to date. Read more... |
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
