×

Property Data Engineering Sprint - Part 5

Integrated Power BI with SSRS for seamless navigation between dashboards and paginated reports using parameterized hyperlinks.

User Flow SSRS Report From PowerBI With Relevant Filters

Project Overview

  • Objective: Connect Power BI visuals to SSRS reports using dynamic hyperlinks that pass filter parameters directly into the SSRS web portal.
  • Tools Used: Power BI, SSRS Web Portal, DAX, Dynamic URL Generation, Matrix Visualization


Integration Highlights

  • Each Power BI page (House Value, Rental Value, Schools, Transport, Crime) includes a matrix or button that hyperlinks to an SSRS report.
  • Hyperlinks are dynamically generated using DAX to pass state_code, city, and suburb as URL parameters.
  • SSRS reports were deployed to the SSRS web portal, ready to receive these parameters and render filtered output automatically.
  • This navigation allows users to jump from a summarized view in Power BI to a detailed report in SSRS with the same filters applied.


Workflow & Features

  • Deployed SSRS reports to web server (local test: http://localhost/Reports).
  • Created calculated DAX column in Power BI for hyperlink URL.
  • Used matrix visual to display a table of locations with the dynamic hyperlink.
  • Clicking the link opens the SSRS report in the browser with filters pre-selected.


Parameterization Example

"http://localhost/Reports/report/PropertyReports/HouseValueReport
?state_code=" & dim_suburb[state_code] &
"&city=" & dim_suburb[city] &
"&suburb=" & dim_suburb[suburb]

Key Skills Demonstrated

  • Parameter passing between Power BI and SSRS reports.
  • Dynamic hyperlink generation in DAX.
  • SSRS report publishing and configuration via the web portal.
  • Creating a seamless cross-platform user experience for report consumption.


Links



Back to Portfolio