Share via


How to: Publish a Report Model (Model Designer)

When you are ready to publish your report model project to the report server, you need to publish the data source, data source view, and report model files. After the initial publication of the report model project, you can continue to modify and redeploy just the report model (.smdl file). The data source view (.dsv) information is embedded as a part of the .smdl file, so when you redeploy the .smdl file, the .dsv information in the .smdl is also updated. If the database is modified, the data source view and model files need to be updated and published again in order to reflect these changes in Report Builder. After deploying the model, check the error list to see if there are any warnings or errors. Once the model is published, you can assign security permissions. For more information, see Securing Models or How to: Set Permissions on Model Items (Reporting Services in SharePoint Integrated Mode).

To deploy a report model project

  1. With your model project open in Business Intelligence Development Studio, on the Project menu, click Properties.

    The <project> Properties Page dialog opens.

  2. Choose the Configuration you want to use to publish your project.

    For example, Active(Debug) or Production.

  3. In the Deployment section, optionally, if you want to be able to overwrite previously deployed projects, click the down arrow and select True.

  4. Optionally, for the TargetDataSourceFolder, type the name of the folder where you want to store your shared data source.

    Note

    In native mode, type the full path of the hierarchy starting at the root. For example, Folder1/Folder2/Folder3. In SharePoint integrated mode, type a URL to a library or library folder. For example, http://TestServer/TestSite/Documents/DataSources.

  5. For TargetModelFolder, type the name of the folder in which to store the published model.

    A value must be specified for this property.

    Note

    In native mode, type the full path of the hierarchy starting at the root. For example, Folder1/Folder2/Folder3. In SharePoint integrated mode, type a URL to a library or library folder. For example, http://TestServer/TestSite/Documents/Models.

  6. For TargetServerURL, type URL for the target report server.

    A value must be specified for this property.

    Note

    In native mode, type the URL of the virtual directory of the report server. For example, https://servername/reportserver. In SharePoint integrated mode, type a URL to a SharePoint top-level site or subsite. For example, https://servername, https://servername/site or https://servername/site/subsite.

  7. Click OK.

  8. On the Build menu, click Deploy.

    The data source (.ds) and the report model (.smdl) are published to the report server or SharePoint library that you specified in the Property Pages dialog box. The data source view (.dsv) file is combined with the report model so this file is not visible on the report server. On subsequent changes to the model, you need only publish the report model (.smdl) file.

To deploy a report model file

  • In Solution Explorer, right-click the report model file and click Deploy.

    The Output window displays the progress of the deployment.