Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Connection URL cannot be solved in valid data connection

Answered Connection URL cannot be solved in valid data connection

  • Tuesday, June 12, 2012 4:37 PM
     
     
    Sign In to Vote
    0

    Hello,

    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?

    Thanks

     

All Replies

  • Tuesday, June 12, 2012 6:57 PM
     
     Answered
    Sign In to Vote
    1

    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.

    Thanks!

    Treb Gatte

    • Marked As Answer by WLID1966 Wednesday, June 13, 2012 12:55 PM
    •  
     
  • Wednesday, June 13, 2012 12:55 PM
     
     
    Sign In to Vote
    0

    Thanks a lot Treb,

    I created my own ODC file and was able to use it in the Filter Webpart!

    Great!