Blog Archives

Linking Data Sources to SSRS Reports with PowerShell

Imagine the following scenario: You just migrated a bunch of SSRS Reports to a new Reporting Services instance, which has a different folder structure. In this perspective, one of the things that get lost along the way is the linking between Data Sources and Reports.

If you are in the PowerShell world like me you know very well this repository in the Microsoft organization on Github: ReportingServicesTools.

Reporting Services Tools is a module that interacts with Microsoft SQL Server Reporting Services, making it easier several tasks like importing and exporting reports, creating folders, subscriptions, data sources and so on. The module is maintained by Microsoft along with some know PowerShell folks from the community like my friend Claudio Silva(@claudioessilva) from the dbatools team. Read the rest of this entry

24 Horas de PASS– Edição em Português

Olá pessoal,

Nos próximos dias 29 e 30 de Novembro teremos mais uma edição do 24 Horas de PASS – Edição em Português. O evento já é bastante conhecido da comunidade técnica Microsoft de Data Platform.

Como todos sabem o evento é 100% gratuito e online, então sem desculpas para não participar. Nessa edição terei o prazer de realizar uma apresentação sobre Power BI Report Server e falar um pouco mais sobre esse modelo de Power BI e como sua organização pode também obter. Então, segue abaixo os detalhes de minha apresentação. Read the rest of this entry

Creating Custom SSRS Security Roles

When you have a consolidated environment, usually you don’t want to set very broad permissions to users, most of the times you only want them to see what is really necessary.

Doing that in the Database Engine is quite easy, but what about Reporting Services? We know that SSRS exposes the following default roles: Browser, Content Manager, My Reports, Publisher and Report Builder. However, for me sometimes those roles offer too much to the user.

What people usually don’t know is that you can connect to your SSRS Instance using SQL Server Management Studio and then create customized roles. So, let me show you how to do it. Read the rest of this entry