locked
Shared Data Source in SharePoint for SSDT RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

      I created a Shared Data Source from SSDT and deployed in SP 2013 "Data Source" Library (read permission for everyone), Name is "AdvanceWork". share to "Everyone". and in rds, set correct credentials, test connect is OK.

    Now I tried to use this DS to create a new Report. my step is this

    1. New report project => Share Data Sources => Name: AdvanceWork; Type: SharePoint List; Connection String: http://portal.contoso.com/sites/BI/SSRS Data Sources/.

    2. add new report, in wizard's query designer, post a query that work in SQL MS SSMS, but get error is this.

    An error occurred while retrieving the parameters in the query.

    The SharePoint list query is not valid: Data at the root is invalid. Line 1, Position 1.

    Additional information:

    The SharePoint list query is not valid: Data at the root is invalid. Line 1, Position 1.

    (Microsoft.ReportingServices.DataExtensions)

    Does anybody knows how to resolve ?

    Thanks

    James Liang

    Thursday, December 17, 2015 7:08 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi JamesLiang,

    According to your description, you have created a shared data source in SSDT and deploy the data source to SharePoint site. Then you want to use this deployed data source in SSDT to create a new report, right?

    In Reporting Services, when you create a shared data source in SSDT, the file extension is .rds. When we publish a shared data source (.rds) file to a SharePoint site, this changes the data source file to an .rsds file name extension. The .rsds file cannot be saved locally from a SharePoint site and imported into an existing Reporting Services project. Shared data sources with file name extensions .rds and .rsds are not interchangeable.

    So in your scenario, it’s not supported to use the shared data source which has been deployed to SharePoint site to create a new report in SSDT. To work around the issue, you can create a new shared data source in Reporting Services project with the same properties as the deployed shared data source in SSDT. For more information, please refer to articles below:

    Shared Data Sources
    Rds and Rsds files – There is an error in XML document (2,2) (System.Xml)

    By the way, the Microsoft SharePoint List data source type is used for connecting and retrieving SharePoint list data. Please refer to this article: SharePoint List Connection Type (SSRS).
     
    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu

    Qiuyun Yu
    TechNet Community Support


    Friday, December 18, 2015 8:17 AM