Forum Discussion
Paginated reports - stored procedures
PowerDinosaur wrote:
I have come accross paginated reports and stored procedures. How is this really works with import mode ?
It does not work with import mode at all.
PBIRS supports 2 different types of reports:
- Power BI - PBIX based reports
- Paginated reports
They are different styles of reports that are not really connected to each other.
Power BI reports are better suited to aggregate style reports where you a doing group bys and filters and are doing sum/avg/min/max over numeric columns.
Paginated reports are better suited to fixed output where you might have specific tables with a fixed list of columns and maybe some simple charting. If you have stored procedures where you want to pass in some parameter values and then produce the same fixed output each time then paginated reports are a good solution. The only downside is that they are not quite as easy to build and there can be a bit of a learning curve.
Super User
PowerDinosaur wrote:
I have come accross paginated reports and stored procedures. How is this really works with import mode ?
It does not work with import mode at all.
PBIRS supports 2 different types of reports:
- Power BI - PBIX based reports
- Paginated reports
They are different styles of reports that are not really connected to each other.
Power BI reports are better suited to aggregate style reports where you a doing group bys and filters and are doing sum/avg/min/max over numeric columns.
Paginated reports are better suited to fixed output where you might have specific tables with a fixed list of columns and maybe some simple charting. If you have stored procedures where you want to pass in some parameter values and then produce the same fixed output each time then paginated reports are a good solution. The only downside is that they are not quite as easy to build and there can be a bit of a learning curve.