SQL PASS Vancouver

Authored by

Luca Gualtieri

Raymond D'Lima


4 min read

Share this article

PBI Lab can be found nerding out in the wild tonight, presenting "Power BI Report Server: A Deep Dive" at PASS Vancouver.

Where:

2500-555 W Hastings St, Vancouver, BC
Vancouver, British Columbia, Canada V6B 4N5

DirectionsElevators to the 25th floor are located by the security desk on the W. Hastings side.

Please RSVP here.

Session Outline:

The session is for users who are familiar with the Power BI Report Server (PBIRS), are interested in more advanced topics, and want to go the extra mile. 

Session Format:

In this session, Luca Gualtieri is going to open a Live Power BI Dashboard which collects and shows survey responses (in real-time) about the attendees’ level of expertise using PBIRS, and their favorite topics. The dashboard works on top of a streaming dataset. 

Attendees wil answer questions on a Survey developed with Microsoft Forms. Responses will be shown on his Live Power BI dashboard - displaying the magic of using Microsoft Flow as an automation tool, connecting Forms and Power BI.

This is a creative, interactive way for Luca to gauge the overall level of expertise of the attendees, and tailor the presentation accordingly. 

In this session we are going to discuss basic topics including: 

  • Different editions / licensing for PBIRS
  • Branding for PBIRS
  • Configuring Advanced Options through SSMS (SQL Server Management Studio)
  • Embedding PBIRS reports
  • Monitoring the Report Server catalog
  • Using the REST-API
  • PBIRS security, and
  • Custom roles in PBIRS.

We will also touch on more advanced concepts such as: 

  • High availability
  • Disaster recovery, and
  • Configuring your report server to host Excel workbooks using Office Online Server.

PlentyOfFish Media ULC has generously sponsored both the pizza and location for this event, so feel free to contact them or click on the link to view current opportunities at this fast-paced organization with one of the largest deployments of SQL Server in North America.  

Please grab a ticket to let them know you are coming and visit them at vancouver.pass.org for more info.

Newsletter

Our detailed articles, and technical white papers on the latest in BI news and technologies, curated and delivered to you via an editorial email newsletter.