Friday, 3 January 2014

Upload a Report Model to Report Server (without deploying it via BIDS)


Deploying a report model to a reporting server, it embeds the data source (.dsv) file into the report model (.smdl) file automatically. When we need to upload a single report model file to the report server, we can manually copy the entire code of the .dsv file into the .smdl file just before the </SemanticModel> attribute which is in the last line.

No comments:

Post a Comment

Updating massive amount of rows whilst avoiding blocking

The following SQL is a good means to split an update on a massive table into smaller chunks, whilst reducing blocking. The method is to upda...