topic Re: Connecting Power BI Rpt and Paginated Rpt in Report Server

Connecting Power BI Rpt and Paginated Rpt

JAFpwrBI_002 — Tue, 25 Jun 2024 13:14:52 GMT

Hi all,

I have a power bi report that's connected to a cube, the report focuses on a summarised view of hours by employee. We also have a paginated report that shows a detailed breakdown of hours by people, that's at a more granular level and is using a different datasource (stored proc) - the data points, attributes and parameters are pretty much identical.

Is it possible to connect the 2 together? - for example, in an ideal world i would want to drill through on an employee from the summary view (cube connection) to the detailed view (different connection).

Thanks in Advance

Re: Connecting Power BI Rpt and Paginated Rpt

ajohnso2 — Tue, 25 Jun 2024 13:59:21 GMT

Its entirely possible to do this, ensure you are passing across to the paginated report any values that would be required to filter. In paginated reports you can fire the values collected from your desktop pbix and use them in your store proc call such as e.g.

EXEC yourstoredproc (@Param1, @Param2 etc...)

Re: Connecting Power BI Rpt and Paginated Rpt

lbendlin — Tue, 25 Jun 2024 14:12:08 GMT

Consider using a paginated report visual in your regular report.

NOTE: Paginated reports are rendered on demand, and the user experience will likely be unsatisfactory when your users have to wait for a rerendering each time they change filters.