Paginated reports - stored procedures

[PowerDinosaur]

Hi guys!

I am currently working in an enviroment with:

- PBRS

-import mode

- and an ODBC connector to a database that I'm not allowed to name.

The problem is that currently we have to load tables with 20-100 million rows of data and sometimes we have columns where 1 cell contains ~20 pages long strings. We were looking for solutions (unfortunatelly Direct Query is not an option with this database and connector) to make the import faster. I have come accross paginated reports and stored procedures. How is this really works with import mode ? The user can choose from parameters and the paginated report only imports the data that is filtered ? Or it imports firstly everything?

Thank you for your help in advance and have a nice day!

[v-henryk-mstf]

Hi @PowerDinosaur ,

Whether the advice given by @d_gosbell  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[d_gosbell · Accepted solution]

---

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