Connecting Power BI Rpt and Paginated Rpt

[JAFpwrBI_002]

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

[ajohnso2 · Accepted solution]

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...)

[lbendlin · Accepted solution]

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.

[ajohnso2 · Accepted solution]

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...)