Using a PowerPivot workbook from SharePoint with a too long url in PowerPivot

By | May 8, 2010

Today i was using the PowerPivot management dashboard data as a PowerPivot source. This workbook has an a filename deep in SharePoint, in my case : “http://sp2010rc:5566/PowerPivot Management/466f3002-543f-4c06-93bf-4d922641a73f/PowerPivot Management Data.xlsx”.

Getting this imported into PowerPivot takes some extra work because there is a small bug in PowerPivot that makes it impossible to put the above URL as filename, as you can see in the screenshot below:

You can workaround this when you click on advanced, where you can past the filename in the datasource:

This will work.