THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a data mangler in London working for Dunnhumby

Power View in SkyDrive revisited


Three days ago I wrote a rather scathing blog post Power View in SkyDrive where I criticised Microsoft’s collaboration story in Excel 2013 in its various guises. I said then:

I clicked on one of those workbooks in order to view it in my web browser and I saw this:


“Unable to load the requested workbook”

Oh, did they forget to tell you? Workbooks containing Power View reports cannot actually be viewed on SkyDrive

Well, it transpires that something has changed in the interim because I tried it out this morning and saw this:


OK, I still can’t see the Power View report but nonetheless at  least it gives me an explanation this time and I am assuming that did the data connections not have to be refreshed then this would work – that’s better news (I’m still confused as to why an inability to refresh connections prevents me from seeing the Power View report given that some data does already exist in the workbook, let’s save that whinge for another day). At least I am seeing something informative and there is an image that alludes to the existence of Power View. One important point; the above screen, even though it does not show anything useful, still requires SilverLight and that is not a surprise to me.

I must stress that I have not done anything different today from what I did three days ago, I simply clicked on the workbook within SkyDrive (it behaves the same on both IE & Chrome by the way). So, either they’ve updated the web app on SkyDrive or three days ago there was a temporary glitch.

OK, so we have some progress. I’ll continue investigating and if I find anything out I shall post it here.


Published Thursday, August 2, 2012 9:45 AM by jamiet
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



jbooker said:

Hi Jamie,

First is without preview enabled, second is with preview enabled.  Notice the 'metro-style' branding on the latter.

You can switch back and forth here:


August 2, 2012 10:51 AM

poem said:

Hi Jamie, I assume that the data behind the Power View Report resides in PowerPivot. As you probably know PowerPivot is fully In-Memory and therefore it is understandable that PowerPivot is not supported in SkyDrive and therefore the Report cant't refresh/Display the data. The MS Datacenter would need tons of Memory if everybody could load up and view PowerPivot based Reports... (which bis the case for Power View Reports) Maybe MS is planning to support this in the near future as it looks like that Power View is already enabled. Anyhow - I assume we will see some strict limitations in terms of the PowerPivot model size - otherwise it will blow up the datacenter.

August 13, 2012 4:38 AM

JPerry said:

According to this microsoft link for whats new in excel 2013 power view will not be supported by sky drive.

When you create Power View sheets in Excel, you can view and interact with them on-premises in Excel Services, and in Office 365. You can only edit Power View sheets in Excel 2013 on a client computer.

On-premises, Power View isn’t supported on Excel Web App. In Office 2013, administrators can choose whether users view files with Excel Services or Excel Web App. If the administrator chooses to view workbooks with Excel Web App, you can’t view Power View sheets when viewing Excel workbooks in the browser.

In Office 365, you view Power View sheets with Excel Web App Data Center, part of SharePoint Online, rather than with Excel Services.


Power View sheets can’t be viewed on SkyDrive.

If you save an Excel workbook with Power View sheets to a PowerPivot Gallery, the Power View sheets in the workbook won’t be displayed in the Gallery, but they are still in the file. You’ll see them when you open the workbook.

September 7, 2012 3:13 AM

SSIS Junkie : Power View in SkyDrive said:

October 17, 2012 12:00 PM

Leave a Comment


This Blog


Privacy Statement