Tuesday, June 12, 2012 4:37 PM
I'm trying to build a dashboard with a Filter Webpart and a connection in the SharePoint Data Connection library.
I copied the URL in the properties of OLAPPortfolioAnalyzer.odc which contains several "%20" for each space in the path.
But when I paste the URL, the system removes all these "%20" and then I get the warning: "The connection URL cannot be solved in valid data connection, or solves in incorrect data connection type".
How can I find the correct URL?
Tuesday, June 12, 2012 6:57 PM
I've had some issues using the ODCs that are created out of the box with the Filter Webpart. The out of box ODCs seem to be missing something that allows the filter webpart to use it.
You can create a new one using the Data Connection Wizard in Excel 2010 and then exporting the internal Office Data Connection that is created subsequently, to SharePoint.
Once it is up on SharePoint, the filter webpart should see it correctly and be able to use it.
- Marked As Answer by WLID1966 Wednesday, June 13, 2012 12:55 PM
Wednesday, June 13, 2012 12:55 PM
Thanks a lot Treb,
I created my own ODC file and was able to use it in the Filter Webpart!