I have uploaded a PowerPivot workbook to the PowerPivot Gallery and I am now attempting to use it as a data source for PerformancePoint, but I keep receiving the following error when making the connection in Dashboard Designer:
An error occurred connecting to this data source. Please check the data source for any unsaved changes and click on Test Data Source button to confirm connection to the data source.
The file is not open and the Test Data Source button is greyed out. What is the proper URL syntax? I'm not sure if the URL is the problem either. Any help would be appreciated.