cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerDinosaur
Frequent Visitor

Paginated reports - stored procedures

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!

1 ACCEPTED SOLUTION
d_gosbell
Super User
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.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

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
Super User
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.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.