Microsoft SharePoint 2013:Creating a Power View report in the document library using shared data source

From PlexHosted Knowledgebase
Jump to: navigation, search
Dedicated SharePoint Hosting Services at PlexHosted

In order for Power View to connect to a multidimensional model, you must create a shared report data source definition, also known as an .rsds file, in a SharePoint library. RSDS files can connect to many different data sources, but Power View only supports Microsoft BI Semantic Model for Power View data sources. The advantage of RSDS connection files is that you can specify credentials. This article describes how to create a RSDS connection file.

Creating a Power View report in the document library using shared data source (RSDS) connection file

  1. Login to the SharePoint 2013 site as an administrator
  2. Navigate to the document library in which you are going to create your RSDS connection file and Power View report
    Rsds connection file 1.png
  3. Go to the Library tab and click on Library Settings
    Rsds connection file 2.png
  4. Navigate to the Advanced Settings
    Rsds connection file 3.png
  5. Choose Yes under Allow management of content types? and click OK
    Rsds connection file 4.png
  6. Under the Content Types click on the Add from the existing site content types hyperlink
    Rsds connection file 5.png
  7. Choose Report Data Source from the available site content types, click Add and then OK
    Rsds connection file 6.png
  8. Return to your document library, in the Files tab click New Document and choose Report Data Source
    Rsds connection file 7.png
  9. Enter the name for your RSDS file and choose Microsoft BI Semantic Model for Power View from the Data Source Type menu
    Rsds connection file 8.png
  10. In the Connection String field enter a pointer to the data source in the following format: Data Source=http://yourdomain.com/Shared Documents/YourWorkbook.xlsx
    If you are using a workbook from the PowerPivot Gallery the pointer will be like: Data Source=http://yourdomain.com/PowerPivot%20Gallery/YourWorkbook.xlsx
    Rsds connection file 9.png
  11. In Credentials leave Windows authentication (integrated) or SharePoint user option selected and click on Test Connection. If connection created successfully, click OK
    Rsds connection file 10.png
  12. Now you can see your shared data source (RSDS) connection file. Click on it to create a Power View report
    Rsds connection file 11.png
  13. Create your report and click on Save as in the File menu
    Rsds connection file 12.png
  14. Now you are prompted to save report to the document library. Provide the name for your report and click Save
    Rsds connection file 13.png
  15. Return to the document library and refresh the page. You can see your Power View report created using the shared data source (RSDS) connection file
    Rsds connection file 14.png