SSRS Reporting Services - Site Settings security with PowerShell

Handy little PowerShell to automate adding a User or a Group to Site Settings of SSRS 2008 R2:

$rs = New-WebServiceProxy -uri "http://server/reportserver/ReportService2010.asmx?WSDL" -UseDefaultCredential -namespace "ReportingService2010" -class Reporting

$existingpolicies = $rs.GetSystemPolicies()
$Policy = New-Object -TypeName "ReportingService2010.Policy"
$Roles = @()
$Role = New-Object -TypeName "ReportingService2010.Role"
$Role.Name = "System User"
$Roles += $Role
$Policy.Roles = $Roles
$Policy.GroupUserName = "DOMAIN\USERORGROUP"

$PolicyAlreadyExists = $false

$existingpolicies | Foreach-Object{
if ($_.GroupUserName -eq "DOMAIN\USERORGROUP")
{$PolicyAlreadyExists = $true} }

$Policies = @($existingpolicies)


$Policies += $Policy


if(-not $PolicyAlreadyExists)
{
$rs.SetSystemPolicies($Policies)
}



based on https://social.technet.microsoft.com/Forums/sqlserver/en-US/ea8824fb-e1c4-4266-9e73-ef00a6c0a6cd/site-settings-security-using-rss-scripts?forum=sqlreportingservices

Toggle Visibility Show As Expanded + – in SSRS

Very helpful post that describes how to set the group to be expanded by default and so that the signs are shown correctly (+ and -)

http://bicg.com.au/toggle-visibility-show-as-expanded-in-ssrs/

Connecting to SQL Server Mobile Report Publisher in SSRS 2016 RC2

I was struggling a bit with connecting to SQL Server Mobile Report Publisher in SSRS 2016 RC2. When I wanted to load data from Data Sets that are created in SSRS, I had to connect to SSRS first. I was presented with a very laconic UI, and I had to struggle with a couple of errors, without seeing any details of what was wrong.

 
Now, I eventually figured out that Server Address, apparently expects the URL of this type:

http://localhost/reports

and Username and Password are your Domain accounts and "Use secure connection" must be unchecked!

 


Only then it started working, and I was able to see my DataSets and Data Sources.