#PowerPivot Data Refresh SSRS Report

As many of you already know, in order to figure out which workbooks had succeeded or failed execute in their data refresh, you need only to go the PowerPivot Management Dashboard (Central Administration > General Application Settings > PowerPivot Management Dashboard) in order to see the status of your data refresh as noted in the figure below. Figure 1: PowerPivot Management Dashboard: Data Refresh Web Parts   But how about if you wanted to create a SSRS report of the same (or even more) information so that way you can create alerts and/or have an atom feed of this information? …

Rate this:

What happens when you run a Data Refresh within #PowerPivot for SharePoint?

I was just recently asked the question by a fellow Analysis Services expert (Greg Galloway): When you have SharePoint automate a data refresh for a PowerPivot workbook, is the new data saved back into the xlsx? So if I download the xlsx onto my laptop the next day, will I see fresh data? Also, if the xlsx is updated by SharePoint during data refresh, is that step subject to the 2GB file limit? and I thought it made sense if that we share this answer as well. So the answer is “Yes”. … Details you ask? Okay, here are the…

Rate this: