none
Error in Accessing the Report Server URL

    Question

  • Hi All,

              I am trying to access the Report Server URL in PowerPivot.But facing below issue .Can any one help me how can I solve the issue


    Thanks,  

    Sid


    • Edited by siddiqali Thursday, May 01, 2014 10:17 AM
    Thursday, May 01, 2014 10:16 AM

Answers

  • Hi Visakh,

                    Yes,The user is holding the permission as "Global User" in sql.Hope you help me in solve this issue


    Thanks, Quality Communication Provides Quality Work. http://siddiq-sharepoint2010.blogspot.in/ Siddiqali Mohammad .

    Hi siddiqali,

    According to the screenshot you posted above, the use account didn't have sufficient permission to open the report, please check the following prerequisites before you perform the action:

    • You must use a report definition (.rdl) file as a data source. Importing from a report model is not supported.
    • You must have permission to open the report under your Windows user account, and you must know the address of the report or the report server that hosts it. You can check your permissions by trying to open the report in a Web browser first. If the report opens, it confirms that you have sufficient permissions and the correct URL.
    • Reporting Services must be version SQL Server 2008 R2 or SQL Server 2012. Those versions include the data feed export feature that streams report data in the XML data feed format. You can identify the report server by the Export as Data Feed option that appears in the report toolbar when you open the report in browser:
      GMNI_IconDataFeed

    For detail information, please see:
    Import Data from a Reporting Services Report: http://technet.microsoft.com/en-us/library/gg413491.aspx

    Regards,


    Elvis Long
    TechNet Community Support

    Monday, May 05, 2014 7:26 AM
    Moderator

All replies

  • Does the account  you use have access to connect to report server.

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Thursday, May 01, 2014 10:18 AM
  • Hi Visakh,

                    Yes,The user is holding the permission as "Global User" in sql.Hope you help me in solve this issue


    Thanks, Quality Communication Provides Quality Work. http://siddiq-sharepoint2010.blogspot.in/ Siddiqali Mohammad .

    Friday, May 02, 2014 12:37 PM
  • Hi Visakh,

                    Yes,The user is holding the permission as "Global User" in sql.Hope you help me in solve this issue


    Thanks, Quality Communication Provides Quality Work. http://siddiq-sharepoint2010.blogspot.in/ Siddiqali Mohammad .

    Hi siddiqali,

    According to the screenshot you posted above, the use account didn't have sufficient permission to open the report, please check the following prerequisites before you perform the action:

    • You must use a report definition (.rdl) file as a data source. Importing from a report model is not supported.
    • You must have permission to open the report under your Windows user account, and you must know the address of the report or the report server that hosts it. You can check your permissions by trying to open the report in a Web browser first. If the report opens, it confirms that you have sufficient permissions and the correct URL.
    • Reporting Services must be version SQL Server 2008 R2 or SQL Server 2012. Those versions include the data feed export feature that streams report data in the XML data feed format. You can identify the report server by the Export as Data Feed option that appears in the report toolbar when you open the report in browser:
      GMNI_IconDataFeed

    For detail information, please see:
    Import Data from a Reporting Services Report: http://technet.microsoft.com/en-us/library/gg413491.aspx

    Regards,


    Elvis Long
    TechNet Community Support

    Monday, May 05, 2014 7:26 AM
    Moderator