Forum Discussion

JAFpwrBI_002's avatar
JAFpwrBI_002
Regular Visitor
2 years ago
Solved

Connecting Power BI Rpt and Paginated Rpt

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 hour...
  • ajohnso2's avatar
    2 years ago

    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's avatar
    2 years ago

    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.