I'm trying to connect a published Excel workbook as a data source in PerformancePoint Designer, but I'm unable to do so. Here's what I'm doing:
In PPDD, on the Create tab, I click Data Source. I pick Excel Services as the template. Then I name the DS in the column on the left. Then I enter the URL for the BI-center, like http://myspserver.fqdn/sites/BI-center. The Document Library drop-down is then populated with all the available libraries, indicating a connection is made. I select the library called Documents, where the Excel workbook is located. Then I try to open the Excel Workbook drop-down, but it's empty, thus I'm unable to continue further.
One strange thing is, that if I create a New Report instead of a DS, go through the same steps, the drop-down populates and I'm able to locate the Excel workbooks and then select Named items just fine. However, I need a DS.
Hav you seen anything like this before?
Regards, Thomas Paulsen